/// <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);
}
}
