/// <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>
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 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>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateByCode(Client model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Client set ");
strSql.Append("Cli_zhiwen=@Cli_zhiwen,");
strSql.Append("Cli_Name=@Cli_Name,");
strSql.Append("Cli_PicName=@Cli_PicName,");
strSql.Append("Cli_Phone=@Cli_Phone,");
strSql.Append("Cli_PhoneTwo=@Cli_PhoneTwo,");
strSql.Append("Cli_faxes=@Cli_faxes,");
strSql.Append("Cli_CityCode=@Cli_CityCode,");
strSql.Append("Cli_area=@Cli_area,");
strSql.Append("Cli_Address=@Cli_Address,");
strSql.Append("Cli_LinkMan=@Cli_LinkMan,");
strSql.Append("Cli_TypeCode=@Cli_TypeCode,");
strSql.Append("Cli_TypeName=@Cli_TypeName,");
strSql.Append("Cli_Company=@Cli_Company,");
strSql.Append("Cli_DiscountCode=@Cli_DiscountCode,");
strSql.Append("Cli_Bankaccounts=@Cli_Bankaccounts,");
strSql.Append("Cli_OpenBank=@Cli_OpenBank,");
strSql.Append("Cli_Olddata=@Cli_Olddata,");
strSql.Append("Cli_Oldreturn=@Cli_Oldreturn,");
strSql.Append("Cli_Newoutdata=@Cli_Newoutdata,");
strSql.Append("Cli_Newintodata=@Cli_Newintodata,");
strSql.Append("Cli_Createdata=@Cli_Createdata,");
strSql.Append("Cli_Limit=@Cli_Limit,");
strSql.Append("Cli_RemainLimit=@Cli_RemainLimit,");
strSql.Append("Cli_ClearLimitdate=@Cli_ClearLimitdate,");
strSql.Append("Cli_ShouldMoney=@Cli_ShouldMoney,");
strSql.Append("Cli_GetMoney=@Cli_GetMoney,");
strSql.Append("Cli_PreMoney=@Cli_PreMoney,");
strSql.Append("Cli_Remark=@Cli_Remark,");
strSql.Append("Cli_safetone=@Cli_safetone,");
strSql.Append("Cli_safettwo=@Cli_safettwo,");
strSql.Append("Cli_Enable=@Cli_Enable");
strSql.Append(" where Cli_Code=@Cli_Code");
SqlParameter[] parameters =
{
new SqlParameter("@Cli_zhiwen", SqlDbType.NVarChar, -1),
new SqlParameter("@Cli_Name", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_PicName", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_Phone", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_PhoneTwo", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_faxes", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_CityCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_area", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_Address", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_LinkMan", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_Company", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_TypeCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_TypeName", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_DiscountCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_Bankaccounts", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_OpenBank", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_Olddata", SqlDbType.DateTime),
new SqlParameter("@Cli_Oldreturn", SqlDbType.DateTime),
new SqlParameter("@Cli_Newoutdata", SqlDbType.DateTime),
new SqlParameter("@Cli_Newintodata", SqlDbType.DateTime),
new SqlParameter("@Cli_Createdata", SqlDbType.DateTime),
new SqlParameter("@Cli_Limit", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_RemainLimit", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_ClearLimitdate", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_ShouldMoney", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_GetMoney", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_PreMoney", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_Remark", SqlDbType.NVarChar, 1024),
new SqlParameter("@Cli_safetone", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_safettwo", SqlDbType.NVarChar, 512),
new SqlParameter("@Cli_Enable", SqlDbType.Int, 4),
new SqlParameter("@Cli_Code", SqlDbType.NVarChar, 512)
};
parameters[0].Value = model.Cli_zhiwen;
parameters[1].Value = model.Cli_Name;
parameters[2].Value = model.Cli_PicName;
parameters[3].Value = model.Cli_Phone;
parameters[4].Value = model.Cli_PhoneTwo;
parameters[5].Value = model.Cli_faxes;
parameters[6].Value = model.Cli_CityCode;
parameters[7].Value = model.Cli_area;
parameters[8].Value = model.Cli_Address;
parameters[9].Value = model.Cli_LinkMan;
parameters[10].Value = model.Cli_Company;
parameters[11].Value = model.Cli_TypeCode;
parameters[12].Value = model.Cli_TypeName;
parameters[13].Value = model.Cli_DiscountCode;
parameters[14].Value = model.Cli_Bankaccounts;
parameters[15].Value = model.Cli_OpenBank;
parameters[16].Value = model.Cli_Olddata;
parameters[17].Value = model.Cli_Oldreturn;
parameters[18].Value = model.Cli_Newoutdata;
parameters[19].Value = model.Cli_Newintodata;
parameters[20].Value = model.Cli_Createdata;
parameters[21].Value = model.Cli_Limit;
parameters[22].Value = model.Cli_RemainLimit;
parameters[23].Value = model.Cli_ClearLimitdate;
parameters[24].Value = model.Cli_ShouldMoney;
parameters[25].Value = model.Cli_GetMoney;
parameters[26].Value = model.Cli_PreMoney;
parameters[27].Value = model.Cli_Remark;
parameters[28].Value = model.Cli_safetone;
parameters[29].Value = model.Cli_safettwo;
parameters[30].Value = model.Cli_Enable;
parameters[31].Value = model.Cli_Code;
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>
/// 更新一条数据
/// </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);
}
}
/// <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>
/// 更新一条数据
/// </summary>
public bool Update(tb_DrugCheck model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_DrugCheck set ");
strSql.Append("drugCode=@drugCode,");
strSql.Append("drugName=@drugName,");
strSql.Append("drugId=@drugId,");
strSql.Append("drugInId=@drugInId,");
strSql.Append("drugOutId=@drugOutId,");
strSql.Append("outDate=@outDate,");
strSql.Append("unit=@unit,");
strSql.Append("amountIN=@amountIN,");
strSql.Append("amountOUT=@amountOUT,");
strSql.Append("amount=@amount,");
strSql.Append("riskLevel=@riskLevel,");
strSql.Append("checkDate=@checkDate,");
strSql.Append("checkUser=@checkUser,");
strSql.Append("checkUserId=@checkUserId,");
strSql.Append("auditstatus=@auditstatus,");
strSql.Append("auditUser=@auditUser,");
strSql.Append("auditUserId=@auditUserId,");
strSql.Append("remark=@remark,");
strSql.Append("isDelete=@isDelete,");
strSql.Append("createUser=@createUser,");
strSql.Append("createDate=@createDate,");
strSql.Append("updateUser=@updateUser,");
strSql.Append("updateDate=@updateDate");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@drugCode", SqlDbType.NVarChar, -1),
new SqlParameter("@drugName", SqlDbType.NVarChar, -1),
new SqlParameter("@drugId", SqlDbType.Int, 4),
new SqlParameter("@drugInId", SqlDbType.Int, 4),
new SqlParameter("@drugOutId", SqlDbType.Int, 4),
new SqlParameter("@outDate", SqlDbType.DateTime),
new SqlParameter("@unit", SqlDbType.NVarChar, -1),
new SqlParameter("@amountIN", SqlDbType.Int, 4),
new SqlParameter("@amountOUT", SqlDbType.Int, 4),
new SqlParameter("@amount", SqlDbType.Int, 4),
new SqlParameter("@riskLevel", SqlDbType.NVarChar, -1),
new SqlParameter("@checkDate", SqlDbType.DateTime),
new SqlParameter("@checkUser", SqlDbType.NVarChar, -1),
new SqlParameter("@checkUserId", SqlDbType.Int, 4),
new SqlParameter("@auditstatus", SqlDbType.NVarChar, -1),
new SqlParameter("@auditUser", SqlDbType.NVarChar, -1),
new SqlParameter("@auditUserId", SqlDbType.NVarChar, -1),
new SqlParameter("@remark", SqlDbType.NVarChar, -1),
new SqlParameter("@isDelete", SqlDbType.Bit, 1),
new SqlParameter("@createUser", SqlDbType.Int, 4),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@updateUser", SqlDbType.Int, 4),
new SqlParameter("@updateDate", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.drugCode;
parameters[1].Value = model.drugName;
parameters[2].Value = model.drugId;
parameters[3].Value = model.drugInId;
parameters[4].Value = model.drugOutId;
parameters[5].Value = model.outDate;
parameters[6].Value = model.unit;
parameters[7].Value = model.amountIN;
parameters[8].Value = model.amountOUT;
parameters[9].Value = model.amount;
parameters[10].Value = model.riskLevel;
parameters[11].Value = model.checkDate;
parameters[12].Value = model.checkUser;
parameters[13].Value = model.checkUserId;
parameters[14].Value = model.auditstatus;
parameters[15].Value = model.auditUser;
parameters[16].Value = model.auditUserId;
parameters[17].Value = model.remark;
parameters[18].Value = model.isDelete;
parameters[19].Value = model.createUser;
parameters[20].Value = model.createDate;
parameters[21].Value = model.updateUser;
parameters[22].Value = model.updateDate;
parameters[23].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除所有数据
/// </summary>
/// <returns></returns>
public int DelAllBorrow()
{
string sql = "TRUNCATE TABLE T_BORROW";
return(DbHelperSQL.ExecuteSql(sql));
}
/// <summary>
/// 根据ID删除信息
/// </summary>
/// <param name="Bo_TypeID">类型ID</param>
/// <returns>受影响行数</returns>
public int DelBorrow(string Bo_TypeID)
{
string sql = string.Format("delete from T_Borrow where Bo_TypeID={0}", Bo_TypeID);
return(DbHelperSQL.ExecuteSql(sql));
}
/// <summary>
/// 新增信息
/// </summary>
/// <param name="Bo_TypeName">类型名称</param>
/// <returns>受影响行数</returns>
public int InsBorrow(string Bo_TypeName)
{
string sql = string.Format("insert into T_Borrow values('{0}')", Bo_TypeName);
return(DbHelperSQL.ExecuteSql(sql));
}
