/// <summary>
/// 增加一条数据
/// </summary>
public int Add(tb_document model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_document(");
strSql.Append("doc_Code,doc_Name,doc_Guid,direct_Id,doc_Type,doc_URL,doc_Size,doc_CreateUser,doc_UpdateUser,doc_CreateDate,doc_UpdateDate,isDelete,doc_Revo,doc_Source,doc_Path,temp1,temp2,remark,doc_Status,doc_KeyWord)");
strSql.Append(" values (");
strSql.Append("@doc_Code,@doc_Name,@doc_Guid,@direct_Id,@doc_Type,@doc_URL,@doc_Size,@doc_CreateUser,@doc_UpdateUser,@doc_CreateDate,@doc_UpdateDate,@isDelete,@doc_Revo,@doc_Source,@doc_Path,@temp1,@temp2,@remark,@doc_Status,@doc_KeyWord)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@doc_Code", SqlDbType.NVarChar, 100),
new SqlParameter("@doc_Name", SqlDbType.NVarChar, 100),
new SqlParameter("@doc_Guid", SqlDbType.VarChar, 100),
new SqlParameter("@direct_Id", SqlDbType.Int, 4),
new SqlParameter("@doc_Type", SqlDbType.VarChar, 10),
new SqlParameter("@doc_URL", SqlDbType.NVarChar, -1),
new SqlParameter("@doc_Size", SqlDbType.VarChar, 100),
new SqlParameter("@doc_CreateUser", SqlDbType.Int, 4),
new SqlParameter("@doc_UpdateUser", SqlDbType.Int, 4),
new SqlParameter("@doc_CreateDate", SqlDbType.DateTime),
new SqlParameter("@doc_UpdateDate", SqlDbType.DateTime),
new SqlParameter("@isDelete", SqlDbType.Bit, 1),
new SqlParameter("@doc_Revo", SqlDbType.VarChar, 100),
new SqlParameter("@doc_Source", SqlDbType.VarChar, 300),
new SqlParameter("@doc_Path", SqlDbType.NVarChar, -1),
new SqlParameter("@temp1", SqlDbType.NVarChar, 300),
new SqlParameter("@temp2", SqlDbType.NVarChar, 300),
new SqlParameter("@remark", SqlDbType.Text),
new SqlParameter("@doc_Status", SqlDbType.Int, 4),
new SqlParameter("@doc_KeyWord", SqlDbType.NVarChar, 100)
};
parameters[0].Value = model.doc_Code;
parameters[1].Value = model.doc_Name;
parameters[2].Value = model.doc_Guid;
parameters[3].Value = model.direct_Id;
parameters[4].Value = model.doc_Type;
parameters[5].Value = model.doc_URL;
parameters[6].Value = model.doc_Size;
parameters[7].Value = model.doc_CreateUser;
parameters[8].Value = model.doc_UpdateUser;
parameters[9].Value = model.doc_CreateDate;
parameters[10].Value = model.doc_UpdateDate;
parameters[11].Value = model.isDelete;
parameters[12].Value = model.doc_Revo;
parameters[13].Value = model.doc_Source;
parameters[14].Value = model.doc_Path;
parameters[15].Value = model.temp1;
parameters[16].Value = model.temp2;
parameters[17].Value = model.remark;
parameters[18].Value = model.doc_Status;
parameters[19].Value = model.doc_KeyWord;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public object ValidLimitTeacher(int classId)
{
return(DbHelperSQL.GetSingle("select LimitTeacherIds from ClassPlan where ClassId = @0", classId));
}
/// <summary>
/// 增加一条数据及其子表
/// </summary>
public int Add(Model.channel model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + databaseprefix + "channel(");
strSql.Append("category_id,name,title,is_albums,is_attach,is_group_price,page_size,sort_id)");
strSql.Append(" values (");
strSql.Append("@category_id,@name,@title,@is_albums,@is_attach,@is_group_price,@page_size,@sort_id)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@category_id", SqlDbType.Int, 4),
new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@title", SqlDbType.VarChar, 100),
new SqlParameter("@is_albums", SqlDbType.TinyInt, 1),
new SqlParameter("@is_attach", SqlDbType.TinyInt, 1),
new SqlParameter("@is_group_price", SqlDbType.TinyInt, 1),
new SqlParameter("@page_size", SqlDbType.Int, 4),
new SqlParameter("@sort_id", SqlDbType.Int, 4),
new SqlParameter("@ReturnValue", SqlDbType.Int)
};
parameters[0].Value = model.category_id;
parameters[1].Value = model.name;
parameters[2].Value = model.title;
parameters[3].Value = model.is_albums;
parameters[4].Value = model.is_attach;
parameters[5].Value = model.is_group_price;
parameters[6].Value = model.page_size;
parameters[7].Value = model.sort_id;
object obj = DbHelperSQL.GetSingle(conn, trans, strSql.ToString(), parameters); //带事务
model.id = Convert.ToInt32(obj);
//扩展字段
if (model.channel_fields != null)
{
StringBuilder strSql2;
foreach (Model.channel_field modelt in model.channel_fields)
{
strSql2 = new StringBuilder();
strSql2.Append("insert into " + databaseprefix + "channel_field(");
strSql2.Append("channel_id,field_id)");
strSql2.Append(" values (");
strSql2.Append("@channel_id,@field_id)");
SqlParameter[] parameters2 =
{
new SqlParameter("@channel_id", SqlDbType.Int, 4),
new SqlParameter("@field_id", SqlDbType.Int, 4)
};
parameters2[0].Value = model.id;
parameters2[1].Value = modelt.field_id;
DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2);
}
}
//添加视图
StringBuilder strSql3 = new StringBuilder();
strSql3.Append("CREATE VIEW view_channel_" + model.name + " as");
strSql3.Append(" SELECT " + databaseprefix + "article.*");
if (model.channel_fields != null)
{
foreach (Model.channel_field modelt in model.channel_fields)
{
Model.article_attribute_field fieldModel = new DAL.article_attribute_field(databaseprefix).GetModel(modelt.field_id);
if (fieldModel != null)
{
strSql3.Append("," + databaseprefix + "article_attribute_value." + fieldModel.name);
}
}
}
strSql3.Append(" FROM " + databaseprefix + "article_attribute_value INNER JOIN");
strSql3.Append(" " + databaseprefix + "article ON " + databaseprefix + "article_attribute_value.article_id = " + databaseprefix + "article.id");
strSql3.Append(" WHERE " + databaseprefix + "article.channel_id=" + model.id);
DbHelperSQL.ExecuteSql(conn, trans, strSql3.ToString());
trans.Commit();
}
catch
{
trans.Rollback();
return(0);
}
}
}
return(model.id);
}
/// <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;
}
}
public int GetRecordCount()
{
string sql = "select count(*) from Books";
return(Convert.ToInt32(DbHelperSQL.GetSingle(sql)));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Client model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Client(");
strSql.Append("Cli_Code,Cli_zhiwen,Cli_Name,Cli_PicName,Cli_Phone,Cli_PhoneTwo,Cli_faxes,Cli_CityCode,Cli_area,Cli_Address,Cli_LinkMan,Cli_Company,Cli_TypeCode,Cli_TypeName,Cli_DiscountCode,Cli_Bankaccounts,Cli_OpenBank,Cli_Olddata,Cli_Oldreturn,Cli_Newoutdata,Cli_Newintodata,Cli_Createdata,Cli_Limit,Cli_RemainLimit,Cli_ClearLimitdate,Cli_ShouldMoney,Cli_GetMoney,Cli_PreMoney,Cli_Remark,Cli_safetone,Cli_safettwo,Cli_Enable)");
strSql.Append(" values (");
strSql.Append("@Cli_Code,@Cli_zhiwen,@Cli_Name,@Cli_PicName,@Cli_Phone,@Cli_PhoneTwo,@Cli_faxes,@Cli_CityCode,@Cli_area,@Cli_Address,@Cli_LinkMan,@Cli_Company,@Cli_TypeCode,@Cli_TypeName,@Cli_DiscountCode,@Cli_Bankaccounts,@Cli_OpenBank,@Cli_Olddata,@Cli_Oldreturn,@Cli_Newoutdata,@Cli_Newintodata,@Cli_Createdata,@Cli_Limit,@Cli_RemainLimit,@Cli_ClearLimitdate,@Cli_ShouldMoney,@Cli_GetMoney,@Cli_PreMoney,@Cli_Remark,@Cli_safetone,@Cli_safettwo,@Cli_Enable)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Cli_Code", SqlDbType.NVarChar, 512),
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)
};
parameters[0].Value = model.Cli_Code;
parameters[1].Value = model.Cli_zhiwen;
parameters[2].Value = model.Cli_Name;
parameters[3].Value = model.Cli_PicName;
parameters[4].Value = model.Cli_Phone;
parameters[5].Value = model.Cli_PhoneTwo;
parameters[6].Value = model.Cli_faxes;
parameters[7].Value = model.Cli_CityCode;
parameters[8].Value = model.Cli_area;
parameters[9].Value = model.Cli_Address;
parameters[10].Value = model.Cli_LinkMan;
parameters[11].Value = model.Cli_Company;
parameters[12].Value = model.Cli_TypeCode;
parameters[13].Value = model.Cli_TypeName;
parameters[14].Value = model.Cli_DiscountCode;
parameters[15].Value = model.Cli_Bankaccounts;
parameters[16].Value = model.Cli_OpenBank;
parameters[17].Value = model.Cli_Olddata;
parameters[18].Value = model.Cli_Oldreturn;
parameters[19].Value = model.Cli_Newoutdata;
parameters[20].Value = model.Cli_Newintodata;
parameters[21].Value = model.Cli_Createdata;
parameters[22].Value = model.Cli_Limit;
parameters[23].Value = model.Cli_RemainLimit;
parameters[24].Value = model.Cli_ClearLimitdate;
parameters[25].Value = model.Cli_ShouldMoney;
parameters[26].Value = model.Cli_GetMoney;
parameters[27].Value = model.Cli_PreMoney;
parameters[28].Value = model.Cli_Remark;
parameters[29].Value = model.Cli_safetone;
parameters[30].Value = model.Cli_safettwo;
parameters[31].Value = model.Cli_Enable;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <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>
/// 增加一条数据
/// </summary>
public int Add(tb_Drug model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_Drug(");
strSql.Append("drugName,drugCode,drugType,unit,productDate,validDate,amount,manufacturers,cabinet,registrant,riskLevel,isMSDS,remark,createUser,createDate,updateUser,updateDate,temp1,temp2,un,dsm,purity)");
strSql.Append(" values (");
strSql.Append("@drugName,@drugCode,@drugType,@unit,@productDate,@validDate,@amount,@manufacturers,@cabinet,@registrant,@riskLevel,@isMSDS,@remark,@createUser,@createDate,@updateUser,@updateDate,@temp1,@temp2,@un,@dsm,@purity)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@drugName", SqlDbType.NVarChar, 200),
new SqlParameter("@drugCode", SqlDbType.VarChar, 300),
new SqlParameter("@drugType", SqlDbType.Int, 4),
new SqlParameter("@unit", SqlDbType.Int, 4),
new SqlParameter("@productDate", SqlDbType.DateTime),
new SqlParameter("@validDate", SqlDbType.DateTime),
new SqlParameter("@amount", SqlDbType.Decimal, 9),
new SqlParameter("@manufacturers", SqlDbType.NVarChar, 500),
new SqlParameter("@cabinet", SqlDbType.Int, 4),
new SqlParameter("@registrant", SqlDbType.Int, 4),
new SqlParameter("@riskLevel", SqlDbType.NVarChar, 50),
new SqlParameter("@isMSDS", SqlDbType.Bit, 1),
new SqlParameter("@remark", SqlDbType.NVarChar, -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("@temp1", SqlDbType.Text),
new SqlParameter("@temp2", SqlDbType.Text),
new SqlParameter("@un", SqlDbType.NVarChar, 50),
new SqlParameter("@dsm", SqlDbType.NVarChar, 50),
new SqlParameter("@purity", SqlDbType.Int, 4),
};
parameters[0].Value = model.drugName;
parameters[1].Value = model.drugCode;
parameters[2].Value = model.drugType;
parameters[3].Value = model.unit;
parameters[4].Value = model.productDate;
parameters[5].Value = model.validDate;
parameters[6].Value = model.amount;
parameters[7].Value = model.manufacturers;
parameters[8].Value = model.cabinet;
parameters[9].Value = model.registrant;
parameters[10].Value = model.riskLevel;
parameters[11].Value = model.isMSDS;
parameters[12].Value = model.remark;
parameters[13].Value = model.createUser;
parameters[14].Value = model.createDate;
parameters[15].Value = model.updateUser;
parameters[16].Value = model.updateDate;
parameters[17].Value = model.temp1;
parameters[18].Value = model.temp2;
parameters[19].Value = model.un;
parameters[20].Value = model.dsm;
parameters[21].Value = model.purity;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.navigation model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + databaseprefix + "navigation(");
strSql.Append("nav_type,name,title,sub_title,link_url,sort_id,is_lock,remark,parent_id,class_list,class_layer,channel_id,action_type,is_sys)");
strSql.Append(" values (");
strSql.Append("@nav_type,@name,@title,@sub_title,@link_url,@sort_id,@is_lock,@remark,@parent_id,@class_list,@class_layer,@channel_id,@action_type,@is_sys)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@nav_type", SqlDbType.NVarChar, 50),
new SqlParameter("@name", SqlDbType.NVarChar, 50),
new SqlParameter("@title", SqlDbType.NVarChar, 100),
new SqlParameter("@sub_title", SqlDbType.NVarChar, 100),
new SqlParameter("@link_url", SqlDbType.NVarChar, 255),
new SqlParameter("@sort_id", SqlDbType.Int, 4),
new SqlParameter("@is_lock", SqlDbType.TinyInt, 1),
new SqlParameter("@remark", SqlDbType.NVarChar, 500),
new SqlParameter("@parent_id", SqlDbType.Int, 4),
new SqlParameter("@class_list", SqlDbType.NVarChar, 500),
new SqlParameter("@class_layer", SqlDbType.Int, 4),
new SqlParameter("@channel_id", SqlDbType.Int, 4),
new SqlParameter("@action_type", SqlDbType.NVarChar, 500),
new SqlParameter("@is_sys", SqlDbType.TinyInt, 1)
};
parameters[0].Value = model.nav_type;
parameters[1].Value = model.name;
parameters[2].Value = model.title;
parameters[3].Value = model.sub_title;
parameters[4].Value = model.link_url;
parameters[5].Value = model.sort_id;
parameters[6].Value = model.is_lock;
parameters[7].Value = model.remark;
parameters[8].Value = model.parent_id;
parameters[9].Value = model.class_list;
parameters[10].Value = model.class_layer;
parameters[11].Value = model.channel_id;
parameters[12].Value = model.action_type;
parameters[13].Value = model.is_sys;
object obj = DbHelperSQL.GetSingle(conn, trans, strSql.ToString(), parameters); //带事务
model.id = Convert.ToInt32(obj); //得到刚插入的新ID
if (model.parent_id > 0)
{
Model.navigation model2 = GetModel(conn, trans, model.parent_id); //带事务
model.class_list = model2.class_list + model.id + ",";
model.class_layer = model2.class_layer + 1;
}
else
{
model.class_list = "," + model.id + ",";
model.class_layer = 1;
}
//修改节点列表和深度
DbHelperSQL.ExecuteSql(conn, trans, "update " + databaseprefix + "navigation set class_list='" + model.class_list + "', class_layer=" + model.class_layer + " where id=" + model.id); //带事务
//如无异常则提交事务
trans.Commit();
}
catch
{
trans.Rollback();
return(0);
}
}
}
return(model.id);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(tb_DrugCheck model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_DrugCheck(");
strSql.Append("drugCode,drugName,drugId,drugInId,drugOutId,outDate,unit,amountIN,amountOUT,amount,riskLevel,checkDate,checkUser,checkUserId,auditstatus,auditUser,auditUserId,remark,isDelete,createUser,createDate,updateUser,updateDate)");
strSql.Append(" values (");
strSql.Append("@drugCode,@drugName,@drugId,@drugInId,@drugOutId,@outDate,@unit,@amountIN,@amountOUT,@amount,@riskLevel,@checkDate,@checkUser,@checkUserId,@auditstatus,@auditUser,@auditUserId,@remark,@isDelete,@createUser,@createDate,@updateUser,@updateDate)");
strSql.Append(";select @@IDENTITY");
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)
};
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;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}