/// <summary> /// 删除一条数据 /// </summary> public bool DeleteFake(string Ma_Code) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Material set"); strSql.Append(" Ma_Clear = 0"); strSql.Append(" where Ma_Code = @Ma_Code"); SqlParameter[] parameters = { new SqlParameter("@Ma_Code", SqlDbType.VarChar, 512) }; parameters[0].Value = Ma_Code; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Material GetModel(int Ma_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Ma_ID,Ma_PicName,Ma_Name,Ma_Model,Ma_RFID,Ma_Barcode,Ma_Code,Ma_TypeID,Ma_TypeName,Ma_Price,Ma_PriceA,Ma_PriceB,Ma_PriceC,Ma_PriceD,Ma_PriceE,Ma_CreateDate,Ma_Supplier,Ma_SupID,Ma_zhujima,Ma_Unit,Ma_InPrice,Ma_OutPrice,Ma_InDate,Ma_Remark,Ma_Enable,Ma_Clear,Ma_Safeyone,Ma_Safetytwo from T_Material "); strSql.Append(" where Ma_ID=@Ma_ID"); SqlParameter[] parameters = { new SqlParameter("@Ma_ID", SqlDbType.Int, 4) }; parameters[0].Value = Ma_ID; Material model = new Material(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 改名称 /// </summary> /// <param name="PIC_Name">名称</param> /// <param name="PIC_Code">编号</param> /// <param name="FPIC_Name">之前的名称</param> /// <returns>受影响行数</returns> public int UpdateNameProjectInCost(string PIC_Name, string PIC_Code, string FPIC_Name) { string sql = string.Format("update T_ProjectInCost set PIC_Name='{0}' where PIC_Code='{1}' and PIC_Name='{2}' and PIC_Clear=1 and PIC_Enable=1", XYEEncoding.strCodeHex(PIC_Name), XYEEncoding.strCodeHex(PIC_Code), XYEEncoding.strCodeHex(FPIC_Name)); return(DbHelperSQL.ExecuteSql(sql)); }
/// <summary> /// 假删除全部 /// </summary> /// <returns>受影响行数</returns> public int UpdateAllClearProjectInCost() { string sql = string.Format("update T_ProjectInCost set PIC_Clear=0 where PIC_Clear=1 and PIC_Enable=1 and PIC_ParentId<>'D4'"); return(DbHelperSQL.ExecuteSql(sql)); }
/// <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"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.article_attribute_field model = new Model.article_attribute_field(); DataSet ds = DbHelperSQL.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> /// 更新一条数据 /// </summary> public bool Update(Model.article_attribute_field model) { using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction 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"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.NVarChar, 100), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@control_type", SqlDbType.NVarChar, 50), new SqlParameter("@data_type", SqlDbType.NVarChar, 50), new SqlParameter("@data_length", SqlDbType.Int, 4), new SqlParameter("@data_place", SqlDbType.TinyInt, 1), new SqlParameter("@item_option", SqlDbType.NText), new SqlParameter("@default_value", SqlDbType.NText), new SqlParameter("@is_required", SqlDbType.TinyInt, 1), new SqlParameter("@is_password", SqlDbType.TinyInt, 1), new SqlParameter("@is_html", SqlDbType.TinyInt, 1), new SqlParameter("@editor_type", SqlDbType.TinyInt, 1), new SqlParameter("@valid_tip_msg", SqlDbType.NVarChar, 255), new SqlParameter("@valid_error_msg", SqlDbType.NVarChar, 255), new SqlParameter("@valid_pattern", SqlDbType.NVarChar, 500), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@is_sys", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.id; parameters[1].Value = model.name; parameters[2].Value = model.title; parameters[3].Value = model.control_type; parameters[4].Value = model.data_type; parameters[5].Value = model.data_length; parameters[6].Value = model.data_place; parameters[7].Value = model.item_option; parameters[8].Value = model.default_value; parameters[9].Value = model.is_required; parameters[10].Value = model.is_password; parameters[11].Value = model.is_html; parameters[12].Value = model.editor_type; parameters[13].Value = model.valid_tip_msg; parameters[14].Value = model.valid_error_msg; parameters[15].Value = model.valid_pattern; parameters[16].Value = model.sort_id; parameters[17].Value = model.is_sys; DbHelperSQL.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); DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString()); //没有错误确认事务 trans.Commit(); } catch { trans.Rollback(); return(false); } } } return(true); }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQL.GetMaxID("id", "dt_active_user")); }
/// <summary> /// 添加人员信息 /// </summary> /// <param name="empolyee">参数实体类</param> /// <returns></returns> public int InsEmpolyee(Empolyee empolyee) { string sql = @"INSERT INTO T_Empolyee (Emp_Code ,Emp_Name ,Emp_Password ,Emp_UserRole ,Emp_Area ,Emp_zhiwen ,Emp_CardCode ,Emp_Depid ,Emp_Sex ,Emp_Card ,Emp_State ,Emp_Phone ,Emp_Bank ,Emp_OpenBank ,Emp_Birthday ,Emp_Email ,Emp_Education ,Emp_School ,Emp_Entry ,Emp_Enable ,Emp_Clear ) VALUES (@Emp_Code ,@Emp_Name ,@Emp_Password ,@Emp_UserRole ,@Emp_Area ,@Emp_zhiwen ,@Emp_CardCode ,@Emp_Depid ,@Emp_Sex ,@Emp_Card ,@Emp_State ,@Emp_Phone ,@Emp_Bank ,@Emp_OpenBank ,@Emp_Birthday ,@Emp_Email ,@Emp_Education ,@Emp_School ,@Emp_Entry ,@Emp_Enable ,@Emp_Clear )"; SqlParameter[] sps = { new SqlParameter("@Emp_Code", XYEEncoding.strCodeHex(empolyee.Emp_Code)), new SqlParameter("@Emp_Name", XYEEncoding.strCodeHex(empolyee.Emp_Name)), new SqlParameter("@Emp_Password", XYEEncoding.strCodeHex(empolyee.Emp_Password)), new SqlParameter("@Emp_UserRole", XYEEncoding.strCodeHex(empolyee.Emp_UserRole)), new SqlParameter("@Emp_Area", XYEEncoding.strCodeHex(empolyee.Emp_Area)), new SqlParameter("@Emp_zhiwen", empolyee.Emp_zhiwen), new SqlParameter("@Emp_CardCode", XYEEncoding.strCodeHex(empolyee.Emp_CardCode)), new SqlParameter("@Emp_Depid", XYEEncoding.strCodeHex(empolyee.Emp_Depid)), new SqlParameter("@Emp_Sex", XYEEncoding.strCodeHex(empolyee.Emp_Sex)), new SqlParameter("@Emp_Card", XYEEncoding.strCodeHex(empolyee.Emp_Card)), new SqlParameter("@Emp_State", empolyee.Emp_State), new SqlParameter("@Emp_Phone", XYEEncoding.strCodeHex(empolyee.Emp_Phone)), new SqlParameter("@Emp_Bank", XYEEncoding.strCodeHex(empolyee.Emp_Bank)), new SqlParameter("@Emp_OpenBank", XYEEncoding.strCodeHex(empolyee.Emp_OpenBank)), new SqlParameter("@Emp_Birthday", empolyee.Emp_Birthday), new SqlParameter("@Emp_Email", XYEEncoding.strCodeHex(empolyee.Emp_Email)), new SqlParameter("@Emp_Education", XYEEncoding.strCodeHex(empolyee.Emp_Education)), new SqlParameter("@Emp_School", XYEEncoding.strCodeHex(empolyee.Emp_School)), new SqlParameter("@Emp_Entry", empolyee.Emp_Entry), new SqlParameter("@Emp_Enable", empolyee.Emp_Enable), new SqlParameter("@Emp_Clear", empolyee.Emp_Clear) }; return(DbHelperSQL.ExecuteSql(sql, sps)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.users model) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "users("); strSql.Append("group_id,express_id,user_name,password,salt,email,nick_name,avatar,sex,birthday,telphone,mobile,qq,address,safe_question,safe_answer,amount,point,exp,status,reg_time,reg_ip,wechat,companyid,taxid,ref1,ref2,ref3)"); strSql.Append(" values ("); strSql.Append("@group_id,@express_id,@user_name,@password,@salt,@email,@nick_name,@avatar,@sex,@birthday,@telphone,@mobile,@qq,@address,@safe_question,@safe_answer,@amount,@point,@exp,@status,@reg_time,@reg_ip,@wechat,@companyid,@taxid,@ref1,@ref2,@ref3)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@group_id", SqlDbType.Int, 4), new SqlParameter("@express_id", SqlDbType.Int, 4), new SqlParameter("@user_name", SqlDbType.NVarChar, 100), new SqlParameter("@password", SqlDbType.NVarChar, 100), new SqlParameter("@salt", SqlDbType.NVarChar, 20), new SqlParameter("@email", SqlDbType.NVarChar, 50), new SqlParameter("@nick_name", SqlDbType.NVarChar, 100), new SqlParameter("@avatar", SqlDbType.NVarChar, 255), new SqlParameter("@sex", SqlDbType.NVarChar, 20), new SqlParameter("@birthday", SqlDbType.DateTime), new SqlParameter("@telphone", SqlDbType.NVarChar, 50), new SqlParameter("@mobile", SqlDbType.NVarChar, 20), new SqlParameter("@qq", SqlDbType.NVarChar, 30), new SqlParameter("@address", SqlDbType.NVarChar, 255), new SqlParameter("@safe_question", SqlDbType.NVarChar, 255), new SqlParameter("@safe_answer", SqlDbType.NVarChar, 255), new SqlParameter("@amount", SqlDbType.Decimal, 5), new SqlParameter("@point", SqlDbType.Int, 4), new SqlParameter("@exp", SqlDbType.Int, 4), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@reg_time", SqlDbType.DateTime), new SqlParameter("@reg_ip", SqlDbType.NVarChar, 30), new SqlParameter("@wechat", SqlDbType.VarChar, 50), new SqlParameter("@companyid", SqlDbType.VarChar, 100), new SqlParameter("@taxid", SqlDbType.VarChar, 100), new SqlParameter("@ref1", SqlDbType.VarChar, 100), new SqlParameter("@ref2", SqlDbType.VarChar, 100), new SqlParameter("@ref3", SqlDbType.VarChar, 100) }; parameters[0].Value = model.group_id; parameters[1].Value = model.express_id; parameters[2].Value = model.user_name; parameters[3].Value = model.password; parameters[4].Value = model.salt; parameters[5].Value = model.email; parameters[6].Value = model.nick_name; parameters[7].Value = model.avatar; parameters[8].Value = model.sex; parameters[9].Value = model.birthday; parameters[10].Value = model.telphone; parameters[11].Value = model.mobile; parameters[12].Value = model.qq; parameters[13].Value = model.address; parameters[14].Value = model.safe_question; parameters[15].Value = model.safe_answer; parameters[16].Value = model.amount; parameters[17].Value = model.point; parameters[18].Value = model.exp; parameters[19].Value = model.status; parameters[20].Value = model.reg_time; parameters[21].Value = model.reg_ip; parameters[22].Value = model.wechat; parameters[23].Value = model.companyid; parameters[24].Value = model.taxid; parameters[25].Value = model.ref1; parameters[26].Value = model.ref2; parameters[27].Value = model.ref3; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } } catch (Exception) { throw; } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQL.GetMaxID("id", "tb_DeviceOUT")); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(tb_DeviceOUT model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_DeviceOUT set "); strSql.Append("deviceId=@deviceId,"); strSql.Append("amount=@amount,"); strSql.Append("userId1=@userId1,"); strSql.Append("useFor=@useFor,"); strSql.Append("gDate=@gDate,"); strSql.Append("userId2=@userId2,"); strSql.Append("bDate=@bDate,"); strSql.Append("userId3=@userId3,"); strSql.Append("remark=@remark,"); strSql.Append("createUser=@createUser,"); strSql.Append("createDate=@createDate,"); strSql.Append("updateUser=@updateUser,"); strSql.Append("updateDate=@updateDate,"); strSql.Append("temp1=@temp1,"); strSql.Append("temp2=@temp2"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@deviceId", SqlDbType.Int, 4), new SqlParameter("@amount", SqlDbType.Int, 4), new SqlParameter("@userId1", SqlDbType.Int, 4), new SqlParameter("@useFor", SqlDbType.Text), new SqlParameter("@gDate", SqlDbType.DateTime), new SqlParameter("@userId2", SqlDbType.Int, 4), new SqlParameter("@bDate", SqlDbType.DateTime), new SqlParameter("@userId3", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.Text), new SqlParameter("@createUser", SqlDbType.Int, 4), new SqlParameter("@createDate", SqlDbType.DateTime), new SqlParameter("@updateUser", SqlDbType.Int, 4), new SqlParameter("@updateDate", SqlDbType.DateTime), new SqlParameter("@temp1", SqlDbType.Text), new SqlParameter("@temp2", SqlDbType.Text), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.deviceId; parameters[1].Value = model.amount; parameters[2].Value = model.userId1; parameters[3].Value = model.useFor; parameters[4].Value = model.gDate; parameters[5].Value = model.userId2; parameters[6].Value = model.bDate; parameters[7].Value = model.userId3; parameters[8].Value = model.remark; parameters[9].Value = model.createUser; parameters[10].Value = model.createDate; parameters[11].Value = model.updateUser; parameters[12].Value = model.updateDate; parameters[13].Value = model.temp1; parameters[14].Value = model.temp2; parameters[15].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Material model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Material("); strSql.Append("Ma_PicName,Ma_Name,Ma_Model,Ma_RFID,Ma_Barcode,Ma_Code,Ma_TypeID,Ma_TypeName,Ma_Price,Ma_PriceA,Ma_PriceB,Ma_PriceC,Ma_PriceD,Ma_PriceE,Ma_CreateDate,Ma_Supplier,Ma_SupID,Ma_zhujima,Ma_Unit,Ma_InPrice,Ma_OutPrice,Ma_InDate,Ma_Remark,Ma_Enable,Ma_Clear,Ma_Safeyone,Ma_Safetytwo)"); strSql.Append(" values ("); strSql.Append("@Ma_PicName,@Ma_Name,@Ma_Model,@Ma_RFID,@Ma_Barcode,@Ma_Code,@Ma_TypeID,@Ma_TypeName,@Ma_Price,@Ma_PriceA,@Ma_PriceB,@Ma_PriceC,@Ma_PriceD,@Ma_PriceE,@Ma_CreateDate,@Ma_Supplier,@Ma_SupID,@Ma_zhujima,@Ma_Unit,@Ma_InPrice,@Ma_OutPrice,@Ma_InDate,@Ma_Remark,@Ma_Enable,@Ma_Clear,@Ma_Safeyone,@Ma_Safetytwo)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Ma_PicName", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_Name", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_Model", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_RFID", SqlDbType.NVarChar, 1024), new SqlParameter("@Ma_Barcode", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_Code", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_TypeID", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_TypeName", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_Price", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_PriceA", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_PriceB", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_PriceC", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_PriceD", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_PriceE", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_CreateDate", SqlDbType.DateTime), new SqlParameter("@Ma_Supplier", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_SupID", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_zhujima", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_Unit", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_InPrice", SqlDbType.Decimal), new SqlParameter("@Ma_OutPrice", SqlDbType.Decimal), new SqlParameter("@Ma_InDate", SqlDbType.DateTime), new SqlParameter("@Ma_Remark", SqlDbType.NVarChar, 1024), new SqlParameter("@Ma_Enable", SqlDbType.Int, 4), new SqlParameter("@Ma_Clear", SqlDbType.Int, 4), new SqlParameter("@Ma_Safeyone", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_Safetytwo", SqlDbType.NVarChar, 512) }; parameters[0].Value = model.Ma_PicName; parameters[1].Value = model.Ma_Name; parameters[2].Value = model.Ma_Model; parameters[3].Value = model.Ma_RFID; parameters[4].Value = model.Ma_Barcode; parameters[5].Value = model.Ma_Code; parameters[6].Value = model.Ma_TypeID; parameters[7].Value = model.Ma_TypeName; parameters[8].Value = model.Ma_Price; parameters[9].Value = model.Ma_PriceA; parameters[10].Value = model.Ma_PriceB; parameters[11].Value = model.Ma_PriceC; parameters[12].Value = model.Ma_PriceD; parameters[13].Value = model.Ma_PriceE; parameters[14].Value = model.Ma_CreateDate; parameters[15].Value = model.Ma_Supplier; parameters[16].Value = model.Ma_SupID; parameters[17].Value = model.Ma_zhujima; parameters[18].Value = model.Ma_Unit; parameters[19].Value = model.Ma_InPrice; parameters[20].Value = model.Ma_OutPrice; parameters[21].Value = model.Ma_InDate; parameters[22].Value = model.Ma_Remark; parameters[23].Value = model.Ma_Enable; parameters[24].Value = model.Ma_Clear; parameters[25].Value = model.Ma_Safeyone; parameters[26].Value = model.Ma_Safetytwo; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQL.GetMaxID("Ma_ID", "T_Material")); }
/// <summary> /// 假删除 /// </summary> /// <param name="code">客户编码</param> /// <returns></returns> public int FalseDelClear(string code) { string sql = string.Format("update T_Empolyee set Emp_Clear=0 where Emp_Clear=1 and Emp_Code='{0}'", code); return(DbHelperSQL.ExecuteSql(sql)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "users set "); strSql.Append("group_id=@group_id,"); strSql.Append("user_name=@user_name,"); strSql.Append("password=@password,"); strSql.Append("salt=@salt,"); strSql.Append("email=@email,"); strSql.Append("nick_name=@nick_name,"); strSql.Append("avatar=@avatar,"); strSql.Append("sex=@sex,"); strSql.Append("birthday=@birthday,"); strSql.Append("telphone=@telphone,"); strSql.Append("mobile=@mobile,"); strSql.Append("qq=@qq,"); strSql.Append("address=@address,"); strSql.Append("safe_question=@safe_question,"); strSql.Append("safe_answer=@safe_answer,"); strSql.Append("amount=@amount,"); strSql.Append("point=@point,"); strSql.Append("exp=@exp,"); strSql.Append("status=@status,"); strSql.Append("express_id=@express_id,"); strSql.Append("reg_time=@reg_time,"); strSql.Append("wechat=@wechat,"); strSql.Append("companyid=@companyid,"); strSql.Append("companyname=@companyname,"); strSql.Append("companyaddress=@companyaddress,"); strSql.Append("taxid=@taxid,"); strSql.Append("reg_ip=@reg_ip"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@group_id", SqlDbType.Int, 4), new SqlParameter("@user_name", SqlDbType.NVarChar, 100), new SqlParameter("@password", SqlDbType.NVarChar, 100), new SqlParameter("@salt", SqlDbType.NVarChar, 20), new SqlParameter("@email", SqlDbType.NVarChar, 50), new SqlParameter("@nick_name", SqlDbType.NVarChar, 100), new SqlParameter("@avatar", SqlDbType.NVarChar, 255), new SqlParameter("@sex", SqlDbType.NVarChar, 20), new SqlParameter("@birthday", SqlDbType.DateTime), new SqlParameter("@telphone", SqlDbType.NVarChar, 50), new SqlParameter("@mobile", SqlDbType.NVarChar, 20), new SqlParameter("@qq", SqlDbType.NVarChar, 30), new SqlParameter("@address", SqlDbType.NVarChar, 255), new SqlParameter("@safe_question", SqlDbType.NVarChar, 255), new SqlParameter("@safe_answer", SqlDbType.NVarChar, 255), new SqlParameter("@amount", SqlDbType.Decimal, 5), new SqlParameter("@point", SqlDbType.Int, 4), new SqlParameter("@exp", SqlDbType.Int, 4), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@express_id", SqlDbType.Int, 4), new SqlParameter("@reg_time", SqlDbType.DateTime), new SqlParameter("@wechat", SqlDbType.NVarChar, 50), new SqlParameter("@companyid", SqlDbType.NVarChar, 100), new SqlParameter("@companyname", SqlDbType.NVarChar, 100), new SqlParameter("@companyaddress", SqlDbType.NVarChar, 255), new SqlParameter("@taxid", SqlDbType.NVarChar, 100), new SqlParameter("@reg_ip", SqlDbType.NVarChar, 30) }; parameters[0].Value = model.id; parameters[1].Value = model.group_id; parameters[2].Value = model.user_name; parameters[3].Value = model.password; parameters[4].Value = model.salt; parameters[5].Value = model.email; parameters[6].Value = model.nick_name; parameters[7].Value = model.avatar; parameters[8].Value = model.sex; parameters[9].Value = model.birthday; parameters[10].Value = model.telphone; parameters[11].Value = model.mobile; parameters[12].Value = model.qq; parameters[13].Value = model.address; parameters[14].Value = model.safe_question; parameters[15].Value = model.safe_answer; parameters[16].Value = model.amount; parameters[17].Value = model.point; parameters[18].Value = model.exp; parameters[19].Value = model.status; parameters[20].Value = model.express_id; parameters[21].Value = model.reg_time; parameters[22].Value = model.wechat; parameters[23].Value = model.companyid; parameters[24].Value = model.companyname; parameters[25].Value = model.companyaddress; parameters[26].Value = model.taxid; parameters[27].Value = model.reg_ip; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 全部删除 /// </summary> /// <returns></returns> public int FalseALLDelClear() { string sql = string.Format("update T_Empolyee set Emp_Clear=0 where Emp_Clear=1"); return(DbHelperSQL.ExecuteSql(sql)); }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //获取用户旧数据 Model.users model = GetModel(id); if (model == null) { return(false); } List <CommandInfo> sqllist = new List <CommandInfo>(); //删除积分记录 StringBuilder strSql1 = new StringBuilder(); strSql1.Append("delete from " + databaseprefix + "user_point_log "); strSql1.Append(" where user_id=@id"); SqlParameter[] parameters1 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters1[0].Value = id; CommandInfo cmd = new CommandInfo(strSql1.ToString(), parameters1); sqllist.Add(cmd); //删除金额记录 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "user_amount_log "); strSql2.Append(" where user_id=@id"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters2[0].Value = id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //删除短消息 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("delete from " + databaseprefix + "user_message "); strSql3.Append(" where post_user_name=@post_user_name or accept_user_name=@accept_user_name"); SqlParameter[] parameters3 = { new SqlParameter("@post_user_name", SqlDbType.NVarChar, 100), new SqlParameter("@accept_user_name", SqlDbType.NVarChar, 100) }; parameters3[0].Value = model.user_name; parameters3[1].Value = model.user_name; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); //删除申请码 StringBuilder strSql4 = new StringBuilder(); strSql4.Append("delete from " + databaseprefix + "user_code "); strSql4.Append(" where user_id=@id"); SqlParameter[] parameters4 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters4[0].Value = id; cmd = new CommandInfo(strSql4.ToString(), parameters4); sqllist.Add(cmd); //删除登录日志 StringBuilder strSql5 = new StringBuilder(); strSql5.Append("delete from " + databaseprefix + "user_login_log "); strSql5.Append(" where user_id=@id"); SqlParameter[] parameters5 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters5[0].Value = id; cmd = new CommandInfo(strSql5.ToString(), parameters5); sqllist.Add(cmd); //删除用户记录 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "users "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQL.GetMaxID("Id", "Users")); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.users GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from " + databaseprefix + "users "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.users model = new Model.users(); DataSet ds = DbHelperSQL.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()); } if (ds.Tables[0].Rows[0]["group_id"].ToString() != "") { model.group_id = int.Parse(ds.Tables[0].Rows[0]["group_id"].ToString()); } if (ds.Tables[0].Rows[0]["express_id"].ToString() != "") { model.express_id = int.Parse(ds.Tables[0].Rows[0]["express_id"].ToString()); } model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString(); model.password = ds.Tables[0].Rows[0]["password"].ToString(); model.salt = ds.Tables[0].Rows[0]["salt"].ToString(); model.email = ds.Tables[0].Rows[0]["email"].ToString(); model.nick_name = ds.Tables[0].Rows[0]["nick_name"].ToString(); model.avatar = ds.Tables[0].Rows[0]["avatar"].ToString(); model.sex = ds.Tables[0].Rows[0]["sex"].ToString(); if (ds.Tables[0].Rows[0]["birthday"].ToString() != "") { model.birthday = DateTime.Parse(ds.Tables[0].Rows[0]["birthday"].ToString()); } model.telphone = ds.Tables[0].Rows[0]["telphone"].ToString(); model.mobile = ds.Tables[0].Rows[0]["mobile"].ToString(); model.qq = ds.Tables[0].Rows[0]["qq"].ToString(); model.address = ds.Tables[0].Rows[0]["address"].ToString(); model.safe_question = ds.Tables[0].Rows[0]["safe_question"].ToString(); model.safe_answer = ds.Tables[0].Rows[0]["safe_answer"].ToString(); if (ds.Tables[0].Rows[0]["amount"].ToString() != "") { model.amount = decimal.Parse(ds.Tables[0].Rows[0]["amount"].ToString()); } if (ds.Tables[0].Rows[0]["point"].ToString() != "") { model.point = int.Parse(ds.Tables[0].Rows[0]["point"].ToString()); } if (ds.Tables[0].Rows[0]["exp"].ToString() != "") { model.exp = int.Parse(ds.Tables[0].Rows[0]["exp"].ToString()); } if (ds.Tables[0].Rows[0]["status"].ToString() != "") { model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString()); } if (ds.Tables[0].Rows[0]["reg_time"].ToString() != "") { model.reg_time = DateTime.Parse(ds.Tables[0].Rows[0]["reg_time"].ToString()); } model.reg_ip = ds.Tables[0].Rows[0]["reg_ip"].ToString(); model.wechat = ds.Tables[0].Rows[0]["wechat"].ToString(); model.companyaddress = ds.Tables[0].Rows[0]["companyaddress"].ToString(); model.companyid = ds.Tables[0].Rows[0]["companyid"].ToString(); model.companyname = ds.Tables[0].Rows[0]["companyname"].ToString(); model.taxid = ds.Tables[0].Rows[0]["taxid"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(DbHelperSQL.GetMaxID("RevertID", "Revert")); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Admin model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Admin set "); strSql.Append("UserName=@UserName,"); strSql.Append("PassWord=@PassWord,"); strSql.Append("ReallyName=@ReallyName,"); strSql.Append("Birthday=@Birthday,"); strSql.Append("Address=@Address,"); strSql.Append("PostCode=@PostCode,"); strSql.Append("Email=@Email,"); strSql.Append("HomePhone=@HomePhone,"); strSql.Append("MobilePhone=@MobilePhone,"); strSql.Append("QQ=@QQ,"); strSql.Append("ICQ=@ICQ,"); strSql.Append("RegTime=@RegTime,"); strSql.Append("Sex=@Sex,"); strSql.Append("IP=@IP,"); strSql.Append("BlogID=@BlogID,"); strSql.Append("SuperAdmin=@SuperAdmin"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@PassWord", SqlDbType.NVarChar, 50), new SqlParameter("@ReallyName", SqlDbType.NVarChar, 50), new SqlParameter("@Birthday", SqlDbType.NVarChar, 50), new SqlParameter("@Address", SqlDbType.NVarChar, 100), new SqlParameter("@PostCode", SqlDbType.NVarChar, 50), new SqlParameter("@Email", SqlDbType.NVarChar, 50), new SqlParameter("@HomePhone", SqlDbType.NVarChar, 50), new SqlParameter("@MobilePhone", SqlDbType.NVarChar, 50), new SqlParameter("@QQ", SqlDbType.NVarChar, 50), new SqlParameter("@ICQ", SqlDbType.NVarChar, 50), new SqlParameter("@RegTime", SqlDbType.DateTime), new SqlParameter("@Sex", SqlDbType.NVarChar, 4), new SqlParameter("@IP", SqlDbType.NVarChar, 20), new SqlParameter("@BlogID", SqlDbType.Int, 4), new SqlParameter("@SuperAdmin", SqlDbType.NVarChar, 4), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.UserName; parameters[1].Value = model.PassWord; parameters[2].Value = model.ReallyName; parameters[3].Value = model.Birthday; parameters[4].Value = model.Address; parameters[5].Value = model.PostCode; parameters[6].Value = model.Email; parameters[7].Value = model.HomePhone; parameters[8].Value = model.MobilePhone; parameters[9].Value = model.QQ; parameters[10].Value = model.ICQ; parameters[11].Value = model.RegTime; parameters[12].Value = model.Sex; parameters[13].Value = model.IP; parameters[14].Value = model.BlogID; parameters[15].Value = model.SuperAdmin; parameters[16].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //取得Model信息 Model.article_attribute_field model = GetModel(id); //开始删除 using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction 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"); //SqlParameter[] parameters1 = { // new SqlParameter("@field_id", SqlDbType.Int,4)}; //parameters1[0].Value = id; //DataTable dt = DbHelperSQL.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"); //SqlParameter[] parameters2 = { // new SqlParameter("@field_id", SqlDbType.Int,4)}; //parameters2[0].Value = id; //DbHelperSQL.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"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters); //删除扩展字段表中一列 DbHelperSQL.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(DbHelperSQL.GetMaxID("ID", "Admin")); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.article_attribute_field model) { 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)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NVarChar, 100), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@control_type", SqlDbType.NVarChar, 50), new SqlParameter("@data_type", SqlDbType.NVarChar, 50), new SqlParameter("@data_length", SqlDbType.Int, 4), new SqlParameter("@data_place", SqlDbType.TinyInt, 1), new SqlParameter("@item_option", SqlDbType.NText), new SqlParameter("@default_value", SqlDbType.NText), new SqlParameter("@is_required", SqlDbType.TinyInt, 1), new SqlParameter("@is_password", SqlDbType.TinyInt, 1), new SqlParameter("@is_html", SqlDbType.TinyInt, 1), new SqlParameter("@editor_type", SqlDbType.TinyInt, 1), new SqlParameter("@valid_tip_msg", SqlDbType.NVarChar, 255), new SqlParameter("@valid_error_msg", SqlDbType.NVarChar, 255), new SqlParameter("@valid_pattern", SqlDbType.NVarChar, 500), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@is_sys", SqlDbType.TinyInt, 1), new SqlParameter("@ReturnValue", SqlDbType.Int) }; 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].Direction = ParameterDirection.Output; List <CommandInfo> sqllist = new List <CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //增加扩展字段表中一列 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("alter table " + databaseprefix + "article_attribute_value add " + model.name + " " + model.data_type); SqlParameter[] parameters2 = { }; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return((int)parameters[17].Value); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Material model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Material set "); strSql.Append("Ma_PicName=@Ma_PicName,"); strSql.Append("Ma_Name=@Ma_Name,"); strSql.Append("Ma_Model=@Ma_Model,"); strSql.Append("Ma_RFID=@Ma_RFID,"); strSql.Append("Ma_Barcode=@Ma_Barcode,"); strSql.Append("Ma_Code=@Ma_Code,"); strSql.Append("Ma_TypeID=@Ma_TypeID,"); strSql.Append("Ma_TypeName=@Ma_TypeName,"); strSql.Append("Ma_Price=@Ma_Price,"); strSql.Append("Ma_PriceA=@Ma_PriceA,"); strSql.Append("Ma_PriceB=@Ma_PriceB,"); strSql.Append("Ma_PriceC=@Ma_PriceC,"); strSql.Append("Ma_PriceD=@Ma_PriceD,"); strSql.Append("Ma_PriceE=@Ma_PriceE,"); strSql.Append("Ma_CreateDate=@Ma_CreateDate,"); strSql.Append("Ma_Supplier=@Ma_Supplier,"); strSql.Append("Ma_SupID=@Ma_SupID,"); strSql.Append("Ma_zhujima=@Ma_zhujima,"); strSql.Append("Ma_Unit=@Ma_Unit,"); strSql.Append("Ma_InPrice=@Ma_InPrice,"); strSql.Append("Ma_OutPrice=@Ma_OutPrice,"); strSql.Append("Ma_InDate=@Ma_InDate,"); strSql.Append("Ma_Remark=@Ma_Remark,"); strSql.Append("Ma_Enable=@Ma_Enable,"); strSql.Append("Ma_Clear=@Ma_Clear,"); strSql.Append("Ma_Safeyone=@Ma_Safeyone,"); strSql.Append("Ma_Safetytwo=@Ma_Safetytwo"); strSql.Append(" where Ma_ID=@Ma_ID"); SqlParameter[] parameters = { new SqlParameter("@Ma_PicName", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_Name", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_Model", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_RFID", SqlDbType.NVarChar, 1024), new SqlParameter("@Ma_Barcode", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_Code", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_TypeID", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_TypeName", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_Price", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_PriceA", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_PriceB", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_PriceC", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_PriceD", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_PriceE", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_CreateDate", SqlDbType.DateTime), new SqlParameter("@Ma_Supplier", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_SupID", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_zhujima", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_Unit", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_InPrice", SqlDbType.Decimal), new SqlParameter("@Ma_OutPrice", SqlDbType.Decimal), new SqlParameter("@Ma_InDate", SqlDbType.DateTime), new SqlParameter("@Ma_Remark", SqlDbType.NVarChar, 1024), new SqlParameter("@Ma_Enable", SqlDbType.Int, 4), new SqlParameter("@Ma_Clear", SqlDbType.Int, 4), new SqlParameter("@Ma_Safeyone", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_Safetytwo", SqlDbType.NVarChar, 512), new SqlParameter("@Ma_ID", SqlDbType.Int, 4) }; parameters[0].Value = model.Ma_PicName; parameters[1].Value = model.Ma_Name; parameters[2].Value = model.Ma_Model; parameters[3].Value = model.Ma_RFID; parameters[4].Value = model.Ma_Barcode; parameters[5].Value = model.Ma_Code; parameters[6].Value = model.Ma_TypeID; parameters[7].Value = model.Ma_TypeName; parameters[8].Value = model.Ma_Price; parameters[9].Value = model.Ma_PriceA; parameters[10].Value = model.Ma_PriceB; parameters[11].Value = model.Ma_PriceC; parameters[12].Value = model.Ma_PriceD; parameters[13].Value = model.Ma_PriceE; parameters[14].Value = model.Ma_CreateDate; parameters[15].Value = model.Ma_Supplier; parameters[16].Value = model.Ma_SupID; parameters[17].Value = model.Ma_zhujima; parameters[18].Value = model.Ma_Unit; parameters[19].Value = model.Ma_InPrice; parameters[20].Value = model.Ma_OutPrice; parameters[21].Value = model.Ma_InDate; parameters[22].Value = model.Ma_Remark; parameters[23].Value = model.Ma_Enable; parameters[24].Value = model.Ma_Clear; parameters[25].Value = model.Ma_Safeyone; parameters[26].Value = model.Ma_Safetytwo; parameters[27].Value = model.Ma_ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }