/// <summary> /// 更新一条数据 /// </summary> public bool Update(DXD.Model.leave_report model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update leave_report set "); strSql.Append("query_id=@query_id,"); strSql.Append("passport_id=@passport_id,"); strSql.Append("passport_type=@passport_type,"); strSql.Append("inout_type=@inout_type,"); strSql.Append("visa_type=@visa_type,"); strSql.Append("inout_date=@inout_date,"); strSql.Append("port_name=@port_name,"); strSql.Append("destination=@destination,"); strSql.Append("leave_reason=@leave_reason,"); strSql.Append("add_user=@add_user,"); strSql.Append("add_time=@add_time"); strSql.Append(" where id=@id"); SQLiteParameter[] parameters = { new SQLiteParameter("@query_id", DbType.Int32, 8), new SQLiteParameter("@passport_id", DbType.Int32, 8), new SQLiteParameter("@passport_type", DbType.Int32, 4), new SQLiteParameter("@inout_type", DbType.Int32, 4), new SQLiteParameter("@visa_type", DbType.Int32, 4), new SQLiteParameter("@inout_date", DbType.DateTime), new SQLiteParameter("@port_name", DbType.String, 200), new SQLiteParameter("@destination", DbType.String, 200), new SQLiteParameter("@leave_reason", DbType.String, 200), new SQLiteParameter("@add_user", DbType.String, 50), new SQLiteParameter("@add_time", DbType.DateTime), new SQLiteParameter("@id", DbType.Int32, 8) }; parameters[0].Value = model.query_id; parameters[1].Value = model.passport_id; parameters[2].Value = model.passport_type; parameters[3].Value = model.inout_type; parameters[4].Value = model.visa_type; parameters[5].Value = model.inout_date; parameters[6].Value = model.port_name; parameters[7].Value = model.destination; parameters[8].Value = model.leave_reason; parameters[9].Value = model.add_user; parameters[10].Value = model.add_time; parameters[11].Value = model.id; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KryptonAccessController.SQLite.Model.InteractRelation.ControllerInfoInLAN model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ControllerInfoInLAN set "); strSql.Append("ControllerName=@ControllerName,"); strSql.Append("ControllerType=@ControllerType,"); strSql.Append("ComunicateType=@ComunicateType,"); strSql.Append("ControllerIP=@ControllerIP,"); strSql.Append("ControllerPort=@ControllerPort,"); strSql.Append("ControllerAddr485=@ControllerAddr485,"); strSql.Append("ControllerBaudrate=@ControllerBaudrate,"); strSql.Append("ControllerDataBits=@ControllerDataBits,"); strSql.Append("ControllerStopBits=@ControllerStopBits,"); strSql.Append("ControllerParityCheck=@ControllerParityCheck,"); strSql.Append("ControllerFlowControl=@ControllerFlowControl"); strSql.Append(" where ControllerID=@ControllerID "); SQLiteParameter[] parameters = { new SQLiteParameter("@ControllerName", DbType.String), new SQLiteParameter("@ControllerType", DbType.Int32, 4), new SQLiteParameter("@ComunicateType", DbType.Int32, 4), new SQLiteParameter("@ControllerIP", DbType.String), new SQLiteParameter("@ControllerPort", DbType.Int32, 4), new SQLiteParameter("@ControllerAddr485", DbType.Int32, 4), new SQLiteParameter("@ControllerBaudrate", DbType.Int32, 4), new SQLiteParameter("@ControllerDataBits", DbType.Int32, 4), new SQLiteParameter("@ControllerStopBits", DbType.Int32, 4), new SQLiteParameter("@ControllerParityCheck", DbType.String), new SQLiteParameter("@ControllerFlowControl", DbType.String), new SQLiteParameter("@ControllerID", DbType.Int32, 4) }; parameters[0].Value = model.ControllerName; parameters[1].Value = model.ControllerType; parameters[2].Value = model.ComunicateType; parameters[3].Value = model.ControllerIP; parameters[4].Value = model.ControllerPort; parameters[5].Value = model.ControllerAddr485; parameters[6].Value = model.ControllerBaudrate; parameters[7].Value = model.ControllerDataBits; parameters[8].Value = model.ControllerStopBits; parameters[9].Value = model.ControllerParityCheck; parameters[10].Value = model.ControllerFlowControl; parameters[11].Value = model.ControllerID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Bsam.Core.Model.Models.Model.Role model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Role set "); strSql.Append("IsDeleted=@IsDeleted,"); strSql.Append("Name=@Name,"); strSql.Append("Description=@Description,"); strSql.Append("OrderSort=@OrderSort,"); strSql.Append("Enabled=@Enabled,"); strSql.Append("CreateId=@CreateId,"); strSql.Append("CreateBy=@CreateBy,"); strSql.Append("CreateTime=@CreateTime,"); strSql.Append("ModifyId=@ModifyId,"); strSql.Append("ModifyBy=@ModifyBy,"); strSql.Append("ModifyTime=@ModifyTime"); strSql.Append(" where Id=@Id"); SQLiteParameter[] parameters = { new SQLiteParameter("@IsDeleted", DbType.bit, 1), new SQLiteParameter("@Name", DbType.String), new SQLiteParameter("@Description", DbType.String), new SQLiteParameter("@OrderSort", DbType.Int32, 8), new SQLiteParameter("@Enabled", DbType.bit, 1), new SQLiteParameter("@CreateId", DbType.Int32, 8), new SQLiteParameter("@CreateBy", DbType.String), new SQLiteParameter("@CreateTime", DbType.DateTime), new SQLiteParameter("@ModifyId", DbType.Int32, 8), new SQLiteParameter("@ModifyBy", DbType.String, 255), new SQLiteParameter("@ModifyTime", DbType.DateTime), new SQLiteParameter("@Id", DbType.Int32, 8) }; parameters[0].Value = model.IsDeleted; parameters[1].Value = model.Name; parameters[2].Value = model.Description; parameters[3].Value = model.OrderSort; parameters[4].Value = model.Enabled; parameters[5].Value = model.CreateId; parameters[6].Value = model.CreateBy; parameters[7].Value = model.CreateTime; parameters[8].Value = model.ModifyId; parameters[9].Value = model.ModifyBy; parameters[10].Value = model.ModifyTime; parameters[11].Value = model.Id; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool Edit(Article item) { string sqlstr = "UPDATE [tbl_Article] SET [CID]='" + item.CID + "',[Title] = '" + item.Title + "',[ImgStr] = '" + item.ImgStr + "'," + "[ProductTxt]='" + item.ProductTxt + "',[ShortTxt]='" + item.ShortTxt + "',[Content]='" + item.Content + "'," + "[AddTime]='" + item.AddTime + "',[Clicks]='" + item.Clicks + "'" + " WHERE id=" + item.ID; int res = DbHelperSQLite.ExecuteSql(sqlstr); return(res > 0); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(UcGnglEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update uc_gngl set "); strSql.Append(" ZJ = @ZJ , "); strSql.Append(" F_FJDZJ = @F_FJDZJ , "); strSql.Append(" JDMC = @JDMC , "); strSql.Append(" JDSX = @JDSX , "); strSql.Append(" JDPX = @JDPX , "); strSql.Append(" GNLX = @GNLX , "); strSql.Append(" CJR = @CJR , "); strSql.Append(" CJSJ = @CJSJ , "); strSql.Append(" BZ = @BZ , "); strSql.Append(" QYBZ = @QYBZ "); strSql.Append(" where ZJ=@ZJ "); SQLiteParameter[] parameters = { new SQLiteParameter("@ZJ", DbType.String), new SQLiteParameter("@F_FJDZJ", DbType.String), new SQLiteParameter("@JDMC", DbType.String), new SQLiteParameter("@JDSX", DbType.String), new SQLiteParameter("@JDPX", DbType.Int32, 8), new SQLiteParameter("@GNLX", DbType.Int32, 8), new SQLiteParameter("@CJR", DbType.String), new SQLiteParameter("@CJSJ", DbType.String), new SQLiteParameter("@BZ", DbType.String), new SQLiteParameter("@QYBZ", DbType.Int32, 8), new SQLiteParameter("@VipType", DbType.String), }; parameters[0].Value = model.ZJ; parameters[1].Value = model.F_FJDZJ; parameters[2].Value = model.JDMC; parameters[3].Value = model.JDSX; parameters[4].Value = model.JDPX; parameters[5].Value = model.GNLX; parameters[6].Value = model.CJR; parameters[7].Value = model.CJSJ; parameters[8].Value = model.BZ; parameters[9].Value = model.QYBZ; parameters[10].Value = model.VipType; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Bsam.Core.Model.Models.Model.Inv_Loc model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Inv_Loc("); strSql.Append("Id,LocCode,LocName,LocDesc,LocStatus,LocOrder,Volume,VolumeUnit,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId,DistrictId,InvId)"); strSql.Append(" values ("); strSql.Append("@Id,@LocCode,@LocName,@LocDesc,@LocStatus,@LocOrder,@Volume,@VolumeUnit,@DateTimeCreated,@UserCreator,@DateTimeModified,@UserModified,@State,@OrgId,@DistrictId,@InvId)"); SQLiteParameter[] parameters = { new SQLiteParameter("@Id", DbType.Int32, 8), new SQLiteParameter("@LocCode", DbType.String, 0), new SQLiteParameter("@LocName", DbType.String, 0), new SQLiteParameter("@LocDesc", DbType.String, 0), new SQLiteParameter("@LocStatus", DbType.String, 0), new SQLiteParameter("@LocOrder", DbType.Int32, 4), new SQLiteParameter("@Volume", DbType.Int32, 4), new SQLiteParameter("@VolumeUnit", DbType.String, 0), new SQLiteParameter("@DateTimeCreated", DbType.Date), new SQLiteParameter("@UserCreator", DbType.String, 0), new SQLiteParameter("@DateTimeModified", DbType.Date), new SQLiteParameter("@UserModified", DbType.String, 0), new SQLiteParameter("@State", DbType.bit, 1), new SQLiteParameter("@OrgId", DbType.String, 0), new SQLiteParameter("@DistrictId", DbType.Int32, 4), new SQLiteParameter("@InvId", DbType.Int32, 4) }; parameters[0].Value = model.Id; parameters[1].Value = model.LocCode; parameters[2].Value = model.LocName; parameters[3].Value = model.LocDesc; parameters[4].Value = model.LocStatus; parameters[5].Value = model.LocOrder; parameters[6].Value = model.Volume; parameters[7].Value = model.VolumeUnit; parameters[8].Value = model.DateTimeCreated; parameters[9].Value = model.UserCreator; parameters[10].Value = model.DateTimeModified; parameters[11].Value = model.UserModified; parameters[12].Value = model.State; parameters[13].Value = model.OrgId; parameters[14].Value = model.DistrictId; parameters[15].Value = model.InvId; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Bsam.Core.Model.Models.Model.Sfc_Customer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sfc_Customer("); strSql.Append("Id,CustomerCode,CustomerName,CustomerShortName,CustomerPhone,CustomerWebchat,EnterpriseName,EnterpriseLegal,EnterpriseAddress,EnterprisePhone,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId)"); strSql.Append(" values ("); strSql.Append("@Id,@CustomerCode,@CustomerName,@CustomerShortName,@CustomerPhone,@CustomerWebchat,@EnterpriseName,@EnterpriseLegal,@EnterpriseAddress,@EnterprisePhone,@DateTimeCreated,@UserCreator,@DateTimeModified,@UserModified,@State,@OrgId)"); SQLiteParameter[] parameters = { new SQLiteParameter("@Id", DbType.Int32, 8), new SQLiteParameter("@CustomerCode", DbType.String, 0), new SQLiteParameter("@CustomerName", DbType.String, 0), new SQLiteParameter("@CustomerShortName", DbType.String, 0), new SQLiteParameter("@CustomerPhone", DbType.String, 0), new SQLiteParameter("@CustomerWebchat", DbType.String, 0), new SQLiteParameter("@EnterpriseName", DbType.String, 0), new SQLiteParameter("@EnterpriseLegal", DbType.String, 0), new SQLiteParameter("@EnterpriseAddress", DbType.String, 0), new SQLiteParameter("@EnterprisePhone", DbType.String, 0), new SQLiteParameter("@DateTimeCreated", DbType.Date), new SQLiteParameter("@UserCreator", DbType.String, 0), new SQLiteParameter("@DateTimeModified", DbType.Date), new SQLiteParameter("@UserModified", DbType.String, 0), new SQLiteParameter("@State", DbType.bit, 1), new SQLiteParameter("@OrgId", DbType.String, 0) }; parameters[0].Value = model.Id; parameters[1].Value = model.CustomerCode; parameters[2].Value = model.CustomerName; parameters[3].Value = model.CustomerShortName; parameters[4].Value = model.CustomerPhone; parameters[5].Value = model.CustomerWebchat; parameters[6].Value = model.EnterpriseName; parameters[7].Value = model.EnterpriseLegal; parameters[8].Value = model.EnterpriseAddress; parameters[9].Value = model.EnterprisePhone; parameters[10].Value = model.DateTimeCreated; parameters[11].Value = model.UserCreator; parameters[12].Value = model.DateTimeModified; parameters[13].Value = model.UserModified; parameters[14].Value = model.State; parameters[15].Value = model.OrgId; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void Insert() { string strGUID = Guid.NewGuid().ToString(); string userName = "******"; string passWord = "******"; string strSql = $"insert into UserInfo (UserID,UserName,PassWord )values ( {strGUID},{userName},{passWord})"; DbHelperSQLite.ExecuteSql(strSql); // strSql = $"select * from UserInfo"; // var date= DbHelperSQLite.Query(strSql); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Bsam.Core.Model.Models.Model.Sfc_Production model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sfc_Production set "); strSql.Append("Id=@Id,"); strSql.Append("ProductCode=@ProductCode,"); strSql.Append("ProductName=@ProductName,"); strSql.Append("ProductDesc=@ProductDesc,"); strSql.Append("ModelType=@ModelType,"); strSql.Append("DateTimeCreated=@DateTimeCreated,"); strSql.Append("UserCreator=@UserCreator,"); strSql.Append("DateTimeModified=@DateTimeModified,"); strSql.Append("UserModified=@UserModified,"); strSql.Append("State=@State,"); strSql.Append("OrgId=@OrgId"); strSql.Append(" where "); SQLiteParameter[] parameters = { new SQLiteParameter("@Id", DbType.Int32, 8), new SQLiteParameter("@ProductCode", DbType.String, 0), new SQLiteParameter("@ProductName", DbType.String, 0), new SQLiteParameter("@ProductDesc", DbType.String, 0), new SQLiteParameter("@ModelType", DbType.String, 0), new SQLiteParameter("@DateTimeCreated", DbType.Date), new SQLiteParameter("@UserCreator", DbType.String, 0), new SQLiteParameter("@DateTimeModified", DbType.Date), new SQLiteParameter("@UserModified", DbType.String, 0), new SQLiteParameter("@State", DbType.bit, 1), new SQLiteParameter("@OrgId", DbType.String, 0) }; parameters[0].Value = model.Id; parameters[1].Value = model.ProductCode; parameters[2].Value = model.ProductName; parameters[3].Value = model.ProductDesc; parameters[4].Value = model.ModelType; parameters[5].Value = model.DateTimeCreated; parameters[6].Value = model.UserCreator; parameters[7].Value = model.DateTimeModified; parameters[8].Value = model.UserModified; parameters[9].Value = model.State; parameters[10].Value = model.OrgId; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Bsam.Core.Model.Models.Model.Sys_User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_User set "); strSql.Append("Id=@Id,"); strSql.Append("UserName=@UserName,"); strSql.Append("UserAccount=@UserAccount,"); strSql.Append("UserPwd=@UserPwd,"); strSql.Append("Address=@Address,"); strSql.Append("Phone=@Phone,"); strSql.Append("DateTimeCreated=@DateTimeCreated,"); strSql.Append("UserCreator=@UserCreator,"); strSql.Append("DateTimeModified=@DateTimeModified,"); strSql.Append("UserModified=@UserModified,"); strSql.Append("State=@State"); strSql.Append(" where "); SQLiteParameter[] parameters = { new SQLiteParameter("@Id", DbType.Int32, 4), new SQLiteParameter("@UserName", DbType.String, 0), new SQLiteParameter("@UserAccount", DbType.String, 0), new SQLiteParameter("@UserPwd", DbType.String, 0), new SQLiteParameter("@Address", DbType.String, 0), new SQLiteParameter("@Phone", DbType.String, 0), new SQLiteParameter("@DateTimeCreated", DbType.Date), new SQLiteParameter("@UserCreator", DbType.String, 0), new SQLiteParameter("@DateTimeModified", DbType.Date), new SQLiteParameter("@UserModified", DbType.String, 0), new SQLiteParameter("@State", DbType.bit, 1) }; parameters[0].Value = model.Id; parameters[1].Value = model.UserName; parameters[2].Value = model.UserAccount; parameters[3].Value = model.UserPwd; parameters[4].Value = model.Address; parameters[5].Value = model.Phone; parameters[6].Value = model.DateTimeCreated; parameters[7].Value = model.UserCreator; parameters[8].Value = model.DateTimeModified; parameters[9].Value = model.UserModified; parameters[10].Value = model.State; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ERPWPF.Model.DingdanDetail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DingdanDetail set "); strSql.Append("Gid=@Gid,"); strSql.Append("Tid=@Tid,"); strSql.Append("GCode=@GCode,"); strSql.Append("GName=@GName,"); strSql.Append("GGuige=@GGuige,"); strSql.Append("GShuliang=@GShuliang,"); strSql.Append("GJinjia=@GJinjia,"); strSql.Append("GShoujia=@GShoujia,"); strSql.Append("GZhekou=@GZhekou,"); strSql.Append("GYouhui=@GYouhui,"); strSql.Append("GHeji=@GHeji"); strSql.Append(" where "); SQLiteParameter[] parameters = { new SQLiteParameter("@Gid", DbType.Int32, 8), new SQLiteParameter("@Tid", DbType.Int32, 8), new SQLiteParameter("@GCode", DbType.String), new SQLiteParameter("@GName", DbType.String), new SQLiteParameter("@GGuige", DbType.String), new SQLiteParameter("@GShuliang", DbType.String), new SQLiteParameter("@GJinjia", DbType.String), new SQLiteParameter("@GShoujia", DbType.String), new SQLiteParameter("@GZhekou", DbType.String), new SQLiteParameter("@GYouhui", DbType.String), new SQLiteParameter("@GHeji", DbType.String) }; parameters[0].Value = model.Gid; parameters[1].Value = model.Tid; parameters[2].Value = model.GCode; parameters[3].Value = model.GName; parameters[4].Value = model.GGuige; parameters[5].Value = model.GShuliang; parameters[6].Value = model.GJinjia; parameters[7].Value = model.GShoujia; parameters[8].Value = model.GZhekou; parameters[9].Value = model.GYouhui; parameters[10].Value = model.GHeji; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Bsam.Core.Model.Models.Model.Sys_Permission model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_Permission set "); strSql.Append("Id=@Id,"); strSql.Append("PermissionName=@PermissionName,"); strSql.Append("PermissionDesc=@PermissionDesc,"); strSql.Append("RequestType=@RequestType,"); strSql.Append("ClientType=@ClientType,"); strSql.Append("ModuleId=@ModuleId,"); strSql.Append("DateTimeCreated=@DateTimeCreated,"); strSql.Append("UserCreator=@UserCreator,"); strSql.Append("DateTimeModified=@DateTimeModified,"); strSql.Append("UserModified=@UserModified,"); strSql.Append("State=@State"); strSql.Append(" where "); SQLiteParameter[] parameters = { new SQLiteParameter("@Id", DbType.Int32, 4), new SQLiteParameter("@PermissionName", DbType.String, 0), new SQLiteParameter("@PermissionDesc", DbType.String, 0), new SQLiteParameter("@RequestType", DbType.String, 0), new SQLiteParameter("@ClientType", DbType.String, 0), new SQLiteParameter("@ModuleId", DbType.Int32, 4), new SQLiteParameter("@DateTimeCreated", DbType.Date), new SQLiteParameter("@UserCreator", DbType.String, 0), new SQLiteParameter("@DateTimeModified", DbType.Date), new SQLiteParameter("@UserModified", DbType.String, 0), new SQLiteParameter("@State", DbType.bit, 1) }; parameters[0].Value = model.Id; parameters[1].Value = model.PermissionName; parameters[2].Value = model.PermissionDesc; parameters[3].Value = model.RequestType; parameters[4].Value = model.ClientType; parameters[5].Value = model.ModuleId; parameters[6].Value = model.DateTimeCreated; parameters[7].Value = model.UserCreator; parameters[8].Value = model.DateTimeModified; parameters[9].Value = model.UserModified; parameters[10].Value = model.State; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public int Delete(string tablename, string strWhere) { string sql = string.Format("delete from {0} ", tablename); if (!string.IsNullOrEmpty(strWhere)) { sql += " where " + strWhere; } sql = StringHelper.ReplaceBadSQL(sql); return(DbHelperSQLite.ExecuteSql(sql)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Dtl model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Inv_Rcv_Bill_Dtl set "); strSql.Append("Id=@Id,"); strSql.Append("BillId=@BillId,"); strSql.Append("MitemCode=@MitemCode,"); strSql.Append("PlanQty=@PlanQty,"); strSql.Append("ActualQty=@ActualQty,"); strSql.Append("DateTimeCreated=@DateTimeCreated,"); strSql.Append("UserCreator=@UserCreator,"); strSql.Append("DateTimeModified=@DateTimeModified,"); strSql.Append("UserModified=@UserModified,"); strSql.Append("State=@State,"); strSql.Append("OrgId=@OrgId"); strSql.Append(" where "); SQLiteParameter[] parameters = { new SQLiteParameter("@Id", DbType.Int32, 4), new SQLiteParameter("@BillId", DbType.Int32, 4), new SQLiteParameter("@MitemCode", DbType.String, 0), new SQLiteParameter("@PlanQty", DbType.Decimal, 8), new SQLiteParameter("@ActualQty", DbType.Decimal, 8), new SQLiteParameter("@DateTimeCreated", DbType.Date), new SQLiteParameter("@UserCreator", DbType.String, 0), new SQLiteParameter("@DateTimeModified", DbType.Date), new SQLiteParameter("@UserModified", DbType.String, 0), new SQLiteParameter("@State", DbType.bit, 1), new SQLiteParameter("@OrgId", DbType.String, 0) }; parameters[0].Value = model.Id; parameters[1].Value = model.BillId; parameters[2].Value = model.MitemCode; parameters[3].Value = model.PlanQty; parameters[4].Value = model.ActualQty; parameters[5].Value = model.DateTimeCreated; parameters[6].Value = model.UserCreator; parameters[7].Value = model.DateTimeModified; parameters[8].Value = model.UserModified; parameters[9].Value = model.State; parameters[10].Value = model.OrgId; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Bsam.Core.Model.Models.Model.RoleModulePermission model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RoleModulePermission set "); strSql.Append("IsDeleted=@IsDeleted,"); strSql.Append("RoleId=@RoleId,"); strSql.Append("ModuleId=@ModuleId,"); strSql.Append("PermissionId=@PermissionId,"); strSql.Append("CreateId=@CreateId,"); strSql.Append("CreateBy=@CreateBy,"); strSql.Append("CreateTime=@CreateTime,"); strSql.Append("ModifyId=@ModifyId,"); strSql.Append("ModifyBy=@ModifyBy,"); strSql.Append("ModifyTime=@ModifyTime"); strSql.Append(" where Id=@Id"); SQLiteParameter[] parameters = { new SQLiteParameter("@IsDeleted", DbType.bit, 1), new SQLiteParameter("@RoleId", DbType.Int32, 8), new SQLiteParameter("@ModuleId", DbType.Int32, 8), new SQLiteParameter("@PermissionId", DbType.Int32, 8), new SQLiteParameter("@CreateId", DbType.Int32, 8), new SQLiteParameter("@CreateBy", DbType.String), new SQLiteParameter("@CreateTime", DbType.DateTime), new SQLiteParameter("@ModifyId", DbType.Int32, 8), new SQLiteParameter("@ModifyBy", DbType.String), new SQLiteParameter("@ModifyTime", DbType.DateTime), new SQLiteParameter("@Id", DbType.Int32, 8) }; parameters[0].Value = model.IsDeleted; parameters[1].Value = model.RoleId; parameters[2].Value = model.ModuleId; parameters[3].Value = model.PermissionId; parameters[4].Value = model.CreateId; parameters[5].Value = model.CreateBy; parameters[6].Value = model.CreateTime; parameters[7].Value = model.ModifyId; parameters[8].Value = model.ModifyBy; parameters[9].Value = model.ModifyTime; parameters[10].Value = model.Id; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Scada.Model.IO_SERVER model) { model.SERVER_STATUS = 0; StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.SERVER_ID != null) { strSql1.Append("SERVER_ID,"); strSql2.Append("'" + model.SERVER_ID + "',"); } if (model.SERVER_NAME != null) { strSql1.Append("SERVER_NAME,"); strSql2.Append("'" + model.SERVER_NAME + "',"); } strSql1.Append("SERVER_STATUS,"); strSql2.Append("" + model.SERVER_STATUS + ","); if (model.SERVER_IP != null) { strSql1.Append("SERVER_IP,"); strSql2.Append("'" + model.SERVER_IP + "',"); } if (model.SERVER_CREATEDATE != null) { strSql1.Append("SERVER_CREATEDATE,"); strSql2.Append("'" + model.SERVER_CREATEDATE + "',"); } if (model.SERVER_REMARK != null) { strSql1.Append("SERVER_REMARK,"); strSql2.Append("'" + model.SERVER_REMARK + "',"); } strSql.Append("insert into IO_SERVER("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); int rows = DbHelperSQLite.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FriendshipMngSys.Model.DBScoreDetail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ScoreDetail set "); strSql.Append("PersonID=@PersonID,"); strSql.Append("课时费高=@课时费高,"); strSql.Append("学生多=@学生多,"); strSql.Append("已备案=@已备案,"); strSql.Append("已买教学琴=@已买教学琴,"); strSql.Append("参加比赛=@参加比赛,"); strSql.Append("参加多钢琴=@参加多钢琴,"); strSql.Append("租场=@租场,"); strSql.Append("成交=@成交,"); strSql.Append("调律=@调律"); strSql.Append(" where ID=@ID "); SQLiteParameter[] parameters = { new SQLiteParameter("@PersonID", DbType.String, 2147483647), new SQLiteParameter("@课时费高", DbType.Int32, 4), new SQLiteParameter("@学生多", DbType.Int32, 4), new SQLiteParameter("@已备案", DbType.Int32, 4), new SQLiteParameter("@已买教学琴", DbType.Int32, 4), new SQLiteParameter("@参加比赛", DbType.Int32, 4), new SQLiteParameter("@参加多钢琴", DbType.Int32, 4), new SQLiteParameter("@租场", DbType.Int32, 4), new SQLiteParameter("@成交", DbType.Int32, 4), new SQLiteParameter("@调律", DbType.Int32, 4), new SQLiteParameter("@ID", DbType.String, 2147483647) }; parameters[0].Value = model.PersonID; parameters[1].Value = model.课时费高; parameters[2].Value = model.学生多; parameters[3].Value = model.已备案; parameters[4].Value = model.已买教学琴; parameters[5].Value = model.参加比赛; parameters[6].Value = model.参加多钢琴; parameters[7].Value = model.租场; parameters[8].Value = model.成交; parameters[9].Value = model.调律; parameters[10].Value = model.ID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void AddFormParas(int formID, string tablename, string columnname) { string sql = string.Format("select 1 from FormParas where (formID={0} and tablename='{1}' and columnname='{2}')", formID, tablename, columnname); sql = StringHelper.ReplaceBadSQL(sql); if (DbHelperSQLite.GetSingle(sql) == null) { string sql1 = string.Format("insert into FormParas(formId,[tablename],columnname,paraId,para_name,[datatype],[maxlength],[width]) values({0},'{1}','{2}','{2}','{2}','text',50,50)", formID, tablename, columnname); sql1 = StringHelper.ReplaceBadSQL(sql1); DbHelperSQLite.ExecuteSql(sql1); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Bsam.Core.Model.Models.Model.BlogArticle model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BlogArticle set "); strSql.Append("bsubmitter=@bsubmitter,"); strSql.Append("btitle=@btitle,"); strSql.Append("bcategory=@bcategory,"); strSql.Append("bcontent=@bcontent,"); strSql.Append("btraffic=@btraffic,"); strSql.Append("bcommentNum=@bcommentNum,"); strSql.Append("bUpdateTime=@bUpdateTime,"); strSql.Append("bCreateTime=@bCreateTime,"); strSql.Append("bRemark=@bRemark,"); strSql.Append("IsDeleted=@IsDeleted"); strSql.Append(" where bID=@bID"); SQLiteParameter[] parameters = { new SQLiteParameter("@bsubmitter", DbType.String), new SQLiteParameter("@btitle", DbType.String), new SQLiteParameter("@bcategory", DbType.String), new SQLiteParameter("@bcontent", DbType.String), new SQLiteParameter("@btraffic", DbType.Int32, 8), new SQLiteParameter("@bcommentNum", DbType.Int32, 8), new SQLiteParameter("@bUpdateTime", DbType.DateTime), new SQLiteParameter("@bCreateTime", DbType.DateTime), new SQLiteParameter("@bRemark", DbType.String), new SQLiteParameter("@IsDeleted", DbType.bit, 1), new SQLiteParameter("@bID", DbType.Int32, 8) }; parameters[0].Value = model.bsubmitter; parameters[1].Value = model.btitle; parameters[2].Value = model.bcategory; parameters[3].Value = model.bcontent; parameters[4].Value = model.btraffic; parameters[5].Value = model.bcommentNum; parameters[6].Value = model.bUpdateTime; parameters[7].Value = model.bCreateTime; parameters[8].Value = model.bRemark; parameters[9].Value = model.IsDeleted; parameters[10].Value = model.bID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KryptonAccessController.SQLite.Model.InteractRelation.AntiPassBack model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AntiPassBack set "); strSql.Append("AntiPassBackMode=@AntiPassBackMode,"); strSql.Append("AntiPassEnable=@AntiPassEnable,"); strSql.Append("ControlerInfoInLANID1=@ControlerInfoInLANID1,"); strSql.Append("DoorUnitID1=@DoorUnitID1,"); strSql.Append("ControlerInfoInLANID2=@ControlerInfoInLANID2,"); strSql.Append("DoorUnitID2=@DoorUnitID2,"); strSql.Append("ControlerInfoInLANID3=@ControlerInfoInLANID3,"); strSql.Append("DoorUnitID3=@DoorUnitID3,"); strSql.Append("ControlerInfoInLANID4=@ControlerInfoInLANID4,"); strSql.Append("DoorUnitID4=@DoorUnitID4"); strSql.Append(" where AntiPassBackID=@AntiPassBackID "); SQLiteParameter[] parameters = { new SQLiteParameter("@AntiPassBackMode", DbType.Int32, 4), new SQLiteParameter("@AntiPassEnable", DbType.Boolean, 1), new SQLiteParameter("@ControlerInfoInLANID1", DbType.Int32, 4), new SQLiteParameter("@DoorUnitID1", DbType.Int32, 4), new SQLiteParameter("@ControlerInfoInLANID2", DbType.Int32, 4), new SQLiteParameter("@DoorUnitID2", DbType.Int32, 4), new SQLiteParameter("@ControlerInfoInLANID3", DbType.Int32, 4), new SQLiteParameter("@DoorUnitID3", DbType.Int32, 4), new SQLiteParameter("@ControlerInfoInLANID4", DbType.Int32, 4), new SQLiteParameter("@DoorUnitID4", DbType.Int32, 4), new SQLiteParameter("@AntiPassBackID", DbType.Int32, 4) }; parameters[0].Value = model.AntiPassBackMode; parameters[1].Value = model.AntiPassEnable; parameters[2].Value = model.ControlerInfoInLANID1; parameters[3].Value = model.DoorUnitID1; parameters[4].Value = model.ControlerInfoInLANID2; parameters[5].Value = model.DoorUnitID2; parameters[6].Value = model.ControlerInfoInLANID3; parameters[7].Value = model.DoorUnitID3; parameters[8].Value = model.ControlerInfoInLANID4; parameters[9].Value = model.DoorUnitID4; parameters[10].Value = model.AntiPassBackID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KryptonAccessController.SQLite.Model.ControllerRelation.AuxiliaryUnit model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AuxiliaryUnit("); strSql.Append("AuxiliaryUnitID,AuxOutPutPointID,InputStateType,FireSensingID,FireSensingMode,FireSensingEnable,TamperSensingID,TamperSensingMode,TamperSensingEnable,LowVoltageID,LowVoltageMode,LowVoltageEnable,PowerOutageID,PowerOutageMode,PowerOutageEnable)"); strSql.Append(" values ("); strSql.Append("@AuxiliaryUnitID,@AuxOutPutPointID,@InputStateType,@FireSensingID,@FireSensingMode,@FireSensingEnable,@TamperSensingID,@TamperSensingMode,@TamperSensingEnable,@LowVoltageID,@LowVoltageMode,@LowVoltageEnable,@PowerOutageID,@PowerOutageMode,@PowerOutageEnable)"); SQLiteParameter[] parameters = { new SQLiteParameter("@AuxiliaryUnitID", DbType.Int32, 4), new SQLiteParameter("@AuxOutPutPointID", DbType.Int32, 4), new SQLiteParameter("@InputStateType", DbType.Int32, 4), new SQLiteParameter("@FireSensingID", DbType.Int32, 4), new SQLiteParameter("@FireSensingMode", DbType.Int32, 4), new SQLiteParameter("@FireSensingEnable", DbType.Boolean, 1), new SQLiteParameter("@TamperSensingID", DbType.Int32, 4), new SQLiteParameter("@TamperSensingMode", DbType.Int32, 4), new SQLiteParameter("@TamperSensingEnable", DbType.Boolean, 1), new SQLiteParameter("@LowVoltageID", DbType.Int32, 4), new SQLiteParameter("@LowVoltageMode", DbType.Int32, 4), new SQLiteParameter("@LowVoltageEnable", DbType.Boolean, 1), new SQLiteParameter("@PowerOutageID", DbType.Int32, 4), new SQLiteParameter("@PowerOutageMode", DbType.Int32, 4), new SQLiteParameter("@PowerOutageEnable", DbType.Boolean, 1) }; parameters[0].Value = model.AuxiliaryUnitID; parameters[1].Value = model.AuxOutPutPointID; parameters[2].Value = model.InputStateType; parameters[3].Value = model.FireSensingID; parameters[4].Value = model.FireSensingMode; parameters[5].Value = model.FireSensingEnable; parameters[6].Value = model.TamperSensingID; parameters[7].Value = model.TamperSensingMode; parameters[8].Value = model.TamperSensingEnable; parameters[9].Value = model.LowVoltageID; parameters[10].Value = model.LowVoltageMode; parameters[11].Value = model.LowVoltageEnable; parameters[12].Value = model.PowerOutageID; parameters[13].Value = model.PowerOutageMode; parameters[14].Value = model.PowerOutageEnable; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DXD.Model.security_feedback model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update security_feedback set "); strSql.Append("query_id=@query_id,"); strSql.Append("query_date=@query_date,"); strSql.Append("sec_type=@sec_type,"); strSql.Append("sec_account=@sec_account,"); strSql.Append("sec_code=@sec_code,"); strSql.Append("sec_name=@sec_name,"); strSql.Append("sec_number=@sec_number,"); strSql.Append("sec_value=@sec_value,"); strSql.Append("add_user=@add_user,"); strSql.Append("add_time=@add_time"); strSql.Append(" where id=@id"); SQLiteParameter[] parameters = { new SQLiteParameter("@query_id", DbType.Int32, 8), new SQLiteParameter("@query_date", DbType.DateTime), new SQLiteParameter("@sec_type", DbType.char, 2), new SQLiteParameter("@sec_account", DbType.String, 50), new SQLiteParameter("@sec_code", DbType.char, 10), new SQLiteParameter("@sec_name", DbType.String, 50), new SQLiteParameter("@sec_number", DbType.Decimal, 4), new SQLiteParameter("@sec_value", DbType.Decimal, 4), new SQLiteParameter("@add_user", DbType.String, 50), new SQLiteParameter("@add_time", DbType.DateTime), new SQLiteParameter("@id", DbType.Int32, 8) }; parameters[0].Value = model.query_id; parameters[1].Value = model.query_date; parameters[2].Value = model.sec_type; parameters[3].Value = model.sec_account; parameters[4].Value = model.sec_code; parameters[5].Value = model.sec_name; parameters[6].Value = model.sec_number; parameters[7].Value = model.sec_value; parameters[8].Value = model.add_user; parameters[9].Value = model.add_time; parameters[10].Value = model.id; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(JC.Model.modules model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update modules set "); strSql.Append("parentid=@parentid,"); strSql.Append("title=@title,"); strSql.Append("content=@content,"); strSql.Append("url=@url,"); strSql.Append("blank=@blank,"); strSql.Append("pic=@pic,"); strSql.Append("path=@path,"); strSql.Append("stem=@stem,"); strSql.Append("haschild=@haschild,"); strSql.Append("orderby=@orderby"); strSql.Append(" where id=@id "); SQLiteParameter[] parameters = { new SQLiteParameter("@parentid", DbType.Int32, 8), new SQLiteParameter("@title", DbType.String), new SQLiteParameter("@content", DbType.String), new SQLiteParameter("@url", DbType.String), new SQLiteParameter("@blank", DbType.Int32, 8), new SQLiteParameter("@pic", DbType.String), new SQLiteParameter("@path", DbType.String), new SQLiteParameter("@stem", DbType.Int32, 8), new SQLiteParameter("@haschild", DbType.Int32, 8), new SQLiteParameter("@orderby", DbType.Int32, 8), new SQLiteParameter("@id", DbType.Int32, 8) }; parameters[0].Value = model.parentid; parameters[1].Value = model.title; parameters[2].Value = model.content; parameters[3].Value = model.url; parameters[4].Value = model.blank; parameters[5].Value = model.pic; parameters[6].Value = model.path; parameters[7].Value = model.stem; parameters[8].Value = model.haschild; parameters[9].Value = model.orderby; parameters[10].Value = model.id; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Scada.Model.DeviceGroup model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DeviceGroup set "); if (model.GroupId != null) { strSql.Append("GroupId=" + model.GroupId + ","); } else { strSql.Append("GroupId= null ,"); } if (model.IO_SERVER_ID != null) { strSql.Append("IO_SERVER_ID=" + model.IO_SERVER_ID + ","); } else { strSql.Append("IO_SERVER_ID= null ,"); } if (model.IO_COMM_ID != null) { strSql.Append("IO_COMM_ID=" + model.IO_COMM_ID + ","); } else { strSql.Append("IO_COMM_ID= null ,"); } if (model.IO_DEVICE_ID != null) { strSql.Append("IO_DEVICE_ID=" + model.IO_DEVICE_ID + ","); } else { strSql.Append("IO_DEVICE_ID= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where Id=" + model.Id + ""); int rowsAffected = DbHelperSQLite.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update() { StringBuilder strSql = new StringBuilder(); strSql.Append("update [S_TreeClass] set "); strSql.Append("ClassName='" + ClassName + "',"); strSql.Append("ParentID=" + ParentID + ","); strSql.Append("ClassCode='" + ClassCode + "',"); strSql.Append("ReadMe='" + ReadMe + "',"); strSql.Append("UpdateTime='" + UpdateTime + "'"); strSql.Append(" where ClassID=" + ClassID + ""); DbHelperSQLite.ExecuteSql(strSql.ToString()); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KryptonAccessController.SQLite.Model.UserRelation.UserInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UserInfo("); strSql.Append("UserID,UserName,Photograph,UserGroupID1,UserGroupID2,UserGroupID3,UserGroupID4,FingerPosition0,FingerPrint0,FingerPosition1,FingerPrint1,SercurityAccessLevel,PrimaryCardID,SecondCardID)"); strSql.Append(" values ("); strSql.Append("@UserID,@UserName,@Photograph,@UserGroupID1,@UserGroupID2,@UserGroupID3,@UserGroupID4,@FingerPosition0,@FingerPrint0,@FingerPosition1,@FingerPrint1,@SercurityAccessLevel,@PrimaryCardID,@SecondCardID)"); SQLiteParameter[] parameters = { new SQLiteParameter("@UserID", DbType.Int32, 4), new SQLiteParameter("@UserName", DbType.String), new SQLiteParameter("@Photograph", DbType.Binary), new SQLiteParameter("@UserGroupID1", DbType.Int32, 4), new SQLiteParameter("@UserGroupID2", DbType.Int32, 4), new SQLiteParameter("@UserGroupID3", DbType.Int32, 4), new SQLiteParameter("@UserGroupID4", DbType.Int32, 4), new SQLiteParameter("@FingerPosition0", DbType.Int32, 4), new SQLiteParameter("@FingerPrint0", DbType.Binary), new SQLiteParameter("@FingerPosition1", DbType.Int32, 4), new SQLiteParameter("@FingerPrint1", DbType.Binary), new SQLiteParameter("@SercurityAccessLevel", DbType.Int32, 4), new SQLiteParameter("@PrimaryCardID", DbType.String), new SQLiteParameter("@SecondCardID", DbType.String) }; parameters[0].Value = model.UserID; parameters[1].Value = model.UserName; parameters[2].Value = model.Photograph; parameters[3].Value = model.UserGroupID1; parameters[4].Value = model.UserGroupID2; parameters[5].Value = model.UserGroupID3; parameters[6].Value = model.UserGroupID4; parameters[7].Value = model.FingerPosition0; parameters[8].Value = model.FingerPrint0; parameters[9].Value = model.FingerPosition1; parameters[10].Value = model.FingerPrint1; parameters[11].Value = model.SercurityAccessLevel; parameters[12].Value = model.PrimaryCardID; parameters[13].Value = model.SecondCardID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SQLiteParameter[] parameters = { * new SQLiteParameter("@tblName", DbType.VarChar, 255), * new SQLiteParameter("@fldName", DbType.VarChar, 255), * new SQLiteParameter("@PageSize", DbType.Int32), * new SQLiteParameter("@PageIndex", DbType.Int32), * new SQLiteParameter("@IsReCount", DbType.bit), * new SQLiteParameter("@OrderType", DbType.bit), * new SQLiteParameter("@strWhere", DbType.VarChar,1000), * }; * parameters[0].Value = "business_feedback"; * parameters[1].Value = "id"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQLite.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod public bool UpdateAll(string strSet) { string strSql = string.Format("update business_feedback set {0}", strSet); int rows = DbHelperSQLite.ExecuteSql(strSql); if (rows > 0) { return(true); } else { return(false); } }
public bool UpdateStatus(int status, string serverid) { string sql = "update IO_DEVICE set IO_DEVICE_STATUS=" + status + " where IO_SERVER_ID='" + serverid + "'"; int rowsAffected = DbHelperSQLite.ExecuteSql(sql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Blogs.Model.BlogUser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BlogUser set "); strSql.Append("loginname=@loginname,"); strSql.Append("oginpwd=@oginpwd,"); strSql.Append("cnname=@cnname,"); strSql.Append("email=@email,"); strSql.Append("islock=@islock,"); strSql.Append("isdel=@isdel,"); strSql.Append("addtime=@addtime,"); strSql.Append("lastlogintime=@lastlogintime,"); strSql.Append("lastloginip=@lastloginip"); strSql.Append(" where id=@id"); SQLiteParameter[] parameters = { new SQLiteParameter("@loginname", DbType.String), new SQLiteParameter("@oginpwd", DbType.String), new SQLiteParameter("@cnname", DbType.String), new SQLiteParameter("@email", DbType.String), new SQLiteParameter("@islock", DbType.bit, 1), new SQLiteParameter("@isdel", DbType.bit, 1), new SQLiteParameter("@addtime", DbType.DateTime), new SQLiteParameter("@lastlogintime", DbType.DateTime), new SQLiteParameter("@lastloginip", DbType.String), new SQLiteParameter("@id", DbType.Int32, 8) }; parameters[0].Value = model.loginname; parameters[1].Value = model.oginpwd; parameters[2].Value = model.cnname; parameters[3].Value = model.email; parameters[4].Value = model.islock; parameters[5].Value = model.isdel; parameters[6].Value = model.addtime; parameters[7].Value = model.lastlogintime; parameters[8].Value = model.lastloginip; parameters[9].Value = model.id; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DXD.Model.insurance_report model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update insurance_report set "); strSql.Append("query_id=@query_id,"); strSql.Append("query_date=@query_date,"); strSql.Append("ins_name=@ins_name,"); strSql.Append("ins_no=@ins_no,"); strSql.Append("ins_company=@ins_company,"); strSql.Append("ins_value=@ins_value,"); strSql.Append("remark=@remark,"); strSql.Append("add_user=@add_user,"); strSql.Append("add_time=@add_time"); strSql.Append(" where id=@id"); SQLiteParameter[] parameters = { new SQLiteParameter("@query_id", DbType.Int32, 8), new SQLiteParameter("@query_date", DbType.DateTime), new SQLiteParameter("@ins_name", DbType.String, 255), new SQLiteParameter("@ins_no", DbType.String, 50), new SQLiteParameter("@ins_company", DbType.String, 200), new SQLiteParameter("@ins_value", DbType.Decimal, 4), new SQLiteParameter("@remark", DbType.String, 255), new SQLiteParameter("@add_user", DbType.String, 50), new SQLiteParameter("@add_time", DbType.DateTime), new SQLiteParameter("@id", DbType.Int32, 8) }; parameters[0].Value = model.query_id; parameters[1].Value = model.query_date; parameters[2].Value = model.ins_name; parameters[3].Value = model.ins_no; parameters[4].Value = model.ins_company; parameters[5].Value = model.ins_value; parameters[6].Value = model.remark; parameters[7].Value = model.add_user; parameters[8].Value = model.add_time; parameters[9].Value = model.id; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }