/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "user_oauth_app "); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = id; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int deptId) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from dept "); strSql.Append(" where deptId=@deptId"); OleDbParameter[] parameters = { new OleDbParameter("@deptId", OleDbType.Integer, 4) }; parameters[0].Value = deptId; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool UpdateTypeidByIdList(int typeid, string IdList) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dbo_Article set "); strSql.Append("dbo_Typeid=@dbo_Typeid"); strSql.Append(" where ID in (" + IdList + ") "); OleDbParameter[] parameters = { new OleDbParameter("@dbo_Typeid", OleDbType.Integer, 4) }; parameters[0].Value = typeid; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from [db_theExamNo] "); strSql.Append(" where ID=@ID "); OleDbParameter[] parameters = { new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = ID; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据,带事务 /// </summary> public bool Delete(OleDbConnection conn, OleDbTransaction trans, string nav_name) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "navigation"); strSql.Append(" where name=@name"); OleDbParameter[] parameters = { new OleDbParameter("@name", OleDbType.VarChar, 50) }; parameters[0].Value = nav_name; int rows = DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(string Pid) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from SaleInfo "); strSql.Append(" where Pid=@Pid "); OleDbParameter[] parameters = { new OleDbParameter("@Pid", OleDbType.VarChar, 50) }; parameters[0].Value = Pid; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(string Code) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from GoodsInfo "); strSql.Append(" where Code=@Code "); OleDbParameter[] parameters = { new OleDbParameter("@Code", OleDbType.VarChar, 50) }; parameters[0].Value = Code; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int QFUREFCODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from QFUREFERENCE "); strSql.Append(" where QFUREFCODE=@QFUREFCODE"); OleDbParameter[] parameters = { new OleDbParameter("@QFUREFCODE", OleDbType.Integer, 4) }; parameters[0].Value = QFUREFCODE; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(string methodName) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from tb_GBT282892012_TensileSel "); strSql.Append(" where methodName=@methodName"); OleDbParameter[] parameters = { new OleDbParameter("@methodName", OleDbType.VarChar) }; parameters[0].Value = methodName; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(string testNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from tb_GBT282892012_Twist "); strSql.Append(" where testNo=@testNo"); OleDbParameter[] parameters = { new OleDbParameter("@testNo", OleDbType.VarChar) }; parameters[0].Value = testNo; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool Update(Rain.Model.user_oauth_app model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update " + this.databaseprefix + "user_oauth_app set "); stringBuilder.Append("title=@title,"); stringBuilder.Append("img_url=@img_url,"); stringBuilder.Append("app_id=@app_id,"); stringBuilder.Append("app_key=@app_key,"); stringBuilder.Append("[remark]=@remark,"); stringBuilder.Append("sort_id=@sort_id,"); stringBuilder.Append("is_lock=@is_lock,"); stringBuilder.Append("api_path=@api_path"); stringBuilder.Append(" where id=@id"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[9] { new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@img_url", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@app_id", OleDbType.VarChar, 100), new OleDbParameter("@app_key", OleDbType.VarChar, 500), new OleDbParameter("@remark", OleDbType.VarChar, 500), new OleDbParameter("@sort_id", OleDbType.Integer, 4), new OleDbParameter("@is_lock", OleDbType.Integer, 4), new OleDbParameter("@api_path", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray[0].Value = (object)model.title; oleDbParameterArray[1].Value = (object)model.img_url; oleDbParameterArray[2].Value = (object)model.app_id; oleDbParameterArray[3].Value = (object)model.app_key; oleDbParameterArray[4].Value = (object)model.remark; oleDbParameterArray[5].Value = (object)model.sort_id; oleDbParameterArray[6].Value = (object)model.is_lock; oleDbParameterArray[7].Value = (object)model.api_path; oleDbParameterArray[8].Value = (object)model.id; return(DbHelperOleDb.ExecuteSql(stringBuilder.ToString(), oleDbParameterArray) > 0); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(HR_Test.Model.Standard model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Standard("); strSql.Append("standardNo,standardName,testType,resultTableName,selTableName,methodTableName,sign)"); strSql.Append(" values ("); strSql.Append("@standardNo,@standardName,@testType,@resultTableName,@selTableName,@methodTableName,@sign)"); OleDbParameter[] parameters = { new OleDbParameter("@standardNo", OleDbType.VarChar, 255), new OleDbParameter("@standardName", OleDbType.VarChar, 255), new OleDbParameter("@testType", OleDbType.VarChar, 255), new OleDbParameter("@resultTableName", OleDbType.VarChar, 255), new OleDbParameter("@selTableName", OleDbType.VarChar, 255), new OleDbParameter("@methodTableName", OleDbType.VarChar, 255), new OleDbParameter("@sign", OleDbType.VarChar, 0) }; parameters[0].Value = model.standardNo; parameters[1].Value = model.standardName; parameters[2].Value = model.testType; parameters[3].Value = model.resultTableName; parameters[4].Value = model.selTableName; parameters[5].Value = model.methodTableName; parameters[6].Value = model.sign; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(HR_Test.Model.GBT236152009_SelHeng model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_GBT236152009_SelHeng("); strSql.Append("methodName,Fmax,T1,T1_,S,T1c,isSaveCurve)"); strSql.Append(" values ("); strSql.Append("@methodName,@Fmax,@T1,@T1_,@S,@T1c,@isSaveCurve)"); OleDbParameter[] parameters = { new OleDbParameter("@methodName", OleDbType.VarChar, 255), new OleDbParameter("@Fmax", OleDbType.Boolean, 1), new OleDbParameter("@T1", OleDbType.Boolean, 1), new OleDbParameter("@T1_", OleDbType.Boolean, 1), new OleDbParameter("@S", OleDbType.Boolean, 1), new OleDbParameter("@T1c", OleDbType.Boolean, 1), new OleDbParameter("@isSaveCurve", OleDbType.Boolean, 1) }; parameters[0].Value = model.methodName; parameters[1].Value = model.Fmax; parameters[2].Value = model.T1; parameters[3].Value = model.T1_; parameters[4].Value = model.S; parameters[5].Value = model.T1c; parameters[6].Value = model.isSaveCurve; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(cycms.Model.FriendLink model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo_FriendLink("); strSql.Append("dbo_FactoryLink,dbo_FactoryProductName,dbo_FactoryLogoSrc,dbo_ProductImgLink,dbo_ProductImgSrc,dbo_ProductImgName,dbo_ProductInfo)"); strSql.Append(" values ("); strSql.Append("@dbo_FactoryLink,@dbo_FactoryProductName,@dbo_FactoryLogoSrc,@dbo_ProductImgLink,@dbo_ProductImgSrc,@dbo_ProductImgName,@dbo_ProductInfo)"); OleDbParameter[] parameters = { new OleDbParameter("@dbo_FactoryLink", OleDbType.VarChar, 255), new OleDbParameter("@dbo_FactoryProductName", OleDbType.VarChar, 50), new OleDbParameter("@dbo_FactoryLogoSrc", OleDbType.VarChar, 255), new OleDbParameter("@dbo_ProductImgLink", OleDbType.VarChar, 255), new OleDbParameter("@dbo_ProductImgSrc", OleDbType.VarChar, 255), new OleDbParameter("@dbo_ProductImgName", OleDbType.VarChar, 255), new OleDbParameter("@dbo_ProductInfo", OleDbType.VarChar, 0) }; parameters[0].Value = model.dbo_FactoryLink; parameters[1].Value = model.dbo_FactoryProductName; parameters[2].Value = model.dbo_FactoryLogoSrc; parameters[3].Value = model.dbo_ProductImgLink; parameters[4].Value = model.dbo_ProductImgSrc; parameters[5].Value = model.dbo_ProductImgName; parameters[6].Value = model.dbo_ProductInfo; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Scheme_AutoGrp model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Scheme_AutoGrp set "); strSql.Append(" intListNo = @intListNo , "); strSql.Append(" chrGrpType = @chrGrpType , "); strSql.Append(" intItemTypeOrPrjNo = @intItemTypeOrPrjNo , "); strSql.Append(" chrSpecOrDataName = @chrSpecOrDataName "); strSql.Append(" where schemeID=@schemeID "); OleDbParameter[] parameters = { new OleDbParameter("@schemeID", OleDbType.Integer, 4), new OleDbParameter("@intListNo", OleDbType.Integer, 4), new OleDbParameter("@chrGrpType", OleDbType.VarChar, 8), new OleDbParameter("@intItemTypeOrPrjNo", OleDbType.Integer, 4), new OleDbParameter("@chrSpecOrDataName", OleDbType.VarChar, 50) }; parameters[4].Value = model.schemeID; parameters[5].Value = model.intListNo; parameters[6].Value = model.chrGrpType; parameters[7].Value = model.intItemTypeOrPrjNo; parameters[8].Value = model.chrSpecOrDataName; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(cycms.Model.DownLoadFile model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo_DownLoadFile("); strSql.Append("dbo_FileName,dbo_FileTitle,dbo_FileSize,dbo_Ptime,dbo_OtherInfo,dbo_TypeId,dbo_IsLock)"); strSql.Append(" values ("); strSql.Append("@dbo_FileName,@dbo_FileTitle,@dbo_FileSize,@dbo_Ptime,@dbo_OtherInfo,@dbo_TypeId,@dbo_IsLock)"); OleDbParameter[] parameters = { new OleDbParameter("@dbo_FileName", OleDbType.VarChar, 100), new OleDbParameter("@dbo_FileTitle", OleDbType.VarChar, 100), new OleDbParameter("@dbo_FileSize", OleDbType.Integer, 4), new OleDbParameter("@dbo_Ptime", OleDbType.Date), new OleDbParameter("@dbo_OtherInfo", OleDbType.VarChar, 0), new OleDbParameter("@dbo_TypeId", OleDbType.Integer, 4), new OleDbParameter("@dbo_IsLock", OleDbType.Boolean, 1) }; parameters[0].Value = model.dbo_FileName; parameters[1].Value = model.dbo_FileTitle; parameters[2].Value = model.dbo_FileSize; parameters[3].Value = model.dbo_Ptime; parameters[4].Value = model.dbo_OtherInfo; parameters[5].Value = model.dbo_TypeId; parameters[6].Value = model.dbo_IsLock; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(HR_Test.Model.GBT282892012_TensileSel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_GBT282892012_TensileSel("); strSql.Append("methodName,FQmax,Q,Q_,SQ,Qc,isSaveCurve)"); strSql.Append(" values ("); strSql.Append("@methodName,@FQmax,@Q,@Q_,@SQ,@Qc,@isSaveCurve)"); OleDbParameter[] parameters = { new OleDbParameter("@methodName", OleDbType.VarChar, 255), new OleDbParameter("@FQmax", OleDbType.Boolean, 1), new OleDbParameter("@Q", OleDbType.Boolean, 1), new OleDbParameter("@Q_", OleDbType.Boolean, 1), new OleDbParameter("@SQ", OleDbType.Boolean, 1), new OleDbParameter("@Qc", OleDbType.Boolean, 1), new OleDbParameter("@isSaveCurve", OleDbType.Boolean, 1) }; parameters[0].Value = model.methodName; parameters[1].Value = model.FQmax; parameters[2].Value = model.Q; parameters[3].Value = model.Q_; parameters[4].Value = model.SQ; parameters[5].Value = model.Qc; parameters[6].Value = model.isSaveCurve; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Dong.Model.OperInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OperInfo("); strSql.Append("Code,Pwd,Name,Sex,CId,Phone,Role)"); strSql.Append(" values ("); strSql.Append("@Code,@Pwd,@Name,@Sex,@CId,@Phone,@Role)"); OleDbParameter[] parameters = { new OleDbParameter("@Code", OleDbType.VarChar, 50), new OleDbParameter("@Pwd", OleDbType.VarChar, 50), new OleDbParameter("@Name", OleDbType.VarChar, 50), new OleDbParameter("@Sex", OleDbType.VarChar, 50), new OleDbParameter("@CId", OleDbType.VarChar, 50), new OleDbParameter("@Phone", OleDbType.VarChar, 50), new OleDbParameter("@Role", OleDbType.Integer, 4) }; parameters[0].Value = model.Code; parameters[1].Value = model.Pwd; parameters[2].Value = model.Name; parameters[3].Value = model.Sex; parameters[4].Value = model.CId; parameters[5].Value = model.Phone; parameters[6].Value = model.Role; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ForKids.DB.Model.DEVICEBASE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DEVICEBASE("); strSql.Append("NAME,FUNDING,LOSSINFO,PURCHASEPLAN,INVESTMENT,PURCHASEDATE,DESCRIPTION)"); strSql.Append(" values ("); strSql.Append("@NAME,@FUNDING,@LOSSINFO,@PURCHASEPLAN,@INVESTMENT,@PURCHASEDATE,@DESCRIPTION)"); OleDbParameter[] parameters = { new OleDbParameter("@NAME", OleDbType.VarChar, 50), new OleDbParameter("@FUNDING", OleDbType.Double), new OleDbParameter("@LOSSINFO", OleDbType.VarChar, 255), new OleDbParameter("@PURCHASEPLAN", OleDbType.VarChar, 255), new OleDbParameter("@INVESTMENT", OleDbType.Double), new OleDbParameter("@PURCHASEDATE", OleDbType.Date), new OleDbParameter("@DESCRIPTION", OleDbType.VarChar, 255) }; parameters[0].Value = model.NAME; parameters[1].Value = model.FUNDING; parameters[2].Value = model.LOSSINFO; parameters[3].Value = model.PURCHASEPLAN; parameters[4].Value = model.INVESTMENT; parameters[5].Value = model.PURCHASEDATE; parameters[6].Value = model.DESCRIPTION; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(hm.Model.sysItem model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into sysItem("); strSql.Append("sicId,itemName,orders,col1,col2,col3,col4)"); strSql.Append(" values ("); strSql.Append("@sicId,@itemName,@orders,@col1,@col2,@col3,@col4)"); OleDbParameter[] parameters = { new OleDbParameter("@sicId", OleDbType.Integer, 4), new OleDbParameter("@itemName", OleDbType.VarChar, 0), new OleDbParameter("@orders", OleDbType.Integer, 4), new OleDbParameter("@col1", OleDbType.VarChar, 255), new OleDbParameter("@col2", OleDbType.VarChar, 255), new OleDbParameter("@col3", OleDbType.VarChar, 255), new OleDbParameter("@col4", OleDbType.Integer, 4) }; parameters[0].Value = model.sicId; parameters[1].Value = model.itemName; parameters[2].Value = model.orders; parameters[3].Value = model.col1; parameters[4].Value = model.col2; parameters[5].Value = model.col3; parameters[6].Value = model.col4; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(hm.Model.web_site model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into web_site("); strSql.Append("webName,title,keywords,description,logo,bottom,qq)"); strSql.Append(" values ("); strSql.Append("@webName,@title,@keywords,@description,@logo,@bottom,@qq)"); OleDbParameter[] parameters = { new OleDbParameter("@webName", OleDbType.VarChar, 255), new OleDbParameter("@title", OleDbType.VarChar, 255), new OleDbParameter("@keywords", OleDbType.VarChar, 255), new OleDbParameter("@description", OleDbType.VarChar, 255), new OleDbParameter("@logo", OleDbType.VarChar, 255), new OleDbParameter("@bottom", OleDbType.VarChar, 0), new OleDbParameter("@qq", OleDbType.VarChar, 255) }; parameters[0].Value = model.webName; parameters[1].Value = model.title; parameters[2].Value = model.keywords; parameters[3].Value = model.description; parameters[4].Value = model.logo; parameters[5].Value = model.bottom; parameters[6].Value = model.qq; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(cycms.Model.TeacherStudyResume model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo_TeacherStudyResume("); strSql.Append("dbo_StartTime,dbo_EndTime,dbo_School,dbo_Professional,dbo_GraduateTime,dbo_Remark,dbo_TeacherId)"); strSql.Append(" values ("); strSql.Append("@dbo_StartTime,@dbo_EndTime,@dbo_School,@dbo_Professional,@dbo_GraduateTime,@dbo_Remark,@dbo_TeacherId)"); OleDbParameter[] parameters = { new OleDbParameter("@dbo_StartTime", OleDbType.VarChar, 100), new OleDbParameter("@dbo_EndTime", OleDbType.VarChar, 100), new OleDbParameter("@dbo_School", OleDbType.VarChar, 200), new OleDbParameter("@dbo_Professional", OleDbType.VarChar, 100), new OleDbParameter("@dbo_GraduateTime", OleDbType.VarChar, 100), new OleDbParameter("@dbo_Remark", OleDbType.VarChar, 0), new OleDbParameter("@dbo_TeacherId", OleDbType.Integer, 4) }; parameters[0].Value = model.dbo_StartTime; parameters[1].Value = model.dbo_EndTime; parameters[2].Value = model.dbo_School; parameters[3].Value = model.dbo_Professional; parameters[4].Value = model.dbo_GraduateTime; parameters[5].Value = model.dbo_Remark; parameters[6].Value = model.dbo_TeacherId; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(HR_Test.Model.GBT282892012_TwistSel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_GBT282892012_TwistSel("); strSql.Append("methodName,FMmax,M,M_,SM,Mc,saveCurve)"); strSql.Append(" values ("); strSql.Append("@methodName,@FMmax,@M,@M_,@SM,@Mc,@saveCurve)"); OleDbParameter[] parameters = { new OleDbParameter("@methodName", OleDbType.VarChar, 255), new OleDbParameter("@FMmax", OleDbType.Boolean, 1), new OleDbParameter("@M", OleDbType.Boolean, 1), new OleDbParameter("@M_", OleDbType.Boolean, 1), new OleDbParameter("@SM", OleDbType.Boolean, 1), new OleDbParameter("@Mc", OleDbType.Boolean, 1), new OleDbParameter("@saveCurve", OleDbType.Boolean, 1) }; parameters[0].Value = model.methodName; parameters[1].Value = model.FMmax; parameters[2].Value = model.M; parameters[3].Value = model.M_; parameters[4].Value = model.SM; parameters[5].Value = model.Mc; parameters[6].Value = model.saveCurve; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(cycms.Model.IPHistry model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo_IPHistry("); strSql.Append("dbo_IPAddress,dbo_Address,dbo_Area,dbo_Ptime,dbo_Browser,dbo_Platform,dbo_PageTitle)"); strSql.Append(" values ("); strSql.Append("@dbo_IPAddress,@dbo_Address,@dbo_Area,@dbo_Ptime,@dbo_Browser,@dbo_Platform,@dbo_PageTitle)"); OleDbParameter[] parameters = { new OleDbParameter("@dbo_IPAddress", OleDbType.VarChar, 20), new OleDbParameter("@dbo_Address", OleDbType.VarChar, 255), new OleDbParameter("@dbo_Area", OleDbType.VarChar, 100), new OleDbParameter("@dbo_Ptime", OleDbType.Date), new OleDbParameter("@dbo_Browser", OleDbType.VarChar, 100), new OleDbParameter("@dbo_Platform", OleDbType.VarChar, 100), new OleDbParameter("@dbo_PageTitle", OleDbType.VarChar, 50) }; parameters[0].Value = model.dbo_IPAddress; parameters[1].Value = model.dbo_Address; parameters[2].Value = model.dbo_Area; parameters[3].Value = model.dbo_Ptime; parameters[4].Value = model.dbo_Browser; parameters[5].Value = model.dbo_Platform; parameters[6].Value = model.dbo_PageTitle; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ForKids.DB.Model.TEACHERBASE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TEACHERBASE("); strSql.Append("JOBNUMBER,NAME,SEX,PHOTO,PHONE,EXPHONE,DESCRIPTION)"); strSql.Append(" values ("); strSql.Append("@JOBNUMBER,@NAME,@SEX,@PHOTO,@PHONE,@EXPHONE,@DESCRIPTION)"); OleDbParameter[] parameters = { new OleDbParameter("@JOBNUMBER", OleDbType.VarChar, 255), new OleDbParameter("@NAME", OleDbType.VarChar, 30), new OleDbParameter("@SEX", OleDbType.Boolean, 1), new OleDbParameter("@PHOTO", OleDbType.Binary, 0), new OleDbParameter("@PHONE", OleDbType.VarChar, 20), new OleDbParameter("@EXPHONE", OleDbType.VarChar, 20), new OleDbParameter("@DESCRIPTION", OleDbType.VarChar, 255) }; parameters[0].Value = model.JOBNUMBER; parameters[1].Value = model.NAME; parameters[2].Value = model.SEX; parameters[3].Value = model.PHOTO; parameters[4].Value = model.PHONE; parameters[5].Value = model.EXPHONE; parameters[6].Value = model.DESCRIPTION; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.TreatHistory model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TreatHistory("); strSql.Append("PID,GID,Disease,IllYear,TreatInfo,TreatResult,MedicateHistory)"); strSql.Append(" values ("); strSql.Append("@PID,@GID,@Disease,@IllYear,@TreatInfo,@TreatResult,@MedicateHistory)"); OleDbParameter[] parameters = { new OleDbParameter("@PID", OleDbType.Integer, 4), new OleDbParameter("@GID", OleDbType.Integer, 4), new OleDbParameter("@Disease", OleDbType.VarChar, 50), new OleDbParameter("@IllYear", OleDbType.VarChar, 50), new OleDbParameter("@TreatInfo", OleDbType.VarChar, 50), new OleDbParameter("@TreatResult", OleDbType.VarChar, 50), new OleDbParameter("@MedicateHistory", OleDbType.VarChar, 50) }; parameters[0].Value = model.PID; parameters[1].Value = model.GID; parameters[2].Value = model.Disease; parameters[3].Value = model.IllYear; parameters[4].Value = model.TreatInfo; parameters[5].Value = model.TreatResult; parameters[6].Value = model.MedicateHistory; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(HR_Test.Model.StandardResultItemInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_StandardResultItemInfo("); strSql.Append("standardNo,testType,paramName,unit,paramDiscrible,isCheck,sign)"); strSql.Append(" values ("); strSql.Append("@standardNo,@testType,@paramName,@unit,@paramDiscrible,@isCheck,@sign)"); OleDbParameter[] parameters = { new OleDbParameter("@standardNo", OleDbType.VarChar, 255), new OleDbParameter("@testType", OleDbType.VarChar, 255), new OleDbParameter("@paramName", OleDbType.VarChar, 255), new OleDbParameter("@unit", OleDbType.VarChar, 0), new OleDbParameter("@paramDiscrible", OleDbType.VarChar, 255), new OleDbParameter("@isCheck", OleDbType.Boolean, 1), new OleDbParameter("@sign", OleDbType.VarChar, 0) }; parameters[0].Value = model.standardNo; parameters[1].Value = model.testType; parameters[2].Value = model.paramName; parameters[3].Value = model.unit; parameters[4].Value = model.paramDiscrible; parameters[5].Value = model.isCheck; parameters[6].Value = model.sign; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.BadReaction model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BadReaction("); strSql.Append("PID,Peroid,ReactionName,OccurDate,Severity,TreatMethod,TreatResult)"); strSql.Append(" values ("); strSql.Append("@PID,@Peroid,@ReactionName,@OccurDate,@Severity,@TreatMethod,@TreatResult)"); OleDbParameter[] parameters = { new OleDbParameter("@PID", OleDbType.Integer, 4), new OleDbParameter("@Peroid", OleDbType.Integer, 4), new OleDbParameter("@ReactionName", OleDbType.VarChar, 50), new OleDbParameter("@OccurDate", OleDbType.Date), new OleDbParameter("@Severity", OleDbType.VarChar, 50), new OleDbParameter("@TreatMethod", OleDbType.VarChar, 50), new OleDbParameter("@TreatResult", OleDbType.VarChar, 50) }; parameters[0].Value = model.PID; parameters[1].Value = model.Peroid; parameters[2].Value = model.ReactionName; parameters[3].Value = model.OccurDate; parameters[4].Value = model.Severity; parameters[5].Value = model.TreatMethod; parameters[6].Value = model.TreatResult; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Express.Model.OrgOrder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OrgOrder("); strSql.Append("orderno,pid,temp0,temp1,temp2,remark,imtime)"); strSql.Append(" values ("); strSql.Append("@orderno,@pid,@temp0,@temp1,@temp2,@remark,@imtime)"); OleDbParameter[] parameters = { new OleDbParameter("@orderno", OleDbType.VarChar, 30), new OleDbParameter("@pid", OleDbType.VarChar, 30), new OleDbParameter("@temp0", OleDbType.VarChar, 30), new OleDbParameter("@temp1", OleDbType.VarChar, 30), new OleDbParameter("@temp2", OleDbType.VarChar, 30), new OleDbParameter("@remark", OleDbType.VarChar, 100), new OleDbParameter("@imtime", OleDbType.Date) }; parameters[0].Value = model.orderno; parameters[1].Value = model.pid; parameters[2].Value = model.temp0; parameters[3].Value = model.temp1; parameters[4].Value = model.temp2; parameters[5].Value = model.remark; parameters[6].Value = model.imtime; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(ERM.MDL.docFormat model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.code != null) { strSql1.Append("code,"); strSql2.Append("'" + model.code + "',"); } if (model.typename != null) { strSql1.Append("typename,"); strSql2.Append("'" + model.typename + "',"); } strSql.Append("insert into docFormat("); 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()); }