App_Code/SubModule/SupplierManage.cs

（开头部分） 13KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

/// <summary>
/// SupplierManage 的摘要说明
/// </summary>
/// 
namespace swei
{
    public class SupplierManage
    {
        #region 添加供应商
        /// <summary>
        /// 添加供应商
        /// </summary>
        public int AddSupplier(SupplierData sd)
        {
            Database data = new Database();
            SqlParameter[] prams = {
									    data.MakeInParam("@SupplierCode",SqlDbType.VarChar  ,50,sd.SupplierCode),
                                        data.MakeInParam("@SupplierName",SqlDbType.VarChar   ,100,sd.SupplierName ),
                                        data.MakeInParam("@Contact",SqlDbType.VarChar    ,50,sd.Contact),
                                        data.MakeInParam("@Department",SqlDbType.VarChar    ,50,sd.Department),
                                        data.MakeInParam("@PhoneNum",SqlDbType.VarChar   ,50,sd.PhoneNum),
                                        data.MakeInParam("@ShouJiNum",SqlDbType.VarChar    ,50,sd.ShouJiNum),
                                        data.MakeInParam("@FaxNum",SqlDbType.VarChar    ,  50,sd.FaxNum),
                                        data.MakeInParam("@Email",SqlDbType.VarChar    ,  50,sd.Email),
                                        data.MakeInParam("@Address",SqlDbType.VarChar    ,100,sd.Address ),
                                        data.MakeInParam("@ConcessPPM ",SqlDbType.Decimal    ,9,sd.ConcessPPM ),
                                        data.MakeInParam("@ReturnPPM ",SqlDbType.Decimal    ,9,sd.ReturnPPM ),
                                        data.MakeInParam("@IfRegulate ",SqlDbType.Bit   ,1, sd.SupIfRegulate),
    
								   };
            return data.RunProc("st_AddSupplier", prams);
        }
        #endregion  添加供应商

        #region 更新供应商
        /// <summary>
        /// 更新供应商
        /// </summary>
        public int UpdateSupplier(SupplierData sd)
        {
            Database data = new Database();
            SqlParameter[] prams = {
									    data.MakeInParam("@ID",SqlDbType.Int   ,4,sd.ID ),
                                        data.MakeInParam("@SupplierCode",SqlDbType.VarChar  ,50,sd.SupplierCode),
                                        data.MakeInParam("@SupplierName",SqlDbType.VarChar   ,100,sd.SupplierName ),
                                        data.MakeInParam("@Contact",SqlDbType.VarChar    ,50,sd.Contact),
                                        data.MakeInParam("@Department",SqlDbType.VarChar    ,50,sd.Department),
                                        data.MakeInParam("@PhoneNum",SqlDbType.VarChar   ,50,sd.PhoneNum),
                                        data.MakeInParam("@ShouJiNum",SqlDbType.VarChar    ,50,sd.ShouJiNum),
后面还有 330 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。