本文整理汇总了C#中XHD类的典型用法代码示例。如果您正苦于以下问题：C# XHD类的具体用法？C# XHD怎么用？C# XHD使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
XHD类属于命名空间，在下文中一共展示了XHD类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Add
/// <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);
}
}示例2: Add
/// <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);
}
}示例3: Add
/// <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);
}
}示例4: Add
/// <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);
}示例5: Add
/// <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);
}
}示例6: Add
/// <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);
}
}示例7: Add
/// <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);
}示例8: Add
/// <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);
}
}示例9: Add
/// <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);
}
}示例10: Add
/// <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);
}示例11: Add
/// <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);
}
}示例12: Add
/// <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);
}
}示例13: Add
/// <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);
}
}示例14: Add
/// <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);
}示例15: Add
/// <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);
}
}