/// <summary> /// 增加一条数据 /// </summary> public bool Add(HR_Test.Model.GBT282892012_Tensile model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_GBT282892012_Tensile("); strSql.Append("testMethodName,testNo,testSampleNo,reportNo,sendCompany,stuffCardNo,stuffSpec,stuffType,hotStatus,temperature,humidity,testStandard,testMethod,mathineType,testCondition,sampleCharacter,getSample,tester,assessor,sign,L,S0,FQmax,Q,isFinish,testDate,condition,controlmode,isUseExtensometer,isEffective)"); strSql.Append(" values ("); strSql.Append("@testMethodName,@testNo,@testSampleNo,@reportNo,@sendCompany,@stuffCardNo,@stuffSpec,@stuffType,@hotStatus,@temperature,@humidity,@testStandard,@testMethod,@mathineType,@testCondition,@sampleCharacter,@getSample,@tester,@assessor,@sign,@L,@S0,@FQmax,@Q,@isFinish,@testDate,@condition,@controlmode,@isUseExtensometer,@isEffective)"); OleDbParameter[] parameters = { new OleDbParameter("@testMethodName", OleDbType.VarChar, 100), new OleDbParameter("@testNo", OleDbType.VarChar, 100), new OleDbParameter("@testSampleNo", OleDbType.VarChar, 100), new OleDbParameter("@reportNo", OleDbType.VarChar, 100), new OleDbParameter("@sendCompany", OleDbType.VarChar, 100), new OleDbParameter("@stuffCardNo", OleDbType.VarChar, 100), new OleDbParameter("@stuffSpec", OleDbType.VarChar, 100), new OleDbParameter("@stuffType", OleDbType.VarChar, 100), new OleDbParameter("@hotStatus", OleDbType.VarChar, 100), new OleDbParameter("@temperature", OleDbType.Double), new OleDbParameter("@humidity", OleDbType.Double), new OleDbParameter("@testStandard", OleDbType.VarChar, 100), new OleDbParameter("@testMethod", OleDbType.VarChar, 100), new OleDbParameter("@mathineType", OleDbType.VarChar, 100), new OleDbParameter("@testCondition", OleDbType.VarChar, 100), new OleDbParameter("@sampleCharacter", OleDbType.VarChar, 100), new OleDbParameter("@getSample", OleDbType.VarChar, 100), new OleDbParameter("@tester", OleDbType.VarChar, 100), new OleDbParameter("@assessor", OleDbType.VarChar, 100), new OleDbParameter("@sign", OleDbType.VarChar, 255), new OleDbParameter("@L", OleDbType.Double), new OleDbParameter("@S0", OleDbType.Double), new OleDbParameter("@FQmax", OleDbType.Double), new OleDbParameter("@Q", OleDbType.Double), new OleDbParameter("@isFinish", OleDbType.Boolean, 1), new OleDbParameter("@testDate", OleDbType.Date), new OleDbParameter("@condition", OleDbType.VarChar, 255), new OleDbParameter("@controlmode", OleDbType.VarChar, 255), new OleDbParameter("@isUseExtensometer", OleDbType.Boolean, 1), new OleDbParameter("@isEffective", OleDbType.Boolean, 1) }; parameters[0].Value = model.testMethodName; parameters[1].Value = model.testNo; parameters[2].Value = model.testSampleNo; parameters[3].Value = model.reportNo; parameters[4].Value = model.sendCompany; parameters[5].Value = model.stuffCardNo; parameters[6].Value = model.stuffSpec; parameters[7].Value = model.stuffType; parameters[8].Value = model.hotStatus; parameters[9].Value = model.temperature; parameters[10].Value = model.humidity; parameters[11].Value = model.testStandard; parameters[12].Value = model.testMethod; parameters[13].Value = model.mathineType; parameters[14].Value = model.testCondition; parameters[15].Value = model.sampleCharacter; parameters[16].Value = model.getSample; parameters[17].Value = model.tester; parameters[18].Value = model.assessor; parameters[19].Value = model.sign; parameters[20].Value = model.L; parameters[21].Value = model.S0; parameters[22].Value = model.FQmax; parameters[23].Value = model.Q; parameters[24].Value = model.isFinish; parameters[25].Value = model.testDate; parameters[26].Value = model.condition; parameters[27].Value = model.controlmode; parameters[28].Value = model.isUseExtensometer; parameters[29].Value = model.isEffective; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperOleDb.GetMaxID("ID", "KIDATTENDANCE")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperOleDb.GetMaxID("ID", "dbo_TeacherWorkResume")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperOleDb.GetMaxID("ID", "userinfo")); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.navigation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "navigation set "); strSql.Append("parent_id=@parent_id,"); strSql.Append("channel_id=@channel_id,"); strSql.Append("nav_type=@nav_type,"); strSql.Append("[name]=@name,"); strSql.Append("title=@title,"); strSql.Append("sub_title=@sub_title,"); strSql.Append("icon_url=@icon_url,"); strSql.Append("link_url=@link_url,"); strSql.Append("sort_id=@sort_id,"); strSql.Append("is_lock=@is_lock,"); strSql.Append("[remark]=@remark,"); strSql.Append("action_type=@action_type,"); strSql.Append("is_sys=@is_sys"); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@parent_id", OleDbType.Integer, 4), new OleDbParameter("@channel_id", OleDbType.Integer, 4), new OleDbParameter("@nav_type", OleDbType.VarChar, 50), new OleDbParameter("@name", OleDbType.VarChar, 50), new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@sub_title", OleDbType.VarChar, 100), new OleDbParameter("@icon_url", OleDbType.VarChar, 255), new OleDbParameter("@link_url", OleDbType.VarChar, 255), new OleDbParameter("@sort_id", OleDbType.Integer, 4), new OleDbParameter("@is_lock", OleDbType.Integer, 4), new OleDbParameter("@remark", OleDbType.VarChar, 500), new OleDbParameter("@action_type", OleDbType.VarChar, 500), new OleDbParameter("@is_sys", OleDbType.Integer, 4), new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = model.parent_id; parameters[1].Value = model.channel_id; parameters[2].Value = model.nav_type; parameters[3].Value = model.name; parameters[4].Value = model.title; parameters[5].Value = model.sub_title; parameters[6].Value = model.icon_url; parameters[7].Value = model.link_url; parameters[8].Value = model.sort_id; parameters[9].Value = model.is_lock; parameters[10].Value = model.remark; parameters[11].Value = model.action_type; parameters[12].Value = model.is_sys; parameters[13].Value = model.id; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(HR_Test.Model.GBT282892012_ShearSel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_GBT282892012_ShearSel set "); strSql.Append("methodName=@methodName,"); strSql.Append("FTmax=@FTmax,"); strSql.Append("T=@T,"); strSql.Append("C1=@C1,"); strSql.Append("C1R_=@C1R_,"); strSql.Append("C1cR=@C1cR,"); strSql.Append("C1L_=@C1L_,"); strSql.Append("C1cL=@C1cL,"); strSql.Append("C1H_=@C1H_,"); strSql.Append("C1cH=@C1cH,"); strSql.Append("T_=@T_,"); strSql.Append("ST=@ST,"); strSql.Append("Tc=@Tc,"); strSql.Append("saveCurve=@saveCurve"); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@methodName", OleDbType.VarChar, 255), new OleDbParameter("@FTmax", OleDbType.Boolean, 1), new OleDbParameter("@T", OleDbType.Boolean, 1), new OleDbParameter("@C1", OleDbType.Boolean, 1), new OleDbParameter("@C1R_", OleDbType.Boolean, 1), new OleDbParameter("@C1cR", OleDbType.Boolean, 1), new OleDbParameter("@C1L_", OleDbType.Boolean, 1), new OleDbParameter("@C1cL", OleDbType.Boolean, 1), new OleDbParameter("@C1H_", OleDbType.Boolean, 1), new OleDbParameter("@C1cH", OleDbType.Boolean, 1), new OleDbParameter("@T_", OleDbType.Boolean, 1), new OleDbParameter("@ST", OleDbType.Boolean, 1), new OleDbParameter("@Tc", OleDbType.Boolean, 1), new OleDbParameter("@saveCurve", OleDbType.Boolean, 1), new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = model.methodName; parameters[1].Value = model.FTmax; parameters[2].Value = model.T; parameters[3].Value = model.C1; parameters[4].Value = model.C1R_; parameters[5].Value = model.C1cR; parameters[6].Value = model.C1L_; parameters[7].Value = model.C1cL; parameters[8].Value = model.C1H_; parameters[9].Value = model.C1cH; parameters[10].Value = model.T_; parameters[11].Value = model.ST; parameters[12].Value = model.Tc; parameters[13].Value = model.saveCurve; parameters[14].Value = model.ID; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KPS.Model.BuHeGePinJiLuInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PSI_BuHeGePinJiLu set "); strSql.Append("y_date=@y_date,"); strSql.Append("y_pm=@y_pm,"); strSql.Append("y_ggxh=@y_ggxh,"); strSql.Append("y_dw=@y_dw,"); strSql.Append("y_sl=@y_sl,"); strSql.Append("y_sccj=@y_sccj,"); strSql.Append("y_cpdm=@y_cpdm,"); strSql.Append("y_ghdw=@y_ghdw,"); strSql.Append("y_cpzczh=@y_cpzczh,"); strSql.Append("y_scph=@y_scph,"); strSql.Append("y_mjph=@y_mjph,"); strSql.Append("y_yxq=@y_yxq,"); strSql.Append("y_isHGZ=@y_isHGZ,"); strSql.Append("y_zlqk=@y_zlqk,"); strSql.Append("y_zgy=@y_zgy,"); strSql.Append("y_fhrqz=@y_fhrqz,"); strSql.Append("DataType=@DataType"); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@y_date", OleDbType.Date), new OleDbParameter("@y_pm", OleDbType.VarChar, 255), new OleDbParameter("@y_ggxh", OleDbType.VarChar, 255), new OleDbParameter("@y_dw", OleDbType.VarChar, 255), new OleDbParameter("@y_sl", OleDbType.Integer, 4), new OleDbParameter("@y_sccj", OleDbType.VarChar, 255), new OleDbParameter("@y_cpdm", OleDbType.VarChar, 255), new OleDbParameter("@y_ghdw", OleDbType.VarChar, 255), new OleDbParameter("@y_cpzczh", OleDbType.VarChar, 255), new OleDbParameter("@y_scph", OleDbType.VarChar, 255), new OleDbParameter("@y_mjph", OleDbType.VarChar, 255), new OleDbParameter("@y_yxq", OleDbType.VarChar, 255), new OleDbParameter("@y_isHGZ", OleDbType.Boolean, 1), new OleDbParameter("@y_zlqk", OleDbType.VarChar, 255), new OleDbParameter("@y_zgy", OleDbType.VarChar, 255), new OleDbParameter("@y_fhrqz", OleDbType.VarChar, 255), new OleDbParameter("@DataType", OleDbType.Integer, 4), new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = model.y_date; parameters[1].Value = model.y_pm; parameters[2].Value = model.y_ggxh; parameters[3].Value = model.y_dw; parameters[4].Value = model.y_sl; parameters[5].Value = model.y_sccj; parameters[6].Value = model.y_cpdm; parameters[7].Value = model.y_ghdw; parameters[8].Value = model.y_cpzczh; parameters[9].Value = model.y_scph; parameters[10].Value = model.y_mjph; parameters[11].Value = model.y_yxq; parameters[12].Value = model.y_isHGZ; parameters[13].Value = model.y_zlqk; parameters[14].Value = model.y_zgy; parameters[15].Value = model.y_fhrqz; parameters[16].Value = model.DataType; parameters[17].Value = model.ID; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ForKids.DB.Model.TEACHERBASE GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,JOBNUMBER,NAME,AGE,SEX,PHOTO,PHONE,EXPHONE,DESCRIPTION from TEACHERBASE "); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = ID; ForKids.DB.Model.TEACHERBASE model = new ForKids.DB.Model.TEACHERBASE(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["JOBNUMBER"] != null && ds.Tables[0].Rows[0]["JOBNUMBER"].ToString() != "") { model.JOBNUMBER = ds.Tables[0].Rows[0]["JOBNUMBER"].ToString(); } if (ds.Tables[0].Rows[0]["NAME"] != null && ds.Tables[0].Rows[0]["NAME"].ToString() != "") { model.NAME = ds.Tables[0].Rows[0]["NAME"].ToString(); } if (ds.Tables[0].Rows[0]["AGE"] != null && ds.Tables[0].Rows[0]["AGE"].ToString() != "") { model.AGE = int.Parse(ds.Tables[0].Rows[0]["AGE"].ToString()); } if (ds.Tables[0].Rows[0]["SEX"] != null && ds.Tables[0].Rows[0]["SEX"].ToString() != "") { if ((ds.Tables[0].Rows[0]["SEX"].ToString() == "1") || (ds.Tables[0].Rows[0]["SEX"].ToString().ToLower() == "true")) { model.SEX = true; } else { model.SEX = false; } } if (ds.Tables[0].Rows[0]["PHOTO"] != null && ds.Tables[0].Rows[0]["PHOTO"].ToString() != "") { model.PHOTO = (byte[])ds.Tables[0].Rows[0]["PHOTO"]; } if (ds.Tables[0].Rows[0]["PHONE"] != null && ds.Tables[0].Rows[0]["PHONE"].ToString() != "") { model.PHONE = ds.Tables[0].Rows[0]["PHONE"].ToString(); } if (ds.Tables[0].Rows[0]["EXPHONE"] != null && ds.Tables[0].Rows[0]["EXPHONE"].ToString() != "") { model.EXPHONE = ds.Tables[0].Rows[0]["EXPHONE"].ToString(); } if (ds.Tables[0].Rows[0]["DESCRIPTION"] != null && ds.Tables[0].Rows[0]["DESCRIPTION"].ToString() != "") { model.DESCRIPTION = ds.Tables[0].Rows[0]["DESCRIPTION"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperOleDb.GetMaxID("ID", "TEACHERBASE")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperOleDb.GetMaxID("ID", "dbo_Cycms")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperOleDb.GetMaxID("ID", "dbo_Speciality")); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(cycms.Model.Cycms model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dbo_Cycms set "); strSql.Append("dbo_IsRunning=@dbo_IsRunning,"); strSql.Append("dbo_IsStatic=@dbo_IsStatic,"); strSql.Append("dbo_WebAddress=@dbo_WebAddress,"); strSql.Append("dbo_WebName=@dbo_WebName,"); strSql.Append("dbo_StaticListPages=@dbo_StaticListPages,"); strSql.Append("dbo_VisitedTimes=@dbo_VisitedTimes,"); strSql.Append("dbo_SmtpServer=@dbo_SmtpServer,"); strSql.Append("dbo_MailAddress=@dbo_MailAddress,"); strSql.Append("dbo_MailName=@dbo_MailName,"); strSql.Append("dbo_MailPwd=@dbo_MailPwd,"); strSql.Append("dbo_WorkPlace=@dbo_WorkPlace,"); strSql.Append("dbo_LianXiRen=@dbo_LianXiRen,"); strSql.Append("dbo_CellPhone=@dbo_CellPhone,"); strSql.Append("dbo_Flax=@dbo_Flax,"); strSql.Append("dbo_WorkPohne=@dbo_WorkPohne,"); strSql.Append("dbo_BeiAnHao=@dbo_BeiAnHao"); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@dbo_IsRunning", OleDbType.Boolean, 1), new OleDbParameter("@dbo_IsStatic", OleDbType.Boolean, 1), new OleDbParameter("@dbo_WebAddress", OleDbType.VarChar, 200), new OleDbParameter("@dbo_WebName", OleDbType.VarChar, 200), new OleDbParameter("@dbo_StaticListPages", OleDbType.Integer, 4), new OleDbParameter("@dbo_VisitedTimes", OleDbType.Integer, 4), new OleDbParameter("@dbo_SmtpServer", OleDbType.VarChar, 200), new OleDbParameter("@dbo_MailAddress", OleDbType.VarChar, 200), new OleDbParameter("@dbo_MailName", OleDbType.VarChar, 200), new OleDbParameter("@dbo_MailPwd", OleDbType.VarChar, 200), new OleDbParameter("@dbo_WorkPlace", OleDbType.VarChar, 255), new OleDbParameter("@dbo_LianXiRen", OleDbType.VarChar, 10), new OleDbParameter("@dbo_CellPhone", OleDbType.VarChar, 50), new OleDbParameter("@dbo_Flax", OleDbType.VarChar, 50), new OleDbParameter("@dbo_WorkPohne", OleDbType.VarChar, 50), new OleDbParameter("@dbo_BeiAnHao", OleDbType.VarChar, 100), new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = model.dbo_IsRunning; parameters[1].Value = model.dbo_IsStatic; parameters[2].Value = model.dbo_WebAddress; parameters[3].Value = model.dbo_WebName; parameters[4].Value = model.dbo_StaticListPages; parameters[5].Value = model.dbo_VisitedTimes; parameters[6].Value = model.dbo_SmtpServer; parameters[7].Value = model.dbo_MailAddress; parameters[8].Value = model.dbo_MailName; parameters[9].Value = model.dbo_MailPwd; parameters[10].Value = model.dbo_WorkPlace; parameters[11].Value = model.dbo_LianXiRen; parameters[12].Value = model.dbo_CellPhone; parameters[13].Value = model.dbo_Flax; parameters[14].Value = model.dbo_WorkPohne; parameters[15].Value = model.dbo_BeiAnHao; parameters[16].Value = model.ID; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperOleDb.GetMaxID("ID", "tb_GBT236152009_SelHeng")); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.link GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,title,user_name,user_tel,email,site_url,img_url,is_image,sort_id,is_red,is_lock,add_time from " + databaseprefix + "link "); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = id; Model.link model = new Model.link(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "") { model.title = ds.Tables[0].Rows[0]["title"].ToString(); } if (ds.Tables[0].Rows[0]["user_name"] != null && ds.Tables[0].Rows[0]["user_name"].ToString() != "") { model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString(); } if (ds.Tables[0].Rows[0]["user_tel"] != null && ds.Tables[0].Rows[0]["user_tel"].ToString() != "") { model.user_tel = ds.Tables[0].Rows[0]["user_tel"].ToString(); } if (ds.Tables[0].Rows[0]["email"] != null && ds.Tables[0].Rows[0]["email"].ToString() != "") { model.email = ds.Tables[0].Rows[0]["email"].ToString(); } if (ds.Tables[0].Rows[0]["site_url"] != null && ds.Tables[0].Rows[0]["site_url"].ToString() != "") { model.site_url = ds.Tables[0].Rows[0]["site_url"].ToString(); } if (ds.Tables[0].Rows[0]["img_url"] != null && ds.Tables[0].Rows[0]["img_url"].ToString() != "") { model.img_url = ds.Tables[0].Rows[0]["img_url"].ToString(); } if (ds.Tables[0].Rows[0]["is_image"] != null && ds.Tables[0].Rows[0]["is_image"].ToString() != "") { model.is_image = int.Parse(ds.Tables[0].Rows[0]["is_image"].ToString()); } if (ds.Tables[0].Rows[0]["sort_id"] != null && ds.Tables[0].Rows[0]["sort_id"].ToString() != "") { model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString()); } if (ds.Tables[0].Rows[0]["is_red"] != null && ds.Tables[0].Rows[0]["is_red"].ToString() != "") { model.is_red = int.Parse(ds.Tables[0].Rows[0]["is_red"].ToString()); } if (ds.Tables[0].Rows[0]["is_lock"] != null && ds.Tables[0].Rows[0]["is_lock"].ToString() != "") { model.is_lock = int.Parse(ds.Tables[0].Rows[0]["is_lock"].ToString()); } if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "") { model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.article_attribute_field model) { int newId; using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString)) { conn.Open(); using (OleDbTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "article_attribute_field("); strSql.Append("[name],title,control_type,data_type,data_length,data_place,item_option,default_value,is_required,is_password,is_html,editor_type,valid_tip_msg,valid_error_msg,valid_pattern,sort_id,is_sys)"); strSql.Append(" values ("); strSql.Append("@name,@title,@control_type,@data_type,@data_length,@data_place,@item_option,@default_value,@is_required,@is_password,@is_html,@editor_type,@valid_tip_msg,@valid_error_msg,@valid_pattern,@sort_id,@is_sys)"); OleDbParameter[] parameters = { new OleDbParameter("@name", OleDbType.VarChar, 100), new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@control_type", OleDbType.VarChar, 50), new OleDbParameter("@data_type", OleDbType.VarChar, 50), new OleDbParameter("@data_length", OleDbType.Integer, 4), new OleDbParameter("@data_place", OleDbType.Integer, 4), new OleDbParameter("@item_option", OleDbType.VarChar), new OleDbParameter("@default_value", OleDbType.VarChar), new OleDbParameter("@is_required", OleDbType.Integer, 4), new OleDbParameter("@is_password", OleDbType.Integer, 4), new OleDbParameter("@is_html", OleDbType.Integer, 4), new OleDbParameter("@editor_type", OleDbType.Integer, 4), new OleDbParameter("@valid_tip_msg", OleDbType.VarChar, 255), new OleDbParameter("@valid_error_msg", OleDbType.VarChar, 255), new OleDbParameter("@valid_pattern", OleDbType.VarChar, 500), new OleDbParameter("@sort_id", OleDbType.Integer, 4), new OleDbParameter("@is_sys", OleDbType.Integer, 4) }; parameters[0].Value = model.name; parameters[1].Value = model.title; parameters[2].Value = model.control_type; parameters[3].Value = model.data_type; parameters[4].Value = model.data_length; parameters[5].Value = model.data_place; parameters[6].Value = model.item_option; parameters[7].Value = model.default_value; parameters[8].Value = model.is_required; parameters[9].Value = model.is_password; parameters[10].Value = model.is_html; parameters[11].Value = model.editor_type; parameters[12].Value = model.valid_tip_msg; parameters[13].Value = model.valid_error_msg; parameters[14].Value = model.valid_pattern; parameters[15].Value = model.sort_id; parameters[16].Value = model.is_sys; DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters); //取得新插入的ID newId = GetMaxId(conn, trans); //增加扩展字段表中一列 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("alter table " + databaseprefix + "article_attribute_value add " + model.name + " " + model.data_type); OleDbParameter[] parameters2 = { }; DbHelperOleDb.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); trans.Commit(); } catch { trans.Rollback(); return(-1); } } } return(newId); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(ERM.MDL.T_FileList model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.cjdag != null) { strSql1.Append("cjdag,"); strSql2.Append("'" + model.cjdag + "',"); } if (model.datawindow_id != null) { strSql1.Append("datawindow_id,"); strSql2.Append("'" + model.datawindow_id + "',"); } if (model.extension1 != null) { strSql1.Append("extension1,"); strSql2.Append("'" + model.extension1 + "',"); } if (model.extension2 != null) { strSql1.Append("extension2,"); strSql2.Append("'" + model.extension2 + "',"); } if (model.extension3 != null) { strSql1.Append("extension3,"); strSql2.Append("'" + model.extension3 + "',"); } if (model.gclx != null) { strSql1.Append("gclx,"); strSql2.Append("'" + model.gclx + "',"); } if (model.gdwj != null) { strSql1.Append("gdwj,"); strSql2.Append("'" + model.gdwj + "',"); } if (model.id != null) { strSql1.Append("id,"); strSql2.Append("'" + model.id + "',"); } if (model.isvisible != null) { strSql1.Append("isvisible,"); strSql2.Append("" + model.isvisible + ","); } if (model.jldw != null) { strSql1.Append("jldw,"); strSql2.Append("'" + model.jldw + "',"); } if (model.jsdw != null) { strSql1.Append("jsdw,"); strSql2.Append("'" + model.jsdw + "',"); } if (model.OrderIndex != null) { strSql1.Append("OrderIndex,"); strSql2.Append("" + model.OrderIndex + ","); } if (model.ProjectNO != null) { strSql1.Append("ProjectNO,"); strSql2.Append("'" + model.ProjectNO + "',"); } if (model.pTreePath != null) { strSql1.Append("pTreePath,"); strSql2.Append("'" + model.pTreePath + "',"); } if (model.selected != null) { strSql1.Append("selected,"); strSql2.Append("" + model.selected + ","); } if (model.sgdw != null) { strSql1.Append("sgdw,"); strSql2.Append("'" + model.sgdw + "',"); } if (model.sjdw != null) { strSql1.Append("sjdw,"); strSql2.Append("'" + model.sjdw + "',"); } if (model.table_name != null) { strSql1.Append("table_name,"); strSql2.Append("'" + model.table_name + "',"); } if (model.table_standerd != null) { strSql1.Append("table_standerd,"); strSql2.Append("'" + model.table_standerd + "',"); } if (model.TreePath != null) { strSql1.Append("TreePath,"); strSql2.Append("'" + model.TreePath + "',"); } if (model.wjmj != null) { strSql1.Append("wjmj,"); strSql2.Append("'" + model.wjmj + "',"); } if (model.zrr != null) { strSql1.Append("zrr,"); strSql2.Append("'" + model.zrr + "',"); } strSql.Append("insert into FileRecording_Templet("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); DbHelperOleDb.ExecuteSql(strSql.ToString()); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperOleDb.GetMaxID("ID", "dbo_TeacherUpload")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperOleDb.GetMaxID("ID", "BloodGas")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperOleDb.GetMaxID("ID", "tb_GBT282892012_ShearSel")); }
/// <summary> /// 直接充值订单 /// </summary> public bool Recharge(Model.user_recharge model) { using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString)) { conn.Open(); using (OleDbTransaction trans = conn.BeginTransaction()) { try { //增加一条账户余额记录 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("insert into " + databaseprefix + "user_amount_log("); strSql3.Append("user_id,user_name,[value],[remark],add_time)"); strSql3.Append(" values ("); strSql3.Append("@user_id,@user_name,@value,@remark,@add_time)"); OleDbParameter[] parameters3 = { new OleDbParameter("@user_id", OleDbType.Integer, 4), new OleDbParameter("@user_name", OleDbType.VarChar, 100), new OleDbParameter("@value", OleDbType.Decimal, 5), new OleDbParameter("@remark", OleDbType.VarChar, 500), new OleDbParameter("@add_time", OleDbType.Date) }; parameters3[0].Value = model.user_id; parameters3[1].Value = model.user_name; parameters3[2].Value = model.amount; parameters3[3].Value = "在线充值,单号:" + model.recharge_no; parameters3[4].Value = DateTime.Now; DbHelperOleDb.ExecuteSql(conn, trans, strSql3.ToString(), parameters3); //修改用户表金额 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("update " + databaseprefix + "users set amount=amount+" + model.amount); strSql2.Append(" where id=@id"); OleDbParameter[] parameters2 = { new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters2[0].Value = model.user_id; DbHelperOleDb.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); //添加充值表 StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "user_recharge("); strSql.Append("user_id,user_name,recharge_no,payment_id,amount,status,add_time,complete_time)"); strSql.Append(" values ("); strSql.Append("@user_id,@user_name,@recharge_no,@payment_id,@amount,@status,@add_time,@complete_time)"); OleDbParameter[] parameters = { new OleDbParameter("@user_id", OleDbType.Integer, 4), new OleDbParameter("@user_name", OleDbType.VarChar, 100), new OleDbParameter("@recharge_no", OleDbType.VarChar, 100), new OleDbParameter("@payment_id", OleDbType.Integer, 4), new OleDbParameter("@amount", OleDbType.Decimal, 5), new OleDbParameter("@status", OleDbType.Integer, 4), new OleDbParameter("@add_time", OleDbType.Date), new OleDbParameter("@complete_time", OleDbType.Date) }; parameters[0].Value = model.user_id; parameters[1].Value = model.user_name; parameters[2].Value = model.recharge_no; parameters[3].Value = model.payment_id; parameters[4].Value = model.amount; parameters[5].Value = model.status; parameters[6].Value = model.add_time; if (model.complete_time != null) { parameters[7].Value = model.complete_time; } else { parameters[7].Value = DBNull.Value; } DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters); trans.Commit(); } catch { trans.Rollback(); return(false); } } } return(true); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperOleDb.GetMaxID("ID", "PSI_BuHeGePinJiLu")); }
/// <summary> /// 确认充值订单 /// </summary> public bool Confirm(string recharge_no) { Model.user_recharge model = GetModel(recharge_no); //根据充值单号得到实体 if (model == null) { return(false); } using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString)) { conn.Open(); using (OleDbTransaction trans = conn.BeginTransaction()) { try { //增加一条账户余额记录 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("insert into " + databaseprefix + "user_amount_log("); strSql3.Append("user_id,user_name,[value],[remark],add_time)"); strSql3.Append(" values ("); strSql3.Append("@user_id,@user_name,@value,@remark,@add_time)"); OleDbParameter[] parameters3 = { new OleDbParameter("@user_id", OleDbType.Integer, 4), new OleDbParameter("@user_name", OleDbType.VarChar, 100), new OleDbParameter("@value", OleDbType.Decimal, 5), new OleDbParameter("@remark", OleDbType.VarChar, 500), new OleDbParameter("@add_time", OleDbType.Date) }; parameters3[0].Value = model.user_id; parameters3[1].Value = model.user_name; parameters3[2].Value = model.amount; parameters3[3].Value = "在线充值,单号:" + recharge_no; parameters3[4].Value = DateTime.Now; DbHelperOleDb.ExecuteSql(conn, trans, strSql3.ToString(), parameters3); //修改用户表金额 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("update " + databaseprefix + "users set amount=amount+" + model.amount); strSql2.Append(" where id=@id"); OleDbParameter[] parameters2 = { new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters2[0].Value = model.user_id; DbHelperOleDb.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); //更新充值表 StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "user_recharge set "); strSql.Append("status=@status,"); strSql.Append("complete_time=@complete_time"); strSql.Append(" where recharge_no=@recharge_no"); OleDbParameter[] parameters = { new OleDbParameter("@status", OleDbType.Integer, 4), new OleDbParameter("@complete_time", OleDbType.Date), new OleDbParameter("@recharge_no", OleDbType.VarChar, 100) }; parameters[0].Value = 1; parameters[1].Value = DateTime.Now; parameters[2].Value = recharge_no; DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters); trans.Commit(); } catch { trans.Rollback(); return(false); } } } return(true); }
/// <summary> /// 绑定数据源 /// </summary> /// <param name="dt">数据结果</param> /// <param name="userNamek">人员名称</param> /// <param name="timeLimit">时间范围</param> public bool RegisterData(DataTable dt, string userNamek, string dateLimit) { try { #region 获取人员信息 string sql = "Select * from Personnel where enable='1' and name='" + DESJiaMi.Encrypt(userNamek) + "';"; DataTable userUpdate = DbHelperOleDb.Query(sql, new Dictionary <string, object>()).Tables[0]; if (userUpdate != null && userUpdate.Rows.Count > 0) { //姓名 string workerName = userUpdate.Rows[0]["name"].ToString(); if (!string.IsNullOrEmpty(workerName)) { workerName = DESJiaMi.Decrypt(workerName); report.SetParameterValue("workername", workerName); } else { report.SetParameterValue("workername", ""); } //性别 string xingbie = userUpdate.Rows[0]["gender"].ToString(); if (!string.IsNullOrEmpty(xingbie)) { xingbie = DESJiaMi.Decrypt(xingbie); report.SetParameterValue("gender", xingbie); } else { report.SetParameterValue("gender", ""); } //联系电话 string lxdh = userUpdate.Rows[0]["lxdh"].ToString(); if (!string.IsNullOrEmpty(lxdh)) { lxdh = DESJiaMi.Decrypt(lxdh); report.SetParameterValue("lxdh", lxdh); } else { report.SetParameterValue("lxdh", ""); } //主要工作 string mainwork = userUpdate.Rows[0]["mainwork"].ToString(); if (!string.IsNullOrEmpty(mainwork)) { report.SetParameterValue("mainwork", mainwork); } else { report.SetParameterValue("mainwork", ""); } //统计时间 report.SetParameterValue("dateLimit", dateLimit); TableObject TableOfDay = report.FindObject("TableOfDay") as TableObject; //每日统计表格 TableObject TableOfMonth = report.FindObject("TableOfMonth") as TableObject; //每月统计表格 TableObject TableOfYear = report.FindObject("TableOfYear") as TableObject; //每年统计表格 List <DataRow> drsDay = new List <DataRow>(); //每一天 List <DataRow> drsMonth = new List <DataRow>(); //每一月 List <DataRow> drsYear = new List <DataRow>(); //每一年 for (int i = 0; i < dt.Rows.Count; i++) { string workdate = dt.Rows[i]["workdate"].ToString(); #region 天 if (drsDay.Count != 0) { if (drsDay[0]["workdate"].ToString() == workdate) { drsDay.Add(dt.Rows[i]); } else { TableAddRows(TableOfDay, drsDay.Count); SetValueInReportOfDayInfo(TableOfDay, drsDay, i + 1 - drsDay.Count); drsDay = new List <DataRow>(); drsDay.Add(dt.Rows[i]); } } else { drsDay.Add(dt.Rows[i]); } #endregion #region 月份 if (drsMonth.Count != 0) { if (drsMonth[0]["workdate"].ToString().Substring(0, 7) == workdate.Substring(0, 7)) { drsMonth.Add(dt.Rows[i]); } else { TableAddRows(TableOfMonth, 1); SetValueInReportOfMonthYearInfo(TableOfMonth, drsMonth, "Month"); drsMonth = new List <DataRow>(); drsMonth.Add(dt.Rows[i]); } } else { drsMonth.Add(dt.Rows[i]); } #endregion #region 年份 if (drsYear.Count != 0) { if (drsYear[0]["workdate"].ToString().Substring(0, 4) == workdate.Substring(0, 4)) { drsYear.Add(dt.Rows[i]); } else { TableAddRows(TableOfYear, 1); SetValueInReportOfMonthYearInfo(TableOfYear, drsYear, "Year"); drsYear = new List <DataRow>(); drsYear.Add(dt.Rows[i]); } } else { drsYear.Add(dt.Rows[i]); } #endregion } TableAddRows(TableOfDay, drsDay.Count); SetValueInReportOfDayInfo(TableOfDay, drsDay, dt.Rows.Count + 1 - drsDay.Count); TableAddRows(TableOfMonth, 1); SetValueInReportOfMonthYearInfo(TableOfMonth, drsMonth, "Month"); TableAddRows(TableOfYear, 1); SetValueInReportOfMonthYearInfo(TableOfYear, drsYear, "Year"); //累计时长 List <DataRow> drs = new List <DataRow>(); foreach (DataRow item in dt.Rows) { drs.Add(item); } double SumTimes = GetCumulativeTime(drs); if (!string.IsNullOrEmpty(SumTimes.ToString())) { report.SetParameterValue("timesSums", SumTimes.ToString("0.000")); } else { report.SetParameterValue("timesSums", ""); } } else { return(false); } #endregion DataSet FDataSet = new DataSet(); report.RegisterData(FDataSet); return(true); } catch (Exception) { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.article_attribute_field model) { using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString)) { conn.Open(); using (OleDbTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "article_attribute_field set "); strSql.Append("[name]=@name,"); strSql.Append("title=@title,"); strSql.Append("control_type=@control_type,"); strSql.Append("data_type=@data_type,"); strSql.Append("data_length=@data_length,"); strSql.Append("data_place=@data_place,"); strSql.Append("item_option=@item_option,"); strSql.Append("default_value=@default_value,"); strSql.Append("is_required=@is_required,"); strSql.Append("is_password=@is_password,"); strSql.Append("is_html=@is_html,"); strSql.Append("editor_type=@editor_type,"); strSql.Append("valid_tip_msg=@valid_tip_msg,"); strSql.Append("valid_error_msg=@valid_error_msg,"); strSql.Append("valid_pattern=@valid_pattern,"); strSql.Append("sort_id=@sort_id,"); strSql.Append("is_sys=@is_sys"); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@name", OleDbType.VarChar, 100), new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@control_type", OleDbType.VarChar, 50), new OleDbParameter("@data_type", OleDbType.VarChar, 50), new OleDbParameter("@data_length", OleDbType.Integer, 4), new OleDbParameter("@data_place", OleDbType.Integer, 4), new OleDbParameter("@item_option", OleDbType.VarChar), new OleDbParameter("@default_value", OleDbType.VarChar), new OleDbParameter("@is_required", OleDbType.Integer, 4), new OleDbParameter("@is_password", OleDbType.Integer, 4), new OleDbParameter("@is_html", OleDbType.Integer, 4), new OleDbParameter("@editor_type", OleDbType.Integer, 4), new OleDbParameter("@valid_tip_msg", OleDbType.VarChar, 255), new OleDbParameter("@valid_error_msg", OleDbType.VarChar, 255), new OleDbParameter("@valid_pattern", OleDbType.VarChar, 500), new OleDbParameter("@sort_id", OleDbType.Integer, 4), new OleDbParameter("@is_sys", OleDbType.Integer, 4), new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = model.name; parameters[1].Value = model.title; parameters[2].Value = model.control_type; parameters[3].Value = model.data_type; parameters[4].Value = model.data_length; parameters[5].Value = model.data_place; parameters[6].Value = model.item_option; parameters[7].Value = model.default_value; parameters[8].Value = model.is_required; parameters[9].Value = model.is_password; parameters[10].Value = model.is_html; parameters[11].Value = model.editor_type; parameters[12].Value = model.valid_tip_msg; parameters[13].Value = model.valid_error_msg; parameters[14].Value = model.valid_pattern; parameters[15].Value = model.sort_id; parameters[16].Value = model.is_sys; parameters[17].Value = model.id; DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters); //修改扩展字段表中一列 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("alter table " + databaseprefix + "article_attribute_value alter column " + model.name + " " + model.data_type); DbHelperOleDb.ExecuteSql(conn, trans, strSql2.ToString()); //没有错误确认事务 trans.Commit(); } catch { trans.Rollback(); return(false); } } } return(true); }
/// <summary> /// 快捷添加系统默认导航 /// </summary> public int Add(string parent_name, string nav_name, string title, string link_url, int sort_id, int channel_id, string action_type) { //先根据名称查询该父ID StringBuilder strSql1 = new StringBuilder(); strSql1.Append("select top 1 id from " + databaseprefix + "navigation"); strSql1.Append(" where name=@parent_name"); OleDbParameter[] parameters1 = { new OleDbParameter("@parent_name", OleDbType.VarChar, 50) }; parameters1[0].Value = parent_name; object obj1 = DbHelperOleDb.GetSingle(strSql1.ToString(), parameters1); if (obj1 == null) { return(0); } int parent_id = Convert.ToInt32(obj1); int newId; using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString)) { conn.Open(); using (OleDbTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "navigation("); strSql.Append("parent_id,channel_id,nav_type,[name],title,link_url,sort_id,action_type,is_lock,is_sys)"); strSql.Append(" values ("); strSql.Append("@parent_id,@channel_id,@nav_type,@name,@title,@link_url,@sort_id,@action_type,@is_lock,@is_sys)"); OleDbParameter[] parameters = { new OleDbParameter("@parent_id", OleDbType.Integer, 4), new OleDbParameter("@channel_id", OleDbType.Integer, 4), new OleDbParameter("@nav_type", OleDbType.VarChar, 50), new OleDbParameter("@name", OleDbType.VarChar, 50), new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@link_url", OleDbType.VarChar, 255), new OleDbParameter("@sort_id", OleDbType.Integer, 4), new OleDbParameter("@action_type", OleDbType.VarChar, 500), new OleDbParameter("@is_lock", OleDbType.Integer, 4), new OleDbParameter("@is_sys", OleDbType.Integer, 4) }; parameters[0].Value = parent_id; parameters[1].Value = channel_id; parameters[2].Value = DTEnums.NavigationEnum.System.ToString(); parameters[3].Value = nav_name; parameters[4].Value = title; parameters[5].Value = link_url; parameters[6].Value = sort_id; parameters[7].Value = action_type; parameters[8].Value = 0; parameters[9].Value = 1; DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters); //取得新插入的ID newId = GetMaxId(conn, trans); trans.Commit(); } catch { trans.Rollback(); return(-1); } } } return(newId); }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //取得Model信息 Model.article_attribute_field model = GetModel(id); //开始删除 using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString)) { conn.Open(); using (OleDbTransaction trans = conn.BeginTransaction()) { try { //查找关联的频道ID,得到后以备使用 StringBuilder strSql1 = new StringBuilder(); strSql1.Append("select channel_id,field_id from " + databaseprefix + "channel_field "); strSql1.Append(" where field_id=@field_id"); OleDbParameter[] parameters1 = { new OleDbParameter("@field_id", OleDbType.Integer, 4) }; parameters1[0].Value = id; DataTable dt = DbHelperOleDb.Query(conn, trans, strSql1.ToString(), parameters1).Tables[0]; //删除频道关联的字段表 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "channel_field"); strSql2.Append(" where field_id=@field_id"); OleDbParameter[] parameters2 = { new OleDbParameter("@field_id", OleDbType.Integer, 4) }; parameters2[0].Value = id; DbHelperOleDb.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); //重建对应频道的视图 if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { Model.channel modelt = new DAL.channel(databaseprefix).GetModel(conn, trans, int.Parse(dr["channel_id"].ToString())); if (modelt != null) { new DAL.channel(databaseprefix).RehabChannelViews(conn, trans, modelt, modelt.name); } } } //删除主表 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "article_attribute_field "); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = id; DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters); //删除扩展字段表中一列 DbHelperOleDb.ExecuteSql(conn, trans, "alter table " + databaseprefix + "article_attribute_value drop column " + model.name); //没有错误确认事务 trans.Commit(); } catch { trans.Rollback(); return(false); } } } return(true); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperOleDb.GetMaxID("ID", "ed_node")); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.article_attribute_field GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,[name],title,control_type,data_type,data_length,data_place,item_option,default_value,is_required,is_password,is_html,editor_type,valid_tip_msg,valid_error_msg,valid_pattern,sort_id,is_sys"); strSql.Append(" from " + databaseprefix + "article_attribute_field "); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = id; Model.article_attribute_field model = new Model.article_attribute_field(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } model.name = ds.Tables[0].Rows[0]["name"].ToString(); model.title = ds.Tables[0].Rows[0]["title"].ToString(); model.control_type = ds.Tables[0].Rows[0]["control_type"].ToString(); model.data_type = ds.Tables[0].Rows[0]["data_type"].ToString(); if (ds.Tables[0].Rows[0]["data_length"].ToString() != "") { model.data_length = int.Parse(ds.Tables[0].Rows[0]["data_length"].ToString()); } if (ds.Tables[0].Rows[0]["data_place"].ToString() != "") { model.data_place = int.Parse(ds.Tables[0].Rows[0]["data_place"].ToString()); } model.item_option = ds.Tables[0].Rows[0]["item_option"].ToString(); model.default_value = ds.Tables[0].Rows[0]["default_value"].ToString(); if (ds.Tables[0].Rows[0]["is_required"].ToString() != "") { model.is_required = int.Parse(ds.Tables[0].Rows[0]["is_required"].ToString()); } if (ds.Tables[0].Rows[0]["is_password"].ToString() != "") { model.is_password = int.Parse(ds.Tables[0].Rows[0]["is_password"].ToString()); } if (ds.Tables[0].Rows[0]["is_html"].ToString() != "") { model.is_html = int.Parse(ds.Tables[0].Rows[0]["is_html"].ToString()); } if (ds.Tables[0].Rows[0]["editor_type"].ToString() != "") { model.editor_type = int.Parse(ds.Tables[0].Rows[0]["editor_type"].ToString()); } model.valid_tip_msg = ds.Tables[0].Rows[0]["valid_tip_msg"].ToString(); model.valid_error_msg = ds.Tables[0].Rows[0]["valid_error_msg"].ToString(); model.valid_pattern = ds.Tables[0].Rows[0]["valid_pattern"].ToString(); if (ds.Tables[0].Rows[0]["sort_id"].ToString() != "") { model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString()); } if (ds.Tables[0].Rows[0]["is_sys"].ToString() != "") { model.is_sys = int.Parse(ds.Tables[0].Rows[0]["is_sys"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperOleDb.GetMaxID("ID", "dbo_Article")); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperOleDb.GetMaxID("ID", "tb_GBT282892012_Tensile")); }