C# XHD类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› c#›C#教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中XHD类的典型用法代码示例。如果您正苦于以下问题：C# XHD类的具体用法？C# XHD怎么用？C# XHD使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

XHD类属于命名空间，在下文中一共展示了XHD类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的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);
            }
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:37，代码来源:public_notice.cs

示例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);
            }
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:35，代码来源:CRM_product_category.cs

示例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);
            }
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:35，代码来源:Sys_Button.cs

示例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);
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:32，代码来源:CRM_order_details.cs

示例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);
            }
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:37，代码来源:hr_position.cs

示例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);
            }
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:35，代码来源:Param_City.cs

示例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);
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:32，代码来源:Sys_data_authority.cs

示例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);
            }
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:37，代码来源:Sys_role.cs

示例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);
            }
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:35，代码来源:Personal_notes.cs

示例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);
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:30，代码来源:mail_attachment.cs

示例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);
            }
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:35，代码来源:Sys_App.cs

示例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);
            }
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:61，代码来源:CRM_Contact.cs

示例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);
            }
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:59，代码来源:CRM_invoice.cs

示例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);
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:18，代码来源:Sys_role_emp.cs

示例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);
            }
        }

开发者ID:chuing，项目名称:Push114CRM，代码行数:51，代码来源:hr_department.cs

示例16: Add

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

开发者ID:chuing，项目名称:Push114CRM，代码行数:51，代码来源:mail_flow.cs

示例17: Add

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

开发者ID:chuing，项目名称:Push114CRM，代码行数:50，代码来源:Ext_Task.cs

示例18: Add

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

开发者ID:chuing，项目名称:Push114CRM，代码行数:49，代码来源:hr_post.cs

示例19: Add

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# XMVector类代码示例发布时间：2022-05-24

C# XG_Control类代码示例发布时间：2022-05-24

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：19155|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9980|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8320|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8690|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8632|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9648|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8615|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7994|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8647|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7530|2022-11-06

客服电话

电子邮件

C# XHD类代码示例

示例1: Add

示例2: Add

示例3: Add

示例4: Add

示例5: Add

示例6: Add

示例7: Add

示例8: Add

示例9: Add

示例10: Add

示例11: Add

示例12: Add

示例13: Add

示例14: Add

示例15: Add

示例16: Add

示例17: Add

示例18: Add

示例19: Add

请发表评论

全部评论

上一篇：

下一篇：

bradtraversy/iweather: Ionic 3 mobile we

CVE-2022-32047

avehtari/BDA_m_demos: Bayesian Data Anal

MHeironimus/ArduinoJoystickLibrary: An A

Mathpix/mathpix-markdown-it: Markdown re

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053