?? dbdwxx.cs
字號:
using System;
using CallCenter.IDAL;
using CallCenter.Modules;
using System.Data;
using System.Data.SqlClient;
using System.Data.OracleClient;
using System.Collections;
using System.Text;
using System.IO;
namespace CallCenter.OracleDAL
{
/// <summary>
///
/// </summary>
public class DBDwxx:IDwxx
{
public DBDwxx()
{
//
// TODO: 在此處添加構造函數邏輯
//
}
#region IDwxx 成員
public int getDwbmCount(string dwbm)
{
DwxxInfo info = new DwxxInfo();
string selSql = "SELECT count(*) From dwxx WHERE dwbm=@dwbm";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@dwbm",SqlDbType.VarChar,50),
};
param[0].Value = dwbm;
try
{
int i = Convert.ToInt32(OraHelper.SqlserverExecuteScalar(OraHelper.GetSqlserverConnection(),CommandType.Text,selSql,param));
return i;
}
catch(Exception e)
{
throw e;
}
}
public int addDwxx(DwxxInfo info)
{
if( info == null)
throw new Exception("The Sysoperator Object is null,Can't Save Null object!");
//判斷單位編碼是否重復
if(getDwbmCount(info.dwbm)>0)
{
return -1;
}
string addSql = "INSERT INTO dwxx(dwmc, dwbm, dwxz, khly, sf, cs, yzbm, xxdz, qh, dh, yddh, cz, dzyx, dwrs, dwnsr, dwzc,dwlxr, xb, nl, zy, zw, whcd, yyah, bz) VALUES(@dwmc, @dwbm, @dwxz, @khly, @sf, @cs, @yzbm, @xxdz, @qh, @dh, @yddh, @cz, @dzyx, @dwrs, @dwnsr, @dwzc,@dwlxr, @xb, @nl, @zy, @zw, @whcd, @yyah, @bz)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@dwmc",SqlDbType.VarChar,100),
new SqlParameter("@dwbm",SqlDbType.VarChar,50),
new SqlParameter("@dwxz",SqlDbType.VarChar,50),
new SqlParameter("@khly",SqlDbType.VarChar,50),
new SqlParameter("@sf",SqlDbType.VarChar,50),
new SqlParameter("@cs",SqlDbType.VarChar,50),
new SqlParameter("@yzbm",SqlDbType.VarChar,50),
new SqlParameter("@xxdz",SqlDbType.VarChar,200),
new SqlParameter("@qh",SqlDbType.VarChar,50),
new SqlParameter("@dh",SqlDbType.VarChar,50),
new SqlParameter("@yddh",SqlDbType.VarChar,50),
new SqlParameter("@cz",SqlDbType.VarChar,50),
new SqlParameter("@dzyx",SqlDbType.VarChar,50),
new SqlParameter("@dwrs",SqlDbType.Int,4),
new SqlParameter("@dwnsr",SqlDbType.Decimal,9),
new SqlParameter("@dwzc",SqlDbType.Decimal,9),
new SqlParameter("@dwlxr",SqlDbType.VarChar,50),
new SqlParameter("@xb",SqlDbType.VarChar,50),
new SqlParameter("@nl",SqlDbType.Int,4),
new SqlParameter("@zy",SqlDbType.VarChar,50),
new SqlParameter("@zw",SqlDbType.VarChar,50),
new SqlParameter("@whcd",SqlDbType.VarChar,50),
new SqlParameter("@yyah",SqlDbType.VarChar,50),
new SqlParameter("@bz",SqlDbType.VarChar,2000),
};
param[0].Value = info.dwmc;
param[1].Value = info.dwbm;
param[2].Value = info.dwxz;
param[3].Value = info.khly;
param[4].Value = info.sf;
param[5].Value = info.cs;
param[6].Value = info.yzbm;
param[7].Value = info.xxdz;
param[8].Value = info.qh;
param[9].Value = info.dh;
param[10].Value = info.yddh;
param[11].Value = info.cz;
param[12].Value = info.dzyx;
param[13].Value = info.dwrs;
param[14].Value = info.dwnsr;
param[15].Value = info.dwzc;
param[16].Value = info.dwlxr;
param[17].Value = info.xb;
param[18].Value = info.nl;
param[19].Value = info.zy;
param[20].Value = info.zw;
param[21].Value = info.whcd;
param[22].Value = info.yyah;
param[23].Value = info.bz;
try
{
OraHelper.SqlserverExecuteNonQuery(OraHelper.GetSqlserverConnection(),CommandType.Text,addSql,param);
}
catch(Exception e)
{
throw e;
}
finally
{
;
}
return 1;
}
public int updateDwxx(DwxxInfo info)
{
if( info == null)
throw new Exception("The Sysoperator Object is null,Can't Save Null object!");
//判斷身份證號是否重復
// if(info.sfzh.Equals(this.getGrxxByid(info.id).sfzh))
// {
// return -1;
// }
string updateSql = "UPDATE Dwxx SET dwmc=@dwmc, dwbm=@dwbm, dwxz=@dwxz, khly=@khly, sf=@sf, cs=@cs, yzbm=@yzbm, xxdz=@xxdz, qh=@qh, dh=@dh, yddh=@yddh, cz=@cz, dzyx=@dzyx, dwrs=@dwrs, dwnsr=@dwnsr, dwzc=@dwzc,dwlxr=@dwlxr, xb=@xb, nl=@nl, zy=@zy, zw=@zw, whcd=@whcd, yyah=@yyah, bz=@bz WHERE id=@id";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@id",SqlDbType.Int,4),
new SqlParameter("@dwmc",SqlDbType.VarChar,100),
new SqlParameter("@dwbm",SqlDbType.VarChar,50),
new SqlParameter("@dwxz",SqlDbType.VarChar,50),
new SqlParameter("@khly",SqlDbType.VarChar,50),
new SqlParameter("@sf",SqlDbType.VarChar,50),
new SqlParameter("@cs",SqlDbType.VarChar,50),
new SqlParameter("@yzbm",SqlDbType.VarChar,50),
new SqlParameter("@xxdz",SqlDbType.VarChar,200),
new SqlParameter("@qh",SqlDbType.VarChar,50),
new SqlParameter("@dh",SqlDbType.VarChar,50),
new SqlParameter("@yddh",SqlDbType.VarChar,50),
new SqlParameter("@cz",SqlDbType.VarChar,50),
new SqlParameter("@dzyx",SqlDbType.VarChar,50),
new SqlParameter("@dwrs",SqlDbType.Int,4),
new SqlParameter("@dwnsr",SqlDbType.Decimal,9),
new SqlParameter("@dwzc",SqlDbType.Decimal,9),
new SqlParameter("@dwlxr",SqlDbType.VarChar,50),
new SqlParameter("@xb",SqlDbType.VarChar,50),
new SqlParameter("@nl",SqlDbType.Int,4),
new SqlParameter("@zy",SqlDbType.VarChar,50),
new SqlParameter("@zw",SqlDbType.VarChar,50),
new SqlParameter("@whcd",SqlDbType.VarChar,50),
new SqlParameter("@yyah",SqlDbType.VarChar,50),
new SqlParameter("@bz",SqlDbType.VarChar,2000),
};
param[0].Value = info.id;
param[1].Value = info.dwmc;
param[2].Value = info.dwbm;
param[3].Value = info.dwxz;
param[4].Value = info.khly;
param[5].Value = info.sf;
param[6].Value = info.cs;
param[7].Value = info.yzbm;
param[8].Value = info.xxdz;
param[9].Value = info.qh;
param[10].Value = info.dh;
param[11].Value = info.yddh;
param[12].Value = info.cz;
param[13].Value = info.dzyx;
param[14].Value = info.dwrs;
param[15].Value = info.dwnsr;
param[16].Value = info.dwzc;
param[17].Value = info.dwlxr;
param[18].Value = info.xb;
param[19].Value = info.nl;
param[20].Value = info.zy;
param[21].Value = info.zw;
param[22].Value = info.whcd;
param[23].Value = info.yyah;
param[24].Value = info.bz;
try
{
return OraHelper.SqlserverExecuteNonQuery(OraHelper.GetSqlserverConnection(),CommandType.Text,updateSql,param);
}
catch(Exception e)
{
throw e;
}
finally
{
;
}
}
public int delDwxx(string ids)
{
string delSql = "DELETE FROM dwxx WHERE id IN('"+ids.Replace("'","''").Replace(",","','")+"')";
try
{
int val=OraHelper.SqlserverExecuteNonQuery(OraHelper.GetSqlserverConnection(),CommandType.Text,delSql,null);
return val;
}
catch(Exception e)
{
throw e;
}
finally
{
;
}
}
public DwxxInfo getDwxxByid(int id)
{
DwxxInfo info = new DwxxInfo();
string selSql = "SELECT id,dwmc, dwbm, dwxz, khly, sf, cs, yzbm, xxdz, qh, dh, yddh, cz, dzyx, dwrs, dwnsr, dwzc,dwlxr, xb, nl, zy, zw, whcd, yyah, bz FROM dwxx WHERE id=@id";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@id",SqlDbType.Int,4),
};
param[0].Value = id;
try
{
SqlDataReader dr = OraHelper.SqlserverExecuteReader(OraHelper.GetSqlserverConnection(),CommandType.Text,selSql,param);
if(dr.Read())
{
info.id= dr.IsDBNull(0)?0:dr.GetInt32(0);
info.dwmc = dr.IsDBNull(1)?"":dr.GetString(1);
info.dwbm = dr.IsDBNull(2)?"":dr.GetString(2);
info.dwxz = dr.IsDBNull(3)?"":dr.GetString(3);
info.khly = dr.IsDBNull(4)?"":dr.GetString(4);
info.sf = dr.IsDBNull(5)?"":dr.GetString(5);
info.cs = dr.IsDBNull(6)?"":dr.GetString(6);
info.yzbm = dr.IsDBNull(7)?"":dr.GetString(7);
info.xxdz = dr.IsDBNull(8)?"":dr.GetString(8);
info.qh = dr.IsDBNull(9)?"":dr.GetString(9);
info.dh = dr.IsDBNull(10)?"":dr.GetString(10);
info.yddh = dr.IsDBNull(11)?"":dr.GetString(11);
info.cz = dr.IsDBNull(12)?"":dr.GetString(12);
info.dzyx = dr.IsDBNull(13)?"":dr.GetString(13);
info.dwrs = dr.IsDBNull(14)?0:dr.GetInt32(14);
info.dwnsr = dr.IsDBNull(15)?0:dr.GetDecimal(15);
info.dwzc = dr.IsDBNull(16)?0:dr.GetDecimal(16);
info.dwlxr = dr.IsDBNull(17)?"":dr.GetString(17);
info.xb = dr.IsDBNull(18)?"":dr.GetString(18);
info.nl = dr.IsDBNull(19)?0:dr.GetInt32(19);
info.zy = dr.IsDBNull(20)?"":dr.GetString(20);
info.zw = dr.IsDBNull(21)?"":dr.GetString(21);
info.whcd = dr.IsDBNull(22)?"":dr.GetString(22);
info.yyah = dr.IsDBNull(23)?"":dr.GetString(23);
info.bz = dr.IsDBNull(24)?"":dr.GetString(24);
}
dr.Close();
}
catch(Exception e)
{
throw e;
}
return info;
}
public DataSet getALLDwxx_DataSet(string tableName)
{
string selSql = "SELECT id,dwmc, dwbm, dwxz, khly, sf, cs, yzbm, xxdz, qh, dh, yddh, cz, dzyx, dwrs, dwnsr, dwzc,dwlxr, xb, nl, zy, zw, whcd, yyah, bz FROM dwxx";
try
{
//return OraHelper.ExecuteDataSet(OraHelper.GetOracleConnection(),CommandType.Text,tableName,selSql,null);
return OraHelper.SqlserverExecuteDataSet(OraHelper.GetSqlserverConnection(),CommandType.Text,tableName,selSql,null);
}
catch(Exception e)
{
throw e;
}
}
// public DataSet getDic_DataSet(string tableName,string id,string name)
// {
// string selSql = "SELECT "+id+","+name+" FROM "+tableName;
//
// try
// {
// return OraHelper.SqlserverExecuteDataSet(OraHelper.GetSqlserverConnection(),CommandType.Text,tableName,selSql,null);
// }
// catch(Exception e)
// {
// throw e;
// }
// }
#endregion
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -