DAL/SCountSubInfor.cs

（开头部分） 39KB

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

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

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Model.SCountSubInfor model)
        {


            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into SCountSubInfor(");
            strSql.Append("OrderNumber,SCountID,OrderModel,OrderName,OrderMachine,WallThick,MetresWeight,MetrLength,SurfaceID,SurfacePPrice,AlumPPrice,OrderAcount,PackID,PlanCount,PlanWeight,InCount,InWeight,SaleCount,SaleWeight,StockCount,StockWeight,SemiCount,SemiWeight,SSubRemark,BuilderID,BuiderTime,SSIState,OrderSubID,ContSubID,InPack,OutPack,StackPack,SemiPack,Customer_ID,CustomerName");
            strSql.Append(") values (");
            strSql.Append("@OrderNumber,@SCountID,@OrderModel,@OrderName,@OrderMachine,@WallThick,@MetresWeight,@MetrLength,@SurfaceID,@SurfacePPrice,@AlumPPrice,@OrderAcount,@PackID,@PlanCount,@PlanWeight,@InCount,@InWeight,@SaleCount,@SaleWeight,@StockCount,@StockWeight,@SemiCount,@SemiWeight,@SSubRemark,@BuilderID,@BuiderTime,@SSIState,@OrderSubID,@ContSubID,@InPack,@OutPack,@StackPack,@SemiPack,@Customer_ID,@CustomerName");
            strSql.Append(") ");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
			            new SqlParameter("@OrderNumber", SqlDbType.VarChar,50) ,            
                        new SqlParameter("@SCountID", SqlDbType.Int,4) ,            
                        new SqlParameter("@OrderModel", SqlDbType.VarChar,50) ,            
                        new SqlParameter("@OrderName", SqlDbType.VarChar,50) ,            
                        new SqlParameter("@OrderMachine", SqlDbType.VarChar,50) ,            
                        new SqlParameter("@WallThick", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@MetresWeight", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@MetrLength", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@SurfaceID", SqlDbType.Int,4) ,            
                        new SqlParameter("@SurfacePPrice", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@AlumPPrice", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@OrderAcount", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@PackID", SqlDbType.VarChar,50) ,            
                        new SqlParameter("@PlanCount", SqlDbType.Int,4) ,            
                        new SqlParameter("@PlanWeight", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@InCount", SqlDbType.Int,4) ,            
                        new SqlParameter("@InWeight", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@SaleCount", SqlDbType.Int,4) ,            
                        new SqlParameter("@SaleWeight", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@StockCount", SqlDbType.Int,4) ,            
                        new SqlParameter("@StockWeight", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@SemiCount", SqlDbType.Int,4) ,            
                        new SqlParameter("@SemiWeight", SqlDbType.Decimal,9) ,            
                        new SqlParameter("@SSubRemark", SqlDbType.VarChar,500) ,
后面还有 755 行代码，购买后查看完整代码

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

AI 解读

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

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