/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.public_notice model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into public_notice(");
strSql.Append("notice_title,notice_content,create_id,create_name,dep_id,dep_name,notice_time)");
strSql.Append(" values (");
strSql.Append("@notice_title,@notice_content,@create_id,@create_name,@dep_id,@dep_name,@notice_time)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@notice_title", SqlDbType.VarChar,250),
new SqlParameter("@notice_content", SqlDbType.VarChar),
new SqlParameter("@create_id", SqlDbType.Int,4),
new SqlParameter("@create_name", SqlDbType.VarChar,250),
new SqlParameter("@dep_id", SqlDbType.Int,4),
new SqlParameter("@dep_name", SqlDbType.VarChar,250),
new SqlParameter("@notice_time", SqlDbType.DateTime)};
parameters[0].Value = model.notice_title;
parameters[1].Value = model.notice_content;
parameters[2].Value = model.create_id;
parameters[3].Value = model.create_name;
parameters[4].Value = model.dep_id;
parameters[5].Value = model.dep_name;
parameters[6].Value = model.notice_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.CRM_product_category model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CRM_product_category(");
strSql.Append("product_category,parentid,product_icon,isDelete,Delete_id,Delete_time)");
strSql.Append(" values (");
strSql.Append("@product_category,@parentid,@product_icon,@isDelete,@Delete_id,@Delete_time)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@product_category", SqlDbType.VarChar,250),
new SqlParameter("@parentid", SqlDbType.Int,4),
new SqlParameter("@product_icon", SqlDbType.VarChar,250),
new SqlParameter("@isDelete", SqlDbType.Int,4),
new SqlParameter("@Delete_id", SqlDbType.Int,4),
new SqlParameter("@Delete_time", SqlDbType.DateTime)};
parameters[0].Value = model.product_category;
parameters[1].Value = model.parentid;
parameters[2].Value = model.product_icon;
parameters[3].Value = model.isDelete;
parameters[4].Value = model.Delete_id;
parameters[5].Value = model.Delete_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.Sys_Button model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Sys_Button(");
strSql.Append("Btn_name,Btn_icon,Btn_handler,Menu_id,Menu_name,Btn_order)");
strSql.Append(" values (");
strSql.Append("@Btn_name,@Btn_icon,@Btn_handler,@Menu_id,@Menu_name,@Btn_order)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Btn_name", SqlDbType.VarChar,255),
new SqlParameter("@Btn_icon", SqlDbType.VarChar,50),
new SqlParameter("@Btn_handler", SqlDbType.VarChar,255),
new SqlParameter("@Menu_id", SqlDbType.Int,4),
new SqlParameter("@Menu_name", SqlDbType.VarChar,255),
new SqlParameter("@Btn_order", SqlDbType.VarChar,50)};
parameters[0].Value = model.Btn_name;
parameters[1].Value = model.Btn_icon;
parameters[2].Value = model.Btn_handler;
parameters[3].Value = model.Menu_id;
parameters[4].Value = model.Menu_name;
parameters[5].Value = model.Btn_order;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(XHD.Model.CRM_order_details model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CRM_order_details(");
strSql.Append("order_id,product_id,product_name,price,base_price,quantity,unit,amount,pway)");
strSql.Append(" values (");
strSql.Append("@order_id,@product_id,@product_name,@price,@base_price,@quantity,@unit,@amount,@pway)");
SqlParameter[] parameters = {
new SqlParameter("@order_id", SqlDbType.Int,4),
new SqlParameter("@product_id", SqlDbType.Int,4),
new SqlParameter("@product_name", SqlDbType.VarChar,250),
new SqlParameter("@price", SqlDbType.Float,8),
new SqlParameter("@base_price", SqlDbType.Float,8),
new SqlParameter("@quantity", SqlDbType.Int,4),
new SqlParameter("@unit", SqlDbType.VarChar,250),
new SqlParameter("@amount", SqlDbType.Float,8),
new SqlParameter("@pway", SqlDbType.VarChar,250)};
parameters[0].Value = model.order_id;
parameters[1].Value = model.product_id;
parameters[2].Value = model.product_name;
parameters[3].Value = model.price;
parameters[4].Value = model.base_price;
parameters[5].Value = model.quantity;
parameters[6].Value = model.unit;
parameters[7].Value = model.amount;
parameters[8].Value = model.pway;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.hr_position model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into hr_position(");
strSql.Append("position_name,position_order,position_level,create_id,create_date,isDelete,Delete_time)");
strSql.Append(" values (");
strSql.Append("@position_name,@position_order,@position_level,@create_id,@create_date,@isDelete,@Delete_time)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@position_name", SqlDbType.VarChar,250),
new SqlParameter("@position_order", SqlDbType.VarChar,50),
new SqlParameter("@position_level", SqlDbType.VarChar,50),
new SqlParameter("@create_id", SqlDbType.Int,4),
new SqlParameter("@create_date", SqlDbType.DateTime),
new SqlParameter("@isDelete", SqlDbType.Int,4),
new SqlParameter("@Delete_time", SqlDbType.DateTime)};
parameters[0].Value = model.position_name;
parameters[1].Value = model.position_order;
parameters[2].Value = model.position_level;
parameters[3].Value = model.create_id;
parameters[4].Value = model.create_date;
parameters[5].Value = model.isDelete;
parameters[6].Value = model.Delete_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.Param_City model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Param_City(");
strSql.Append("parentid,City,Create_id,Create_date,Update_id,Update_date)");
strSql.Append(" values (");
strSql.Append("@parentid,@City,@Create_id,@Create_date,@Update_id,@Update_date)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@parentid", SqlDbType.Int,4),
new SqlParameter("@City", SqlDbType.VarChar,250),
new SqlParameter("@Create_id", SqlDbType.Int,4),
new SqlParameter("@Create_date", SqlDbType.DateTime),
new SqlParameter("@Update_id", SqlDbType.Int,4),
new SqlParameter("@Update_date", SqlDbType.DateTime)};
parameters[0].Value = model.parentid;
parameters[1].Value = model.City;
parameters[2].Value = model.Create_id;
parameters[3].Value = model.Create_date;
parameters[4].Value = model.Update_id;
parameters[5].Value = model.Update_date;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(XHD.Model.Sys_data_authority model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Sys_data_authority(");
strSql.Append("Role_id,option_id,Sys_option,Sys_view,Sys_add,Sys_edit,Sys_del,Create_id,Create_date)");
strSql.Append(" values (");
strSql.Append("@Role_id,@option_id,@Sys_option,@Sys_view,@Sys_add,@Sys_edit,@Sys_del,@Create_id,@Create_date)");
SqlParameter[] parameters = {
new SqlParameter("@Role_id", SqlDbType.Int,4),
new SqlParameter("@option_id", SqlDbType.Int,4),
new SqlParameter("@Sys_option", SqlDbType.VarChar,250),
new SqlParameter("@Sys_view", SqlDbType.Int,4),
new SqlParameter("@Sys_add", SqlDbType.Int,4),
new SqlParameter("@Sys_edit", SqlDbType.Int,4),
new SqlParameter("@Sys_del", SqlDbType.Int,4),
new SqlParameter("@Create_id", SqlDbType.Int,4),
new SqlParameter("@Create_date", SqlDbType.DateTime)};
parameters[0].Value = model.Role_id;
parameters[1].Value = model.option_id;
parameters[2].Value = model.Sys_option;
parameters[3].Value = model.Sys_view;
parameters[4].Value = model.Sys_add;
parameters[5].Value = model.Sys_edit;
parameters[6].Value = model.Sys_del;
parameters[7].Value = model.Create_id;
parameters[8].Value = model.Create_date;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.Sys_role model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Sys_role(");
strSql.Append("RoleName,RoleDscript,RoleSort,CreateID,CreateDate,UpdateID,UpdateDate)");
strSql.Append(" values (");
strSql.Append("@RoleName,@RoleDscript,@RoleSort,@CreateID,@CreateDate,@UpdateID,@UpdateDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@RoleName", SqlDbType.VarChar,255),
new SqlParameter("@RoleDscript", SqlDbType.VarChar,255),
new SqlParameter("@RoleSort", SqlDbType.NChar,10),
new SqlParameter("@CreateID", SqlDbType.Int,4),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@UpdateID", SqlDbType.Int,4),
new SqlParameter("@UpdateDate", SqlDbType.DateTime)};
parameters[0].Value = model.RoleName;
parameters[1].Value = model.RoleDscript;
parameters[2].Value = model.RoleSort;
parameters[3].Value = model.CreateID;
parameters[4].Value = model.CreateDate;
parameters[5].Value = model.UpdateID;
parameters[6].Value = model.UpdateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.Personal_notes model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Personal_notes(");
strSql.Append("emp_id,emp_name,note_content,note_color,xyz,note_time)");
strSql.Append(" values (");
strSql.Append("@emp_id,@emp_name,@note_content,@note_color,@xyz,@note_time)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@emp_id", SqlDbType.Int,4),
new SqlParameter("@emp_name", SqlDbType.VarChar,250),
new SqlParameter("@note_content", SqlDbType.VarChar,-1),
new SqlParameter("@note_color", SqlDbType.VarChar,250),
new SqlParameter("@xyz", SqlDbType.VarChar,250),
new SqlParameter("@note_time", SqlDbType.DateTime)};
parameters[0].Value = model.emp_id;
parameters[1].Value = model.emp_name;
parameters[2].Value = model.note_content;
parameters[3].Value = model.note_color;
parameters[4].Value = model.xyz;
parameters[5].Value = model.note_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(XHD.Model.mail_attachment model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into mail_attachment(");
strSql.Append("mail_id,page_id,file_id,file_name,real_name,create_id,create_name,create_date)");
strSql.Append(" values (");
strSql.Append("@mail_id,@page_id,@file_id,@file_name,@real_name,@create_id,@create_name,@create_date)");
SqlParameter[] parameters = {
new SqlParameter("@mail_id", SqlDbType.Int,4),
new SqlParameter("@page_id", SqlDbType.VarChar,250),
new SqlParameter("@file_id", SqlDbType.VarChar,250),
new SqlParameter("@file_name", SqlDbType.VarChar,250),
new SqlParameter("@real_name", SqlDbType.VarChar,250),
new SqlParameter("@create_id", SqlDbType.Int,4),
new SqlParameter("@create_name", SqlDbType.VarChar,250),
new SqlParameter("@create_date", SqlDbType.DateTime)};
parameters[0].Value = model.mail_id;
parameters[1].Value = model.page_id;
parameters[2].Value = model.file_id;
parameters[3].Value = model.file_name;
parameters[4].Value = model.real_name;
parameters[5].Value = model.create_id;
parameters[6].Value = model.create_name;
parameters[7].Value = model.create_date;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.Sys_App model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Sys_App(");
strSql.Append("App_name,App_order,App_url,App_handler,App_type,App_icon)");
strSql.Append(" values (");
strSql.Append("@App_name,@App_order,@App_url,@App_handler,@App_type,@App_icon)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@App_name", SqlDbType.VarChar,100),
new SqlParameter("@App_order", SqlDbType.Int,4),
new SqlParameter("@App_url", SqlDbType.VarChar,250),
new SqlParameter("@App_handler", SqlDbType.VarChar,250),
new SqlParameter("@App_type", SqlDbType.VarChar,50),
new SqlParameter("@App_icon", SqlDbType.VarChar,250)};
parameters[0].Value = model.App_name;
parameters[1].Value = model.App_order;
parameters[2].Value = model.App_url;
parameters[3].Value = model.App_handler;
parameters[4].Value = model.App_type;
parameters[5].Value = model.App_icon;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.CRM_Contact model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CRM_Contact(");
strSql.Append("C_name,C_sex,C_department,C_position,C_birthday,C_tel,C_fax,C_email,C_mob,C_QQ,C_add,C_hobby,C_remarks,C_customerid,C_customername,C_createId,C_createDate,isDelete,Delete_time)");
strSql.Append(" values (");
strSql.Append("@C_name,@C_sex,@C_department,@C_position,@C_birthday,@C_tel,@C_fax,@C_email,@C_mob,@C_QQ,@C_add,@C_hobby,@C_remarks,@C_customerid,@C_customername,@C_createId,@C_createDate,@isDelete,@Delete_time)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@C_name", SqlDbType.VarChar,250),
new SqlParameter("@C_sex", SqlDbType.VarChar,250),
new SqlParameter("@C_department", SqlDbType.VarChar,250),
new SqlParameter("@C_position", SqlDbType.VarChar,250),
new SqlParameter("@C_birthday", SqlDbType.VarChar,250),
new SqlParameter("@C_tel", SqlDbType.VarChar,250),
new SqlParameter("@C_fax", SqlDbType.VarChar,250),
new SqlParameter("@C_email", SqlDbType.VarChar,250),
new SqlParameter("@C_mob", SqlDbType.VarChar,250),
new SqlParameter("@C_QQ", SqlDbType.VarChar,250),
new SqlParameter("@C_add", SqlDbType.VarChar,250),
new SqlParameter("@C_hobby", SqlDbType.VarChar,250),
new SqlParameter("@C_remarks", SqlDbType.VarChar),
new SqlParameter("@C_customerid", SqlDbType.Int,4),
new SqlParameter("@C_customername", SqlDbType.VarChar,250),
new SqlParameter("@C_createId", SqlDbType.Int,4),
new SqlParameter("@C_createDate", SqlDbType.DateTime),
new SqlParameter("@isDelete", SqlDbType.Int,4),
new SqlParameter("@Delete_time", SqlDbType.DateTime)};
parameters[0].Value = model.C_name;
parameters[1].Value = model.C_sex;
parameters[2].Value = model.C_department;
parameters[3].Value = model.C_position;
parameters[4].Value = model.C_birthday;
parameters[5].Value = model.C_tel;
parameters[6].Value = model.C_fax;
parameters[7].Value = model.C_email;
parameters[8].Value = model.C_mob;
parameters[9].Value = model.C_QQ;
parameters[10].Value = model.C_add;
parameters[11].Value = model.C_hobby;
parameters[12].Value = model.C_remarks;
parameters[13].Value = model.C_customerid;
parameters[14].Value = model.C_customername;
parameters[15].Value = model.C_createId;
parameters[16].Value = model.C_createDate;
parameters[17].Value = model.isDelete;
parameters[18].Value = model.Delete_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.CRM_invoice model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CRM_invoice(");
strSql.Append("Customer_id,Customer_name,invoice_num,invoice_type_id,invoice_type,invoice_amount,invoice_content,invoice_date,C_depid,C_depname,C_empid,C_empname,create_id,create_name,create_date,order_id,isDelete,Delete_time)");
strSql.Append(" values (");
strSql.Append("@Customer_id,@Customer_name,@invoice_num,@invoice_type_id,@invoice_type,@invoice_amount,@invoice_content,@invoice_date,@C_depid,@C_depname,@C_empid,@C_empname,@create_id,@create_name,@create_date,@order_id,@isDelete,@Delete_time)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Customer_id", SqlDbType.Int,4),
new SqlParameter("@Customer_name", SqlDbType.VarChar,250),
new SqlParameter("@invoice_num", SqlDbType.VarChar,250),
new SqlParameter("@invoice_type_id", SqlDbType.Int,4),
new SqlParameter("@invoice_type", SqlDbType.VarChar,250),
new SqlParameter("@invoice_amount", SqlDbType.Float,8),
new SqlParameter("@invoice_content", SqlDbType.VarChar),
new SqlParameter("@invoice_date", SqlDbType.DateTime),
new SqlParameter("@C_depid", SqlDbType.Int,4),
new SqlParameter("@C_depname", SqlDbType.VarChar,250),
new SqlParameter("@C_empid", SqlDbType.Int,4),
new SqlParameter("@C_empname", SqlDbType.VarChar,250),
new SqlParameter("@create_id", SqlDbType.Int,4),
new SqlParameter("@create_name", SqlDbType.VarChar,250),
new SqlParameter("@create_date", SqlDbType.DateTime),
new SqlParameter("@order_id", SqlDbType.Int,4),
new SqlParameter("@isDelete", SqlDbType.Int,4),
new SqlParameter("@Delete_time", SqlDbType.DateTime)};
parameters[0].Value = model.Customer_id;
parameters[1].Value = model.Customer_name;
parameters[2].Value = model.invoice_num;
parameters[3].Value = model.invoice_type_id;
parameters[4].Value = model.invoice_type;
parameters[5].Value = model.invoice_amount;
parameters[6].Value = model.invoice_content;
parameters[7].Value = model.invoice_date;
parameters[8].Value = model.C_depid;
parameters[9].Value = model.C_depname;
parameters[10].Value = model.C_empid;
parameters[11].Value = model.C_empname;
parameters[12].Value = model.create_id;
parameters[13].Value = model.create_name;
parameters[14].Value = model.create_date;
parameters[15].Value = model.order_id;
parameters[16].Value = model.isDelete;
parameters[17].Value = model.Delete_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(XHD.Model.Sys_role_emp model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Sys_role_emp(");
strSql.Append("RoleID,empID)");
strSql.Append(" values (");
strSql.Append("@RoleID,@empID)");
SqlParameter[] parameters = {
new SqlParameter("@RoleID", SqlDbType.Int,4),
new SqlParameter("@empID", SqlDbType.Int,4)};
parameters[0].Value = model.RoleID;
parameters[1].Value = model.empID;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.hr_department model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into hr_department(");
strSql.Append("d_name,parentid,parentname,d_type,d_icon,d_fuzeren,d_tel,d_fax,d_add,d_email,d_miaoshu,d_order,isDelete,Delete_time)");
strSql.Append(" values (");
strSql.Append("@d_name,@parentid,@parentname,@d_type,@d_icon,@d_fuzeren,@d_tel,@d_fax,@d_add,@d_email,@d_miaoshu,@d_order,@isDelete,@Delete_time)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@d_name", SqlDbType.VarChar,50),
new SqlParameter("@parentid", SqlDbType.Int,4),
new SqlParameter("@parentname", SqlDbType.VarChar,50),
new SqlParameter("@d_type", SqlDbType.VarChar,50),
new SqlParameter("@d_icon", SqlDbType.VarChar,50),
new SqlParameter("@d_fuzeren", SqlDbType.VarChar,50),
new SqlParameter("@d_tel", SqlDbType.VarChar,50),
new SqlParameter("@d_fax", SqlDbType.VarChar,50),
new SqlParameter("@d_add", SqlDbType.VarChar,255),
new SqlParameter("@d_email", SqlDbType.VarChar,50),
new SqlParameter("@d_miaoshu", SqlDbType.VarChar,255),
new SqlParameter("@d_order", SqlDbType.VarChar,50),
new SqlParameter("@isDelete", SqlDbType.Int,4),
new SqlParameter("@Delete_time", SqlDbType.DateTime)};
parameters[0].Value = model.d_name;
parameters[1].Value = model.parentid;
parameters[2].Value = model.parentname;
parameters[3].Value = model.d_type;
parameters[4].Value = model.d_icon;
parameters[5].Value = model.d_fuzeren;
parameters[6].Value = model.d_tel;
parameters[7].Value = model.d_fax;
parameters[8].Value = model.d_add;
parameters[9].Value = model.d_email;
parameters[10].Value = model.d_miaoshu;
parameters[11].Value = model.d_order;
parameters[12].Value = model.isDelete;
parameters[13].Value = model.Delete_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.mail_flow model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into mail_flow(");
strSql.Append("mail_id,mail_title,atta_count,receive_id,receive_name,isView,view_time,recive_type_id,recive_type,sender_id,sender_name,sender_time,isDelete,Delete_time)");
strSql.Append(" values (");
strSql.Append("@mail_id,@mail_title,@atta_count,@receive_id,@receive_name,@isView,@view_time,@recive_type_id,@recive_type,@sender_id,@sender_name,@sender_time,@isDelete,@Delete_time)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@mail_id", SqlDbType.Int,4),
new SqlParameter("@mail_title", SqlDbType.VarChar,250),
new SqlParameter("@atta_count", SqlDbType.Int,4),
new SqlParameter("@receive_id", SqlDbType.Int,4),
new SqlParameter("@receive_name", SqlDbType.VarChar,250),
new SqlParameter("@isView", SqlDbType.Int,4),
new SqlParameter("@view_time", SqlDbType.DateTime),
new SqlParameter("@recive_type_id", SqlDbType.Int,4),
new SqlParameter("@recive_type", SqlDbType.VarChar,250),
new SqlParameter("@sender_id", SqlDbType.Int,4),
new SqlParameter("@sender_name", SqlDbType.VarChar,250),
new SqlParameter("@sender_time", SqlDbType.DateTime),
new SqlParameter("@isDelete", SqlDbType.Int,4),
new SqlParameter("@Delete_time", SqlDbType.DateTime)};
parameters[0].Value = model.mail_id;
parameters[1].Value = model.mail_title;
parameters[2].Value = model.atta_count;
parameters[3].Value = model.receive_id;
parameters[4].Value = model.receive_name;
parameters[5].Value = model.isView;
parameters[6].Value = model.view_time;
parameters[7].Value = model.recive_type_id;
parameters[8].Value = model.recive_type;
parameters[9].Value = model.sender_id;
parameters[10].Value = model.sender_name;
parameters[11].Value = model.sender_time;
parameters[12].Value = model.isDelete;
parameters[13].Value = model.Delete_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(XHD.Model.Ext_Task model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Ext_Task(");
strSql.Append("Serialnumber,SiteName,Url,DesCripe,Department_id,Department,Employee_id,Employee,Create_id,Create_name,Create_date,isDelete,Delete_time)");
strSql.Append(" values (");
strSql.Append("@Serialnumber,@SiteName,@Url,@DesCripe,@Department_id,@Department,@Employee_id,@Employee,@Create_id,@Create_name,@Create_date,@isDelete,@Delete_time)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Serialnumber", SqlDbType.VarChar,250),
new SqlParameter("@SiteName", SqlDbType.VarChar,250),
new SqlParameter("@Url", SqlDbType.VarChar,250),
new SqlParameter("@DesCripe", SqlDbType.VarChar,4000),
new SqlParameter("@Department_id", SqlDbType.Int,4),
new SqlParameter("@Department", SqlDbType.VarChar,250),
new SqlParameter("@Employee_id", SqlDbType.Int,4),
new SqlParameter("@Employee", SqlDbType.VarChar,250),
new SqlParameter("@Create_id", SqlDbType.Int,4),
new SqlParameter("@Create_name", SqlDbType.VarChar,250),
new SqlParameter("@Create_date", SqlDbType.DateTime),
new SqlParameter("@isDelete", SqlDbType.Int,4),
new SqlParameter("@Delete_time", SqlDbType.DateTime)
};
parameters[0].Value = model.Serialnumber;
parameters[1].Value = model.SiteName;
parameters[2].Value = model.Url;
parameters[3].Value = model.DesCripe;
parameters[4].Value = model.Department_id;
parameters[5].Value = model.Department;
parameters[6].Value = model.Employee_id;
parameters[7].Value = model.Employee;
parameters[8].Value = model.Create_id;
parameters[9].Value = model.Create_name;
parameters[10].Value = model.Create_date;
parameters[11].Value = model.isDelete;
parameters[12].Value = model.Delete_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.hr_post model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into hr_post(");
strSql.Append("post_name,position_id,position_name,position_order,dep_id,depname,emp_id,emp_name,default_post,note,post_descript,isDelete,Delete_time)");
strSql.Append(" values (");
strSql.Append("@post_name,@position_id,@position_name,@position_order,@dep_id,@depname,@emp_id,@emp_name,@default_post,@note,@post_descript,@isDelete,@Delete_time)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@post_name", SqlDbType.VarChar,255),
new SqlParameter("@position_id", SqlDbType.Int,4),
new SqlParameter("@position_name", SqlDbType.VarChar,255),
new SqlParameter("@position_order", SqlDbType.VarChar,50),
new SqlParameter("@dep_id", SqlDbType.Int,4),
new SqlParameter("@depname", SqlDbType.VarChar,255),
new SqlParameter("@emp_id", SqlDbType.Int,4),
new SqlParameter("@emp_name", SqlDbType.VarChar,255),
new SqlParameter("@default_post", SqlDbType.Int,4),
new SqlParameter("@note", SqlDbType.VarChar),
new SqlParameter("@post_descript", SqlDbType.VarChar),
new SqlParameter("@isDelete", SqlDbType.Int,4),
new SqlParameter("@Delete_time", SqlDbType.DateTime)};
parameters[0].Value = model.post_name;
parameters[1].Value = model.position_id;
parameters[2].Value = model.position_name;
parameters[3].Value = model.position_order;
parameters[4].Value = model.dep_id;
parameters[5].Value = model.depname;
parameters[6].Value = model.emp_id;
parameters[7].Value = model.emp_name;
parameters[8].Value = model.default_post;
parameters[9].Value = model.note;
parameters[10].Value = model.post_descript;
parameters[11].Value = model.isDelete;
parameters[12].Value = model.Delete_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(XHD.Model.Sys_online model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Sys_online(");
strSql.Append("UserID,UserName,LastLogTime)");
strSql.Append(" values (");
strSql.Append("@UserID,@UserName,@LastLogTime)");
SqlParameter[] parameters = {
new SqlParameter("@UserID", SqlDbType.Int,4),
new SqlParameter("@UserName", SqlDbType.VarChar,50),
new SqlParameter("@LastLogTime", SqlDbType.DateTime)};
parameters[0].Value = model.UserID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.LastLogTime;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.CRM_Follow model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CRM_Follow(");
strSql.Append("Customer_id,Customer_name,Follow,Follow_date,Follow_Type_id,Follow_Type,department_id,department_name,employee_id,employee_name,isDelete,Delete_time)");
strSql.Append(" values (");
strSql.Append("@Customer_id,@Customer_name,@Follow,@Follow_date,@Follow_Type_id,@Follow_Type,@department_id,@department_name,@employee_id,@employee_name,@isDelete,@Delete_time)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Customer_id", SqlDbType.Int,4),
new SqlParameter("@Customer_name", SqlDbType.VarChar,250),
new SqlParameter("@Follow", SqlDbType.VarChar,4000),
new SqlParameter("@Follow_date", SqlDbType.DateTime),
new SqlParameter("@Follow_Type_id", SqlDbType.Int,4),
new SqlParameter("@Follow_Type", SqlDbType.VarChar,250),
new SqlParameter("@department_id", SqlDbType.Int,4),
new SqlParameter("@department_name", SqlDbType.VarChar,250),
new SqlParameter("@employee_id", SqlDbType.Int,4),
new SqlParameter("@employee_name", SqlDbType.VarChar,250),
new SqlParameter("@isDelete", SqlDbType.Int,4),
new SqlParameter("@Delete_time", SqlDbType.DateTime)};
parameters[0].Value = model.Customer_id;
parameters[1].Value = model.Customer_name;
parameters[2].Value = model.Follow;
parameters[3].Value = model.Follow_date;
parameters[4].Value = model.Follow_Type_id;
parameters[5].Value = model.Follow_Type;
parameters[6].Value = model.department_id;
parameters[7].Value = model.department_name;
parameters[8].Value = model.employee_id;
parameters[9].Value = model.employee_name;
parameters[10].Value = model.isDelete;
parameters[11].Value = model.Delete_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.CRM_product model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CRM_product(");
strSql.Append("product_name,category_id,category_name,specifications,status,unit,remarks,price,base_price,isDelete,Delete_time,pway_content)");
strSql.Append(" values (");
strSql.Append("@product_name,@category_id,@category_name,@specifications,@status,@unit,@remarks,@price,@base_price,@isDelete,@Delete_time,@pway_content)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@product_name", SqlDbType.VarChar,250),
new SqlParameter("@category_id", SqlDbType.Int,4),
new SqlParameter("@category_name", SqlDbType.VarChar,250),
new SqlParameter("@specifications", SqlDbType.VarChar,250),
new SqlParameter("@status", SqlDbType.VarChar,250),
new SqlParameter("@unit", SqlDbType.VarChar,250),
new SqlParameter("@remarks", SqlDbType.VarChar),
new SqlParameter("@price", SqlDbType.Float,8),
new SqlParameter("@base_price", SqlDbType.Float,8),
new SqlParameter("@isDelete", SqlDbType.Int,4),
new SqlParameter("@Delete_time", SqlDbType.DateTime),
new SqlParameter("@pway_content",SqlDbType.VarChar,250)};
parameters[0].Value = model.product_name;
parameters[1].Value = model.category_id;
parameters[2].Value = model.category_name;
parameters[3].Value = model.specifications;
parameters[4].Value = model.status;
parameters[5].Value = model.unit;
parameters[6].Value = model.remarks;
parameters[7].Value = model.price;
parameters[8].Value = model.base_price;
parameters[9].Value = model.isDelete;
parameters[10].Value = model.Delete_time;
parameters[11].Value = model.pway_content;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(XHD.Model.Param_Site model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Param_Site(");
strSql.Append("parentid,Site,SiteUrl,Department_id,Department,Employee_id,Employee,Create_id,Create_date,Update_id,Update_date)");
strSql.Append(" values (");
strSql.Append("@parentid,@Site,@SiteUrl,@Department_id,@Department,@Employee_id,@Employee,@Create_id,@Create_date,@Update_id,@Update_date)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@parentid", SqlDbType.Int,4),
new SqlParameter("@Site", SqlDbType.VarChar,250),
new SqlParameter("@SiteUrl", SqlDbType.VarChar,250),
new SqlParameter("@Department_id", SqlDbType.Int,4),
new SqlParameter("@Department", SqlDbType.VarChar,250),
new SqlParameter("@Employee_id", SqlDbType.Int,4),
new SqlParameter("@Employee", SqlDbType.VarChar,250),
new SqlParameter("@Create_id", SqlDbType.Int,4),
new SqlParameter("@Create_date", SqlDbType.DateTime),
new SqlParameter("@Update_id", SqlDbType.Int,4),
new SqlParameter("@Update_date", SqlDbType.DateTime)};
parameters[0].Value = model.parentid;
parameters[1].Value = model.Site;
parameters[2].Value = model.SiteUrl;
parameters[3].Value = model.Department_id;
parameters[4].Value = model.Department;
parameters[5].Value = model.Employee_id;
parameters[6].Value = model.Employee;
parameters[7].Value = model.Create_id;
parameters[8].Value = model.Create_date;
parameters[9].Value = model.Update_id;
parameters[10].Value = model.Update_date;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(XHD.Model.Param_SysParam_Type model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Param_SysParam_Type(");
strSql.Append("id,params_name,params_order,isDelete,Delete_time)");
strSql.Append(" values (");
strSql.Append("@id,@params_name,@params_order,@isDelete,@Delete_time)");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4),
new SqlParameter("@params_name", SqlDbType.VarChar,250),
new SqlParameter("@params_order", SqlDbType.VarChar,50),
new SqlParameter("@isDelete", SqlDbType.Int,4),
new SqlParameter("@Delete_time", SqlDbType.DateTime)};
parameters[0].Value = model.id;
parameters[1].Value = model.params_name;
parameters[2].Value = model.params_order;
parameters[3].Value = model.isDelete;
parameters[4].Value = model.Delete_time;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.Sys_log_Err model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Sys_log_Err(");
strSql.Append("Err_typeid,Err_type,Err_time,Err_url,Err_message,Err_source,Err_trace,Err_emp_id,Err_emp_name,Err_ip)");
strSql.Append(" values (");
strSql.Append("@Err_typeid,@Err_type,@Err_time,@Err_url,@Err_message,@Err_source,@Err_trace,@Err_emp_id,@Err_emp_name,@Err_ip)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Err_typeid", SqlDbType.Int,4),
new SqlParameter("@Err_type", SqlDbType.VarChar,250),
new SqlParameter("@Err_time", SqlDbType.DateTime),
new SqlParameter("@Err_url", SqlDbType.VarChar,500),
new SqlParameter("@Err_message", SqlDbType.VarChar),
new SqlParameter("@Err_source", SqlDbType.VarChar,500),
new SqlParameter("@Err_trace", SqlDbType.VarChar),
new SqlParameter("@Err_emp_id", SqlDbType.Int,4),
new SqlParameter("@Err_emp_name", SqlDbType.VarChar,250),
new SqlParameter("@Err_ip", SqlDbType.VarChar,250)};
parameters[0].Value = model.Err_typeid;
parameters[1].Value = model.Err_type;
parameters[2].Value = model.Err_time;
parameters[3].Value = model.Err_url;
parameters[4].Value = model.Err_message;
parameters[5].Value = model.Err_source;
parameters[6].Value = model.Err_trace;
parameters[7].Value = model.Err_emp_id;
parameters[8].Value = model.Err_emp_name;
parameters[9].Value = model.Err_ip;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.Sys_Menu model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Sys_Menu(");
strSql.Append("Menu_name,parentid,parentname,App_id,Menu_url,Menu_icon,Menu_handler,Menu_order,Menu_type)");
strSql.Append(" values (");
strSql.Append("@Menu_name,@parentid,@parentname,@App_id,@Menu_url,@Menu_icon,@Menu_handler,@Menu_order,@Menu_type)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Menu_name", SqlDbType.VarChar,255),
new SqlParameter("@parentid", SqlDbType.Int,4),
new SqlParameter("@parentname", SqlDbType.VarChar,255),
new SqlParameter("@App_id", SqlDbType.Int,4),
new SqlParameter("@Menu_url", SqlDbType.VarChar,255),
new SqlParameter("@Menu_icon", SqlDbType.VarChar,50),
new SqlParameter("@Menu_handler", SqlDbType.VarChar,50),
new SqlParameter("@Menu_order", SqlDbType.Int,4),
new SqlParameter("@Menu_type", SqlDbType.VarChar,50)};
parameters[0].Value = model.Menu_name;
parameters[1].Value = model.parentid;
parameters[2].Value = model.parentname;
parameters[3].Value = model.App_id;
parameters[4].Value = model.Menu_url;
parameters[5].Value = model.Menu_icon;
parameters[6].Value = model.Menu_handler;
parameters[7].Value = model.Menu_order;
parameters[8].Value = model.Menu_type;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.Sys_log model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Sys_log(");
strSql.Append("EventType,EventID,EventTitle,Original_txt,Current_txt,UserID,UserName,IPStreet,EventDate)");
strSql.Append(" values (");
strSql.Append("@EventType,@EventID,@EventTitle,@Original_txt,@Current_txt,@UserID,@UserName,@IPStreet,@EventDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@EventType", SqlDbType.VarChar,250),
new SqlParameter("@EventID", SqlDbType.VarChar,50),
new SqlParameter("@EventTitle", SqlDbType.VarChar,250),
new SqlParameter("@Original_txt", SqlDbType.VarChar,4000),
new SqlParameter("@Current_txt", SqlDbType.VarChar,4000),
new SqlParameter("@UserID", SqlDbType.Int,4),
new SqlParameter("@UserName", SqlDbType.VarChar,50),
new SqlParameter("@IPStreet", SqlDbType.VarChar,50),
new SqlParameter("@EventDate", SqlDbType.DateTime)};
parameters[0].Value = model.EventType;
parameters[1].Value = model.EventID;
parameters[2].Value = model.EventTitle;
parameters[3].Value = model.Original_txt;
parameters[4].Value = model.Current_txt;
parameters[5].Value = model.UserID;
parameters[6].Value = model.UserName;
parameters[7].Value = model.IPStreet;
parameters[8].Value = model.EventDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(XHD.Model.Sys_authority model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Sys_authority(");
strSql.Append("Role_id,App_ids,Menu_ids,Button_ids,Create_id,Create_date)");
strSql.Append(" values (");
strSql.Append("@Role_id,@App_ids,@Menu_ids,@Button_ids,@Create_id,@Create_date)");
SqlParameter[] parameters = {
new SqlParameter("@Role_id", SqlDbType.Int,4),
new SqlParameter("@App_ids", SqlDbType.VarChar,250),
new SqlParameter("@Menu_ids", SqlDbType.VarChar,250),
new SqlParameter("@Button_ids", SqlDbType.VarChar,250),
new SqlParameter("@Create_id", SqlDbType.Int,4),
new SqlParameter("@Create_date", SqlDbType.DateTime)};
parameters[0].Value = model.Role_id;
parameters[1].Value = model.App_ids;
parameters[2].Value = model.Menu_ids;
parameters[3].Value = model.Button_ids;
parameters[4].Value = model.Create_id;
parameters[5].Value = model.Create_date;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(XHD.Model.mail_info model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into mail_info(");
strSql.Append("mail_title,mail_content,atta_count,create_id,create_name,create_time,isDelete,Delete_time)");
strSql.Append(" values (");
strSql.Append("@mail_title,@mail_content,@atta_count,@create_id,@create_name,@create_time,@isDelete,@Delete_time)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@mail_title", SqlDbType.VarChar,250),
new SqlParameter("@mail_content", SqlDbType.Text),
new SqlParameter("@atta_count", SqlDbType.Int,4),
new SqlParameter("@create_id", SqlDbType.Int,4),
new SqlParameter("@create_name", SqlDbType.VarChar,250),
new SqlParameter("@create_time", SqlDbType.DateTime),
new SqlParameter("@isDelete", SqlDbType.Int,4),
new SqlParameter("@Delete_time", SqlDbType.DateTime)};
parameters[0].Value = model.mail_title;
parameters[1].Value = model.mail_content;
parameters[2].Value = model.atta_count;
parameters[3].Value = model.create_id;
parameters[4].Value = model.create_name;
parameters[5].Value = model.create_time;
parameters[6].Value = model.isDelete;
parameters[7].Value = model.Delete_time;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(XHD.Model.Param_SysParam_Type model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Param_SysParam_Type set ");
strSql.Append("id=@id,");
strSql.Append("params_name=@params_name,");
strSql.Append("params_order=@params_order,");
strSql.Append("isDelete=@isDelete,");
strSql.Append("Delete_time=@Delete_time");
strSql.Append(" where ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4),
new SqlParameter("@params_name", SqlDbType.VarChar,250),
new SqlParameter("@params_order", SqlDbType.VarChar,50),
new SqlParameter("@isDelete", SqlDbType.Int,4),
new SqlParameter("@Delete_time", SqlDbType.DateTime)};
parameters[0].Value = model.id;
parameters[1].Value = model.params_name;
parameters[2].Value = model.params_order;
parameters[3].Value = model.isDelete;
parameters[4].Value = model.Delete_time;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ���¸�λ��Ա
/// </summary>
public bool UpdatePostEmp(XHD.Model.hr_post model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update hr_post set ");
strSql.Append("emp_id=@emp_id,");
strSql.Append("emp_name=@emp_name,");
strSql.Append("default_post=@default_post");
strSql.Append(" where post_id=@post_id");
SqlParameter[] parameters = {
new SqlParameter("@emp_id", SqlDbType.Int,4),
new SqlParameter("@emp_name", SqlDbType.VarChar,255),
new SqlParameter("@default_post", SqlDbType.Int,4),
new SqlParameter("@post_id", SqlDbType.Int,4)};
parameters[0].Value = model.emp_id;
parameters[1].Value = model.emp_name;
parameters[2].Value = model.default_post;
parameters[3].Value = model.post_id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
