/// <summary> /// 删除一条数据 /// </summary> public bool Delete(Model.KCInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from KCInfo "); strSql.Append(" where GoodsID=@GoodsID "); SqlParameter[] parameters = { new SqlParameter("@GoodsID", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.GoodsID; int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.KCInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update KCInfo set "); strSql.Append("GoodsName=@GoodsName,"); strSql.Append("CompanyName=@CompanyName,"); strSql.Append("DepotName=@DepotName,"); strSql.Append("GoodsNum=@GoodsNum,"); strSql.Append("AlarmNum=@AlarmNum"); strSql.Append(" where GoodsID=@GoodsID "); SqlParameter[] parameters = { new SqlParameter("@GoodsID", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsName", SqlDbType.NVarChar, 50), new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50), new SqlParameter("@DepotName", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsNum", SqlDbType.Int), new SqlParameter("@AlarmNum", SqlDbType.Int) }; parameters[0].Value = model.GoodsID; parameters[1].Value = model.GoodsName; parameters[2].Value = model.CompanyName; parameters[3].Value = model.DepotName; parameters[4].Value = model.GoodsNum; parameters[5].Value = model.AlarmNum; int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.CompanyInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CompanyInfo("); strSql.Append("CompanyID,CompanyName,CompanyDirector,CompanyPhone,CompanyAddress,CompanyRemarks,ReDateTime,Flag)"); strSql.Append(" values ("); strSql.Append("@CompanyID,@CompanyName,@CompanyDirector,@CompanyPhone,@CompanyAddress,@CompanyRemarks,@ReDateTime,@Flag)"); SqlParameter[] parameters = { new SqlParameter("@CompanyID", SqlDbType.NVarChar, 50), new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50), new SqlParameter("@CompanyDirector", SqlDbType.NVarChar, 50), new SqlParameter("@CompanyPhone", SqlDbType.NVarChar, 50), new SqlParameter("@CompanyAddress", SqlDbType.NVarChar, 50), new SqlParameter("@CompanyRemarks", SqlDbType.NVarChar, 200), new SqlParameter("@ReDateTime", SqlDbType.DateTime), new SqlParameter("@Flag", SqlDbType.Int) }; parameters[0].Value = model.CompanyID; parameters[1].Value = model.CompanyName; parameters[2].Value = model.CompanyDirector; parameters[3].Value = model.CompanyPhone; parameters[4].Value = model.CompanyAddress; parameters[5].Value = model.CompanyRemarks; parameters[6].Value = model.ReDateTime; parameters[7].Value = model.Flag; int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters); if (rows > 0) { return(true); } else { return(false); } }
public static void UpdateVid(MyFileInfo fi) { string sql = "update files set vid='" + fi.Vid + "' where fileId=" + fi.FileId; DBHelper.ExecuteSql(sql); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.JHGoodsInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update JHGoodsInfo set "); strSql.Append("EmployeeID=@EmployeeID,"); strSql.Append("CompanyName=@CompanyName,"); strSql.Append("DepotName=@DepotName,"); strSql.Append("GoodsName=@GoodsName,"); strSql.Append("GoodsNum=@GoodsNum,"); strSql.Append("GoodsUnit=@GoodsUnit,"); strSql.Append("GoodsJHPrice=@GoodsJHPrice,"); strSql.Append("GoodsSellPrice=@GoodsSellPrice,"); strSql.Append("GoodsNeedPay=@GoodsNeedPay,"); strSql.Append("GoodsHasPay=@GoodsHasPay,"); strSql.Append("GoodsRemark=@GoodsRemark,"); strSql.Append("GoodsTime=@GoodsTime "); strSql.Append(" where GoodsID=@GoodsID "); SqlParameter[] parameters = { new SqlParameter("@GoodsID", SqlDbType.NVarChar, 50), new SqlParameter("@EmployeeID", SqlDbType.NVarChar, 50), new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50), new SqlParameter("@DepotName", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsName", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsNum", SqlDbType.Int), new SqlParameter("@GoodsUnit", SqlDbType.NVarChar, 20), new SqlParameter("@GoodsJHPrice", SqlDbType.Float), new SqlParameter("@GoodsSellPrice", SqlDbType.Float), new SqlParameter("@GoodsNeedPay", SqlDbType.Float), new SqlParameter("@GoodsHasPay", SqlDbType.Float), new SqlParameter("@GoodsRemark", SqlDbType.NVarChar, 200), new SqlParameter("@GoodsTime", SqlDbType.DateTime), new SqlParameter("@Flag", SqlDbType.Int) }; parameters[0].Value = model.GoodsID; parameters[1].Value = model.EmployeeID; parameters[2].Value = model.CompanyName; parameters[3].Value = model.DepotName; parameters[4].Value = model.GoodsName; parameters[5].Value = model.GoodsNum; parameters[6].Value = model.GoodsUnit; parameters[7].Value = model.GoodsJHPrice; parameters[8].Value = model.GoodsSellPrice; parameters[9].Value = model.GoodsNeedPay; parameters[10].Value = model.GoodsHasPay; parameters[11].Value = model.GoodsRemark; parameters[12].Value = model.GoodsTime; parameters[13].Value = model.Flag; int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters); if (rows > 0) { return(true); } else { return(false); } }
public static int Update(UserState us) { string sql = "update userstate_tab set name='" + us.Name + "' where id=" + us.Id; return(DBHelper.ExecuteSql(sql)); }
public static int Delete(UserState us) { string sql = "delete userstate_tab where id=" + us.Id; return(DBHelper.ExecuteSql(sql)); }
public static int Insert(UserState us) { string sql = "insert into userstate_tab values('" + us.Name + "')"; return(DBHelper.ExecuteSql(sql)); }
public bool UpdateOneTime(int num, string upDate) { string sql = String.Format(@"Update DeadLine set DateItem='{0}' where ID={1}", upDate, num); DBHelper dbh = new DBHelper(); return dbh.ExecuteSql(sql); }
public bool UpdateOneItem(int num,string upDate,string upCon) { string sql = String.Format(@"Update DeadLine set DateItem='{0}',ContentItem='{1}' where ID={2}", upDate, upCon, num); DBHelper dbh = new DBHelper(); return dbh.ExecuteSql(sql); }
public bool DeleteOneItem(string tab,int userID) { string sql = string.Format(@"delete from {0} where ID={1}", tab,userID); DBHelper dbh = new DBHelper(); return dbh.ExecuteSql(sql); }
public bool AddOneItem(string remindDate, string remindCon) { string sql = String.Format(@"insert into DeadLine(DateItem,ContentItem) values('{0}','{1}')", remindDate, remindCon); DBHelper dbh = new DBHelper(); return dbh.ExecuteSql(sql); }
public static int Update(User u) { string sql = "update user_tab set name='" + u.Name + "',address='" + u.Address + "',tel='" + u.Tel + "',email='" + u.Email + "',state=" + u.User_state.Id + " where id=" + u.Id; return(DBHelper.ExecuteSql(sql)); }
public static int Insert(User u) { string sql = "insert into user_tab values('" + u.Name + "','" + u.Address + "','" + u.Tel + "','" + u.Email + "'," + u.User_state.Id + ")"; return(DBHelper.ExecuteSql(sql)); }