DAL/SCountInfor.cs

（开头部分） 24KB

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

using System;
using System.Text;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Data;
using DBUtility;
namespace DAL
{
    //库存表
    public partial class SCountInfor
    {
        public bool Exists(int ID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from SCountInfor");
            strSql.Append(" where ");
            strSql.Append(" ID = @ID  ");
            SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) };
            parameters[0].Value = ID;
            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Model.SCountInfor model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into SCountInfor(");
            strSql.Append("OrderNumber,OrderTypeID,OrderTime,CustomerID,FCustomerID,SendTime,SaleDepartID,EmployID,AlumPrice,TheoryWeight,TotalAcount,ExcPayment,ActPayment,Remark,MaterQuality,BuilderID,BuiderTime,OIState,SOBZ,EndTime,ContentID,PercentID,ProdTime,IF_ProTime,CustAddID,ProductAcount");
            strSql.Append(") values (");
            strSql.Append("@OrderNumber,@OrderTypeID,@OrderTime,@CustomerID,@FCustomerID,@SendTime,@SaleDepartID,@EmployID,@AlumPrice,@TheoryWeight,@TotalAcount,@ExcPayment,@ActPayment,@Remark,@MaterQuality,@BuilderID,@BuiderTime,@OIState,@SOBZ,@EndTime,@ContentID,@PercentID,@ProdTime,@IF_ProTime,@CustAddID,@ProductAcount");
            strSql.Append(") ");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
			            new SqlParameter("@OrderNumber", SqlDbType.VarChar,50) ,            
                        new SqlParameter("@OrderTypeID", SqlDbType.Int,4) ,            
                        new SqlParameter("@OrderTime", SqlDbType.DateTime) ,            
                        new SqlParameter("@CustomerID", SqlDbType.Int,4) ,            
                        new SqlParameter("@FCustomerID", SqlDbType.Int,4) ,            
                        new SqlParameter("@SendTime", SqlDbType.DateTime) ,            
                        new SqlParameter("@SaleDepartID", SqlDbType.Int,4) ,            
                        new SqlParameter("@EmployID", SqlDbType.Int,4) ,            
                        new SqlParameter("@AlumPrice", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@TheoryWeight", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@TotalAcount", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@ExcPayment", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@ActPayment", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@Remark", SqlDbType.VarChar,500) ,            
                        new SqlParameter("@MaterQuality", SqlDbType.VarChar,200) ,  
                        new SqlParameter("@BuilderID", SqlDbType.Int,4) ,            
                        new SqlParameter("@BuiderTime", SqlDbType.DateTime) ,      
                        new SqlParameter("@OIState", SqlDbType.Int,4) ,            
                        new SqlParameter("@SOBZ", SqlDbType.Int,4) ,            
                        new SqlParameter("@EndTime", SqlDbType.DateTime),
                        new SqlParameter("@ContentID", SqlDbType.Int,4), 
                        new SqlParameter("@PercentID", SqlDbType.Int,4) ,
                        new SqlParameter("@ProdTime", SqlDbType.DateTime),
                        new SqlParameter("@IF_ProTime", SqlDbType.Int,4),
                        new SqlParameter("@CustAddID", SqlDbType.Int,4),
后面还有 443 行代码，购买后查看完整代码

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

AI 解读

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

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