/// <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); } }