/// <summary>
/// 删除一条数据及其子表
/// </summary>
public bool Delete(int id)
{
Hashtable sqllist = new Hashtable();
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from " + databaseprefix + "advert_banner ");
strSql2.Append(" where aid=@aid ");
OleDbParameter[] parameters2 =
{
new OleDbParameter("@aid", OleDbType.Integer, 4)
};
parameters2[0].Value = id;
sqllist.Add(strSql2.ToString(), parameters2);
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "advert ");
strSql.Append(" where id=@id");
OleDbParameter[] parameters =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters[0].Value = id;
sqllist.Add(strSql.ToString(), parameters);
return(DbHelperOleDb.ExecuteSqlTran(sqllist));
}
/// <summary>
/// 批量添加数据
/// </summary>
/// <param name="modellist"></param>
public static int BatchAdd(List <object> modellist, string TableName)
{
List <DictionaryEntry> SQLStringList = new List <DictionaryEntry>();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into WELL_STATUS (");
strSql.Append("JH,ZB_X,ZB_Y)");
strSql.Append(" values(");
strSql.Append("@JH,@ZB_X,@ZB_Y)");
foreach (Well_statusModel ws in modellist)
{
OleDbParameter[] parameters =
{
new OleDbParameter("@JH", OleDbType.VarChar, 255),
new OleDbParameter("@ZB_X", OleDbType.VarChar, 255),
new OleDbParameter("@ZB_Y", OleDbType.VarChar, 255),
};
parameters[0].Value = ws.JH;
parameters[1].Value = ws.ZB_X;
parameters[2].Value = ws.ZB_Y;
DictionaryEntry de = new DictionaryEntry();
de.Key = strSql.ToString();
de.Value = parameters;
SQLStringList.Add(de);
}
try { return(DbHelperOleDb.ExecuteSqlTran(SQLStringList, TableName)); }
catch { throw; }
}
public bool Delete(int id)
{
Hashtable SQLStringList = new Hashtable();
StringBuilder stringBuilder1 = new StringBuilder();
stringBuilder1.Append("delete from " + this.databaseprefix + "user_group_price ");
stringBuilder1.Append(" where group_id=@group_id ");
OleDbParameter[] oleDbParameterArray1 = new OleDbParameter[1]
{
new OleDbParameter("@group_id", OleDbType.Integer, 4)
};
oleDbParameterArray1[0].Value = (object)id;
SQLStringList.Add((object)stringBuilder1.ToString(), (object)oleDbParameterArray1);
StringBuilder stringBuilder2 = new StringBuilder();
stringBuilder2.Append("delete from " + this.databaseprefix + "user_groups ");
stringBuilder2.Append(" where id=@id");
OleDbParameter[] oleDbParameterArray2 = new OleDbParameter[1]
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray2[0].Value = (object)id;
SQLStringList.Add((object)stringBuilder2.ToString(), (object)oleDbParameterArray2);
return(DbHelperOleDb.ExecuteSqlTran(SQLStringList));
}
public static void YttpjInsert(Yttpj Ytmodel)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PC_XTPL_STATUS (");
strSql.Append("MC,DW,TYRQ,NW,NY,NJ,XN,CN,ZN,GJL,SXQ,JG,BZ,ZT)");
strSql.Append(" values(");
strSql.Append("@MC,@DW,@TYRQ,@NW,@NY,@NJ,@XN,@CN,@ZN,@GJL,@SXQ,@JG,@BZ,@ZT)");
OleDbParameter[] parameters =
{
new OleDbParameter("@MC", Ytmodel.Mc),
new OleDbParameter("@DW", Ytmodel.Dw),
new OleDbParameter("@TYRQ", DateTime.Parse(Ytmodel.Tyrq)),
new OleDbParameter("@NW", Ytmodel.Nw),
new OleDbParameter("@NY", Ytmodel.Ny),
new OleDbParameter("@NJ", Ytmodel.Nj),
new OleDbParameter("@XN", Ytmodel.Xn),
new OleDbParameter("@CN", Ytmodel.Cn),
new OleDbParameter("@ZN", Ytmodel.Zn),
new OleDbParameter("@GJL", Ytmodel.Gjl),
new OleDbParameter("@SXQ", Ytmodel.Sxq),
new OleDbParameter("@JG", Ytmodel.Jg),
new OleDbParameter("@BZ", Ytmodel.Bz),
new OleDbParameter("@ZT", 1),
};
Hashtable sqlTable = new Hashtable
{
{ strSql.ToString(), parameters }
};
try { DbHelperOleDb.ExecuteSqlTran(sqlTable); }
catch { throw; }
}
public static void YyjInfoInsert(Tpjyy tpjyyModel)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PC_XTPY_STATUS (");
strSql.Append("JH,QK,CSRQ,WD,KHD,SJD,QYFS,TPSJ,ZYHD,CSBHD,TCHD,TCSJC,LTFX,SJHD,TSTL,ZSTL,YQD,KXD,KHBJ,BJ,TGSL,TGJL,TXSBL,YMC,GMC,YYL,YND,GYL,GND,GLJ,SGTS,YLSF,JXSJ,HSSJ,XJFD,YXQ,ZY,BZ,ZT)");
strSql.Append(" values(");
strSql.Append("@JH,@QK,@CSRQ,@WD,@KHD,@SJD,@QYFS,@TPSJ,@ZYHD,@CSBHD,@TCHD,@TCSJC,@LTFX,@SJHD,@TSTL,@ZSTL,@YQD,@KXD,@KHBJ,@BJ,@TGSL,@TGJL,@TXSBL,@YMC,@GMC,@YYL,@YND,@GYL,@GND,@GLJ,@SGTS,@YLSF,@JXSJ,@HSSJ,@XJFD,@YXQ,@ZY,@BZ,@ZT)");
OleDbParameter[] parameters =
{
new OleDbParameter("@JH", tpjyyModel.Jh),
new OleDbParameter("@QK", tpjyyModel.Qk),
new OleDbParameter("@CSRQ", DateTime.Parse(tpjyyModel.Csrq)),
new OleDbParameter("@WD", tpjyyModel.Wd),
new OleDbParameter("@KHD", tpjyyModel.Khd),
new OleDbParameter("@SJD", tpjyyModel.Sjd),
new OleDbParameter("@QYFS", tpjyyModel.Qyfs),
new OleDbParameter("@TPSJ", tpjyyModel.Tpsj),
new OleDbParameter("@ZYHD", tpjyyModel.Zyhd),
new OleDbParameter("@CSBHD", tpjyyModel.Csbhd),
new OleDbParameter("@TCHD", tpjyyModel.Tchd),
new OleDbParameter("@TCSJC", tpjyyModel.Tcsjc),
new OleDbParameter("@LTFX", tpjyyModel.Ltfx),
new OleDbParameter("@SJHD", tpjyyModel.Sjhd),
new OleDbParameter("@TSTL", tpjyyModel.Tstl),
new OleDbParameter("@ZSTL", tpjyyModel.Zstl),
new OleDbParameter("@YQD", tpjyyModel.Yqd),
new OleDbParameter("@KXD", tpjyyModel.Kxd),
new OleDbParameter("@KHBJ", tpjyyModel.Khbj),
new OleDbParameter("@BJ", tpjyyModel.Bj),
new OleDbParameter("@TGSL", tpjyyModel.Tgsl),
new OleDbParameter("@TGJL", tpjyyModel.Tgjl),
new OleDbParameter("@TXSBL", tpjyyModel.Txsbl),
new OleDbParameter("@YMC", tpjyyModel.Ymc),
new OleDbParameter("@GMC", tpjyyModel.Gmc),
new OleDbParameter("@YYL", tpjyyModel.Yyl),
new OleDbParameter("@YND", tpjyyModel.Ynd),
new OleDbParameter("@GYL", tpjyyModel.Gyl),
new OleDbParameter("@GND", tpjyyModel.Gnd),
new OleDbParameter("@GLJ", tpjyyModel.Glj),
new OleDbParameter("@SGTS", tpjyyModel.Sgts),
new OleDbParameter("@YLSF", tpjyyModel.Ylsf),
new OleDbParameter("@JXSJ", tpjyyModel.Jxsj),
new OleDbParameter("@HSSJ", tpjyyModel.Hssj),
new OleDbParameter("@XJFD", tpjyyModel.Xjfd),
new OleDbParameter("@YXQ", tpjyyModel.Yxq),
new OleDbParameter("@ZY", tpjyyModel.Zy),
new OleDbParameter("@BZ", tpjyyModel.Bz),
new OleDbParameter("@ZT", 1),
};
Hashtable sqlTable = new Hashtable
{
{ strSql.ToString(), parameters }
};
try { DbHelperOleDb.ExecuteSqlTran(sqlTable); }
catch { throw; }
}
/// <summary>
/// 批量添加数据
/// </summary>
/// <param name="modellist"></param>
public static int BatchAdd(List <object> modellist, string TableName)
{
List <DictionaryEntry> SQLStringList = new List <DictionaryEntry>();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OIL_WELL_C (");
strSql.Append("JH,YCZ,XCXH,XCH,SYDS,YXHD,STL,SKQK,HYBHD,KXD,SYHD)");
strSql.Append(" values(");
strSql.Append("@JH,@YCZ,@XCXH,@XCH,@SYDS,@YXHD,@STL,@SKQK,@HYBHD,@KXD,@SYHD)");
foreach (Oil_well_cModel owc in modellist)
{
OleDbParameter[] parameters =
{
new OleDbParameter("@JH", OleDbType.VarChar, 255),
new OleDbParameter("@YCZ", OleDbType.VarChar, 255),
new OleDbParameter("@XCXH", OleDbType.VarChar, 255),
new OleDbParameter("@XCH", OleDbType.VarChar, 255),
new OleDbParameter("@SYDS", OleDbType.Double, 255),
new OleDbParameter("@YXHD", OleDbType.Double, 255),
new OleDbParameter("@STL", OleDbType.Double, 255),
new OleDbParameter("@SKQK", OleDbType.VarChar, 255),
new OleDbParameter("@HYBHD", OleDbType.Double, 255),
new OleDbParameter("@KXD", OleDbType.VarChar, 255),
new OleDbParameter("@SYHD", OleDbType.VarChar, 255)
};
parameters[0].Value = owc.JH;
parameters[1].Value = owc.YCZ;
parameters[2].Value = owc.XCXH;
parameters[3].Value = owc.XCH;
parameters[4].Value = string.IsNullOrEmpty(owc.SYDS) ? 0 : double.Parse(owc.SYDS);
parameters[5].Value = string.IsNullOrEmpty(owc.YXHD) ? 0 : double.Parse(owc.YXHD);
parameters[6].Value = string.IsNullOrEmpty(owc.STL) ? 0 : double.Parse(owc.STL);
parameters[7].Value = owc.SKQK;
parameters[8].Value = string.IsNullOrEmpty(owc.HYBHD) ? 0 : double.Parse(owc.HYBHD);
parameters[9].Value = owc.KXD;
parameters[10].Value = owc.SYHD;
DictionaryEntry de = new DictionaryEntry();
de.Key = strSql.ToString();
de.Value = parameters;
SQLStringList.Add(de);
}
try { return(DbHelperOleDb.ExecuteSqlTran(SQLStringList, TableName)); }
catch { throw; }
}
/// <summary>
/// 批量添加数据
/// </summary>
/// <param name="modellist"></param>
public static int BatchAdd(List <object> modellist, string TableName)
{
List <DictionaryEntry> SQLStringList = new List <DictionaryEntry>();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into XSPM_MONTH (");
strSql.Append("JH,CSRQ,YXHD,JDDS1,ZRBFS,YCZ,XCH,XFCH,ZT)");
strSql.Append(" values(");
strSql.Append("@JH,@CSRQ,@YXHD,@JDDS1,@ZRBFS,@YCZ,@XCH,@XFCH,@ZT)");
foreach (Xspm_monthModel xm in modellist)
{
OleDbParameter[] parameters =
{
new OleDbParameter("@JH", OleDbType.VarChar, 255),
new OleDbParameter("@CSRQ", OleDbType.DBDate, 255),
new OleDbParameter("@YXHD", OleDbType.Double, 255),
new OleDbParameter("@JDDS1", OleDbType.Double, 255),
new OleDbParameter("@ZRBFS", OleDbType.Double, 255),
new OleDbParameter("@YCZ", OleDbType.VarChar, 255),
new OleDbParameter("@XCH", OleDbType.VarChar, 255),
new OleDbParameter("@XFCH", OleDbType.VarChar, 255),
new OleDbParameter("@ZT", OleDbType.VarChar, 255)
};
parameters[0].Value = xm.JH;
parameters[1].Value = DateTime.Parse(DateTime.Parse(xm.CSRQ).ToShortDateString());
parameters[2].Value = string.IsNullOrWhiteSpace(xm.YXHD) ? 0 : double.Parse(xm.YXHD);
parameters[3].Value = string.IsNullOrWhiteSpace(xm.JDDS1) ? 0 : double.Parse(xm.JDDS1);
parameters[4].Value = string.IsNullOrWhiteSpace(xm.ZRBFS) ? 0 : double.Parse(xm.ZRBFS);
parameters[5].Value = xm.YCZ;
parameters[6].Value = xm.XCH;
parameters[7].Value = xm.XFCH;
parameters[8].Value = (int)App.Mycache.Get("cszt");
DictionaryEntry de = new DictionaryEntry
{
Key = strSql.ToString(),
Value = parameters
};
SQLStringList.Add(de);
}
try { return(DbHelperOleDb.ExecuteSqlTran(SQLStringList, TableName)); }
catch { throw; }
}
/// <summary>
/// 批量添加数据
/// </summary>
/// <param name="modellist"></param>
public static int BatchAdd(List <object> modellist, string TableName)
{
List <DictionaryEntry> SQLStringList = new List <DictionaryEntry>();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into WATER_WELL_MONTH (");
strSql.Append("JH,NY,TS,ZSFS,YZSL,PZCDS,YZMYL,YY,ZT)");
strSql.Append(" values(");
strSql.Append("@JH,@NY,@TS,@ZSFS,@YZSL,@PZCDS,@YZMYL,@YY,@ZT)");
foreach (Waterwell_monthModel wm in modellist)
{
OleDbParameter[] parameters =
{
new OleDbParameter("@JH", OleDbType.VarChar, 255),
new OleDbParameter("@NY", OleDbType.DBDate, 255),
new OleDbParameter("@TS", OleDbType.VarChar, 255),
new OleDbParameter("@ZSFS", OleDbType.VarChar, 255),
new OleDbParameter("@YZSL", OleDbType.Double, 255),
new OleDbParameter("@PZCDS", OleDbType.VarChar, 255),
new OleDbParameter("@YZMYL", OleDbType.Double, 255),
new OleDbParameter("@YY", OleDbType.Double, 255),
new OleDbParameter("@ZT", OleDbType.Integer, 255),
};
parameters[0].Value = wm.JH;
parameters[1].Value = DateTime.ParseExact(wm.NY, Unity.DateMathed(wm.NY), null);
parameters[2].Value = wm.TS;
parameters[3].Value = wm.ZSFS;
parameters[4].Value = string.IsNullOrEmpty(wm.YZSL) ? 0 : double.Parse(wm.YZSL);
parameters[5].Value = wm.PZCDS;
parameters[6].Value = string.IsNullOrEmpty(wm.YZMYL) ? 0 : double.Parse(wm.YZMYL);
parameters[7].Value = string.IsNullOrEmpty(wm.YY) ? 0 : double.Parse(wm.YY);
parameters[8].Value = (int)App.Mycache.Get("cszt");
DictionaryEntry de = new DictionaryEntry();
de.Key = strSql.ToString();
de.Value = parameters;
SQLStringList.Add(de);
}
try { return(DbHelperOleDb.ExecuteSqlTran(SQLStringList, TableName)); }
catch { throw; }
}
public bool ExeSqlStr(string dirPath, string xPath)
{
bool flag = true;
List <string> stringList = this.ReadChildNodesValue(dirPath + "plugin.config", xPath);
if (stringList != null)
{
ArrayList SQLStringList = new ArrayList();
foreach (string str in stringList)
{
SQLStringList.Add((object)str);
}
if (!DbHelperOleDb.ExecuteSqlTran(SQLStringList))
{
flag = false;
}
}
return(flag);
}
/// <summary>
/// 执行插件SQL语句
/// </summary>
public bool ExeSqlStr(string dirPath, string xPath)
{
bool result = true;
List <string> ls = ReadChildNodesValue(dirPath + DTKeys.FILE_PLUGIN_XML_CONFING, xPath);
if (ls != null)
{
ArrayList al = new ArrayList();
foreach (string str in ls)
{
al.Add(str);
}
if (!DbHelperOleDb.ExecuteSqlTran(al))
{
result = false;
}
}
return(result);
}
/// <summary>
/// 批量添加数据
/// </summary>
/// <param name="modellist"></param>
public static int BatchAdd(List <object> modellist, string TableName)
{
List <DictionaryEntry> SQLStringList = new List <DictionaryEntry>();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OIL_WELL_MONTH (");
strSql.Append("JH,NY,TS,YCYL,YCSL,LY,CCJHWND,ZT)");
strSql.Append(" values(");
strSql.Append("@JH,@NY,@TS,@YCYL,@YCSL,@LY,@CCJHWND,@ZT)");
foreach (Oilwell_monthModel om in modellist)
{
OleDbParameter[] parameters =
{
new OleDbParameter("@JH", OleDbType.VarChar, 255),
new OleDbParameter("@NY", OleDbType.DBDate, 255),
new OleDbParameter("@TS", OleDbType.VarChar, 255),
new OleDbParameter("@YCYL", OleDbType.Double, 255),
new OleDbParameter("@YCSL", OleDbType.Double, 255),
new OleDbParameter("@LY", OleDbType.Double, 255),
new OleDbParameter("@CCJHWND", OleDbType.Double, 255),
new OleDbParameter("@ZT", OleDbType.Integer, 255)
};
parameters[0].Value = om.JH;
parameters[1].Value = DateTime.ParseExact(om.NY, Unity.DateMathed(om.NY), null);
parameters[2].Value = om.TS;
parameters[3].Value = Unity.ToDouble(om.YCYL);
parameters[4].Value = Unity.ToDouble(om.YCSL);
parameters[5].Value = Unity.ToDouble(om.LY);
parameters[6].Value = Unity.ToDouble(om.CCJHWND);
parameters[7].Value = (int)App.Mycache.Get("cszt");
DictionaryEntry de = new DictionaryEntry();
de.Key = strSql.ToString();
de.Value = parameters;
SQLStringList.Add(de);
}
try { return(DbHelperOleDb.ExecuteSqlTran(SQLStringList, TableName)); }
catch { throw; }
}
/// <summary>
/// 批量添加数据
/// </summary>
/// <param name="modellist"></param>
public static int BatchAdd(List <object> modellist, string TableName)
{
List <DictionaryEntry> SQLStringList = new List <DictionaryEntry>();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FZJ_MONTH (");
strSql.Append("JH,NY,CDXH,CDSZ,CDYZSL,CDYZMYL,ZT)");
strSql.Append(" values(");
strSql.Append("@JH,@NY,@CDXH,@CDSZ,@CDYZSL,@CDYZMYL,@ZT)");
foreach (Fzj_monthModel fm in modellist)
{
OleDbParameter[] parameters =
{
new OleDbParameter("@JH", OleDbType.VarChar, 255),
new OleDbParameter("@NY", OleDbType.DBDate, 255),
new OleDbParameter("@CDXH", OleDbType.VarChar, 255),
new OleDbParameter("@CDSZ", OleDbType.VarChar, 255),
new OleDbParameter("@CDYZSL", OleDbType.Double, 255),
new OleDbParameter("@CDYZMYL", OleDbType.Double, 255),
new OleDbParameter("@ZT", OleDbType.Integer, 255)
};
parameters[0].Value = fm.JH;
parameters[1].Value = DateTime.ParseExact(fm.NY, Unity.DateMathed(fm.NY), null);
parameters[2].Value = fm.CDXH;
parameters[3].Value = fm.CDSZ;
parameters[4].Value = double.Parse(fm.CDYZSL);
parameters[5].Value = double.Parse(fm.CDYZMYL);
parameters[6].Value = (int)App.Mycache.Get("cszt");
DictionaryEntry de = new DictionaryEntry();
de.Key = strSql.ToString();
de.Value = parameters;
SQLStringList.Add(de);
}
try { return(DbHelperOleDb.ExecuteSqlTran(SQLStringList, TableName)); }
catch { throw; }
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int id)
{
Hashtable sqllist = new Hashtable();
//删除规格值
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("delete from " + databaseprefix + "article_spec");
strSql1.Append(" where parent_id=@parent_id");
OleDbParameter[] parameters1 =
{
new OleDbParameter("@parent_id", OleDbType.Integer, 4)
};
parameters1[0].Value = id;
sqllist.Add(strSql1.ToString(), parameters1);
//删除规格
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "article_spec ");
strSql.Append(" where id=@id");
OleDbParameter[] parameters =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters[0].Value = id;
sqllist.Add(strSql.ToString(), parameters);
bool result = DbHelperOleDb.ExecuteSqlTran(sqllist);
if (result)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据，及子表所有相关数据
/// </summary>
public bool Delete(int id)
{
Hashtable sqllist = new Hashtable();
//删除管理角色权限
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "manager_role_value ");
strSql.Append(" where role_id=@role_id");
OleDbParameter[] parameters =
{
new OleDbParameter("@role_id", OleDbType.Integer, 4)
};
parameters[0].Value = id;
sqllist.Add(strSql.ToString(), parameters);
//删除管理角色
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from " + databaseprefix + "manager_role ");
strSql2.Append(" where id=@id");
OleDbParameter[] parameters2 =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters2[0].Value = id;
sqllist.Add(strSql2.ToString(), parameters2);
bool result = DbHelperOleDb.ExecuteSqlTran(sqllist);
if (result)
{
return(true);
}
else
{
return(false);
}
}
public static void KltpjInsert(Kltpj klmodel)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PC_XTPK_STATUS (");
strSql.Append("MC,DW,TYRQ,CPSJ,CPBS,ZPBS,PZSJ,KYQD,NW,NY,NJ,XN,BSB,TXML,SXQ,JG,BZ,ZT)");
strSql.Append(" values(");
strSql.Append("@MC,@DW,@TYRQ,@CPSJ,@CPBS,@ZPBS,@PZSJ,@KYQD,@NW,@NY,@NJ,@XN,@BSB,@TXML,@SXQ,@JG,@BZ,@ZT)");
OleDbParameter[] parameters =
{
new OleDbParameter("@MC", klmodel.Mc),
new OleDbParameter("@DW", klmodel.Dw),
new OleDbParameter("@TYRQ", DateTime.Parse(klmodel.Tyrq)),
new OleDbParameter("@CPSJ", klmodel.Cpsj),
new OleDbParameter("@CPBS", klmodel.Cpbs),
new OleDbParameter("@ZPBS", klmodel.Zpbs),
new OleDbParameter("@PZSJ", klmodel.Pzsj),
new OleDbParameter("@KYQD", klmodel.Kyqd),
new OleDbParameter("@NW", klmodel.Nw),
new OleDbParameter("@NY", klmodel.Ny),
new OleDbParameter("@NJ", klmodel.Nj),
new OleDbParameter("@XN", klmodel.Xn),
new OleDbParameter("@BSB", klmodel.Bsb),
new OleDbParameter("@TXML", klmodel.Txml),
new OleDbParameter("@SXQ", klmodel.Sxq),
new OleDbParameter("@JG", klmodel.Jg),
new OleDbParameter("@BZ", klmodel.Bz),
new OleDbParameter("@ZT", 1),
};
Hashtable sqlTable = new Hashtable
{
{ strSql.ToString(), parameters }
};
try { DbHelperOleDb.ExecuteSqlTran(sqlTable); }
catch { throw; }
}
public bool Delete(int id)
{
Rain.Model.users model = this.GetModel(id);
if (model == null)
{
return(false);
}
Hashtable SQLStringList = new Hashtable();
StringBuilder stringBuilder1 = new StringBuilder();
stringBuilder1.Append("delete from " + this.databaseprefix + "user_point_log ");
stringBuilder1.Append(" where user_id=@id");
OleDbParameter[] oleDbParameterArray1 = new OleDbParameter[1]
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray1[0].Value = (object)id;
SQLStringList.Add((object)stringBuilder1.ToString(), (object)oleDbParameterArray1);
StringBuilder stringBuilder2 = new StringBuilder();
stringBuilder2.Append("delete from " + this.databaseprefix + "user_amount_log ");
stringBuilder2.Append(" where user_id=@id");
OleDbParameter[] oleDbParameterArray2 = new OleDbParameter[1]
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray2[0].Value = (object)id;
SQLStringList.Add((object)stringBuilder2.ToString(), (object)oleDbParameterArray2);
StringBuilder stringBuilder3 = new StringBuilder();
stringBuilder3.Append("delete from " + this.databaseprefix + "user_attach_log");
stringBuilder3.Append(" where user_id=@id");
OleDbParameter[] oleDbParameterArray3 = new OleDbParameter[1]
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray3[0].Value = (object)id;
SQLStringList.Add((object)stringBuilder3.ToString(), (object)oleDbParameterArray3);
StringBuilder stringBuilder4 = new StringBuilder();
stringBuilder4.Append("delete from " + this.databaseprefix + "user_message ");
stringBuilder4.Append(" where post_user_name=@post_user_name or accept_user_name=@accept_user_name");
OleDbParameter[] oleDbParameterArray4 = new OleDbParameter[2]
{
new OleDbParameter("@post_user_name", OleDbType.VarChar, 100),
new OleDbParameter("@accept_user_name", OleDbType.VarChar, 100)
};
oleDbParameterArray4[0].Value = (object)model.user_name;
oleDbParameterArray4[1].Value = (object)model.user_name;
SQLStringList.Add((object)stringBuilder4.ToString(), (object)oleDbParameterArray4);
StringBuilder stringBuilder5 = new StringBuilder();
stringBuilder5.Append("delete from " + this.databaseprefix + "user_code ");
stringBuilder5.Append(" where user_id=@id");
OleDbParameter[] oleDbParameterArray5 = new OleDbParameter[1]
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray5[0].Value = (object)id;
SQLStringList.Add((object)stringBuilder5.ToString(), (object)oleDbParameterArray5);
StringBuilder stringBuilder6 = new StringBuilder();
stringBuilder6.Append("delete from " + this.databaseprefix + "user_login_log ");
stringBuilder6.Append(" where user_id=@id");
OleDbParameter[] oleDbParameterArray6 = new OleDbParameter[1]
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray6[0].Value = (object)id;
SQLStringList.Add((object)stringBuilder6.ToString(), (object)oleDbParameterArray6);
StringBuilder stringBuilder7 = new StringBuilder();
stringBuilder7.Append("delete from " + this.databaseprefix + "user_oauth ");
stringBuilder7.Append(" where user_id=@id");
OleDbParameter[] oleDbParameterArray7 = new OleDbParameter[1]
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray7[0].Value = (object)id;
SQLStringList.Add((object)stringBuilder7.ToString(), (object)oleDbParameterArray7);
StringBuilder stringBuilder8 = new StringBuilder();
stringBuilder8.Append("delete from " + this.databaseprefix + "user_recharge ");
stringBuilder8.Append(" where user_id=@id");
OleDbParameter[] oleDbParameterArray8 = new OleDbParameter[1]
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray8[0].Value = (object)id;
SQLStringList.Add((object)stringBuilder8.ToString(), (object)oleDbParameterArray8);
StringBuilder stringBuilder9 = new StringBuilder();
stringBuilder9.Append("delete from " + this.databaseprefix + "users ");
stringBuilder9.Append(" where id=@id");
OleDbParameter[] oleDbParameterArray9 = new OleDbParameter[1]
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray9[0].Value = (object)id;
SQLStringList.Add((object)stringBuilder9.ToString(), (object)oleDbParameterArray9);
return(DbHelperOleDb.ExecuteSqlTran(SQLStringList));
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int id)
{
//获取用户旧数据
Model.users model = GetModel(id);
if (model == null)
{
return(false);
}
Hashtable sqllist = new Hashtable();
//删除积分记录
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("delete from " + databaseprefix + "user_point_log ");
strSql1.Append(" where user_id=@id");
OleDbParameter[] parameters1 =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters1[0].Value = id;
sqllist.Add(strSql1.ToString(), parameters1);
//删除金额记录
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from " + databaseprefix + "user_amount_log ");
strSql2.Append(" where user_id=@id");
OleDbParameter[] parameters2 =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters2[0].Value = id;
sqllist.Add(strSql2.ToString(), parameters2);
//删除附件购买记录
StringBuilder strSql3 = new StringBuilder();
strSql3.Append("delete from " + databaseprefix + "user_attach_log");
strSql3.Append(" where user_id=@id");
OleDbParameter[] parameters3 =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters3[0].Value = id;
sqllist.Add(strSql3.ToString(), parameters3);
//删除短消息
StringBuilder strSql4 = new StringBuilder();
strSql4.Append("delete from " + databaseprefix + "user_message ");
strSql4.Append(" where post_user_name=@post_user_name or accept_user_name=@accept_user_name");
OleDbParameter[] parameters4 =
{
new OleDbParameter("@post_user_name", OleDbType.VarChar, 100),
new OleDbParameter("@accept_user_name", OleDbType.VarChar, 100)
};
parameters4[0].Value = model.user_name;
parameters4[1].Value = model.user_name;
sqllist.Add(strSql4.ToString(), parameters4);
//删除申请码
StringBuilder strSql5 = new StringBuilder();
strSql5.Append("delete from " + databaseprefix + "user_code ");
strSql5.Append(" where user_id=@id");
OleDbParameter[] parameters5 =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters5[0].Value = id;
sqllist.Add(strSql5.ToString(), parameters5);
//删除登录日志
StringBuilder strSql6 = new StringBuilder();
strSql6.Append("delete from " + databaseprefix + "user_login_log ");
strSql6.Append(" where user_id=@id");
OleDbParameter[] parameters6 =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters6[0].Value = id;
sqllist.Add(strSql6.ToString(), parameters6);
//删除OAuth授权用户信息
StringBuilder strSql8 = new StringBuilder();
strSql8.Append("delete from " + databaseprefix + "user_oauth ");
strSql8.Append(" where user_id=@id");
OleDbParameter[] parameters8 =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters8[0].Value = id;
sqllist.Add(strSql8.ToString(), parameters8);
//删除用户充值表
StringBuilder strSql9 = new StringBuilder();
strSql9.Append("delete from " + databaseprefix + "user_recharge ");
strSql9.Append(" where user_id=@id");
OleDbParameter[] parameters9 =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters9[0].Value = id;
sqllist.Add(strSql9.ToString(), parameters9);
//删除用户主表
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "users ");
strSql.Append(" where id=@id");
OleDbParameter[] parameters =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters[0].Value = id;
sqllist.Add(strSql.ToString(), parameters);
bool result = DbHelperOleDb.ExecuteSqlTran(sqllist);
if (result)
{
return(true);
}
else
{
return(false);
}
}
