예제 #1
0
        public static string AddStorageTransfer(StorageTransfer st, List<StorageTransferDetail> stdList, Hashtable ht)
        {

            //return "1|" + ((SqlCommand)SqlCmdList[0]).Parameters["@ID"].Value.ToString() + "#" + st.TransferNo;

            //定义返回变量
            string res = string.Empty;
            /* 
             * 定义日志内容变量 
             * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库
             * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件
             */
            //获取当前用户信息
            UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];

            //执行操作
            try
            {
                //执行操作
                res = XBase.Data.Office.StorageManager.StorageTransferDBHelper.AddStorageTransfer(st, stdList,ht);
            }
            catch (Exception ex)
            {
                //输出日志
                WriteSystemLog(userInfo, ex);
            }
            //定义变量
            string remark;
            //成功时
            if (res.Split('|')[0] == "1")
            {
                //设置操作成功标识
                remark = ConstUtil.LOG_PROCESS_SUCCESS;
            }
            else
            {
                //设置操作成功标识 
                remark = ConstUtil.LOG_PROCESS_FAILED;
            }
            //操作日志
            LogInfoModel logModel = InitLogInfo(st.TransferNo);
            //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空
            logModel.Element = ConstUtil.LOG_PROCESS_INSERT; ;

            //设置操作成功标识
            logModel.Remark = remark;

            //登陆日志
            LogDBHelper.InsertLog(logModel);

            return res;


        }
예제 #2
0
 /*提供打印*/
 public static DataTable GetStorageTransferInfoPrint(StorageTransfer st)
 {
     return XBase.Data.Office.StorageManager.StorageTransferDBHelper.GetStorageTransferInfoPrint(st);
 }
        public static DataTable GetStorageTransferInfo(StorageTransfer st)
        {
            StringBuilder sbSql = new StringBuilder();
            sbSql.Append("select st.ID,st.TransferNo,st.Title,st.ApplyUserID,");
            sbSql.Append("(SELECT ei1.EmployeeName from officedba.EmployeeInfo as ei1 where st.ApplyUserID=ei1.ID) AS ApplyUserIDName,");
            sbSql.Append("st.ApplyDeptID,");
            sbSql.Append("(SELECT di1.DeptName from officedba.DeptInfo as di1 where st.ApplyDeptID=di1.ID) AS ApplyDeptIDName,");
            sbSql.Append("st.InStorageID,st.RequireInDate,st.ReasonType,");
            sbSql.Append("st.OutDeptID,");
            sbSql.Append("(SELECT di2.DeptName from officedba.DeptInfo as di2 where st.OutDeptID=di2.ID) AS OutDeptIDName,");
            sbSql.Append("st.OutStorageID,st.OutDate,st.BusiStatus,st.Summary,st.TransferCount,st.TransferPrice,st.TransferFeeSum,");
            sbSql.Append("st.Creator,");
            sbSql.Append("(SELECT ei2.EmployeeName from officedba.EmployeeInfo as ei2 where st.Creator=ei2.ID) as CreatorName,");
            sbSql.Append("st.CreateDate,st.BillStatus,st.Remark,");
            sbSql.Append("(SELECT ei3.EmployeeName from officedba.EmployeeInfo as ei3 where st.Confirmor=ei3.ID) as ConfirmorName,");
            sbSql.Append("st.ConfirmDate,st.Closer,");
            sbSql.Append("(SELECT ei4.EmployeeName from officedba.EmployeeInfo as ei4 where st.Closer=ei4.ID) as CloserName,");
            sbSql.Append("st.CloseDate,st.ModifiedDate,st.ModifiedUserID,st.OutFeeSum,st.InFeeSum,st.OutCount, st.InCount,st.OutUserID,");
            sbSql.Append("(SELECT ei5.EmployeeName from officedba.EmployeeInfo as ei5 where st.OutUserID=ei5.ID) as OutUserIDName,");
            sbSql.Append("st.OutDate,st.InUserID,st.InDate,");
            sbSql.Append("(SELECT ei6.EmployeeName from officedba.EmployeeInfo as ei6 where st.InUserID=ei6.ID) as InUserIDName, ");
            sbSql.Append("isnull(ExtField1,'')ExtField1,isnull(ExtField2,'')ExtField2,isnull(ExtField3,'')ExtField3,isnull(ExtField4,'')ExtField4,");
            sbSql.Append("isnull(ExtField5,'')ExtField5,isnull(ExtField6,''),ExtField6,isnull(ExtField7,'')ExtField7,isnull(ExtField8,'')ExtField8,");
            sbSql.Append("   isnull(ExtField9,'')ExtField9,isnull(ExtField10,'')ExtField10 ");
            sbSql.Append("from officedba.StorageTransfer as st ");
            sbSql.Append(" where ID=@ID");
            SqlParameter[] Paras = { 
                                       new SqlParameter("@ID",SqlDbType.Int)
                                   };
            Paras[0].Value = st.ID;

            return SqlHelper.ExecuteSql(sbSql.ToString(), Paras);
        }
        /*提供打印*/
        public static DataTable GetStorageTransferInfoPrint(StorageTransfer st)
        {
            StringBuilder sbSql = new StringBuilder();
            sbSql.Append("   ");
            sbSql.Append(" SELECT     ID, TransferNo, Title, ApplyUserID, ");
            sbSql.Append("  (SELECT     DeptName ");
            sbSql.Append("  FROM          officedba.DeptInfo AS di ");
            sbSql.Append("  WHERE      (ID = st.InStorageID)) AS InStorageName, ");
            sbSql.Append("  (SELECT     DeptName ");
            sbSql.Append("  FROM          officedba.DeptInfo AS di1 ");
            sbSql.Append("  WHERE      (ID = st.OutStorageID)) AS OutStorageName,  ");
            sbSql.Append("  (CASE st.BusiStatus WHEN '1' THEN '调拨申请' WHEN '2' THEN '调拨出库' WHEN '3' THEN '调拨入库' WHEN '4' THEN '调拨完成' END)  ");
            sbSql.Append("  AS BusiStatusText, ");
            sbSql.Append("  (SELECT     CodeName ");
            sbSql.Append("  FROM          officedba.CodeReasonType AS crt ");
            sbSql.Append("  WHERE      (ID = st.ReasonType)) AS Reason, ");
            sbSql.Append("  (SELECT     EmployeeName ");
            sbSql.Append("  FROM          officedba.EmployeeInfo AS ei1 ");
            sbSql.Append("  WHERE      (st.ApplyUserID = ID)) AS ApplyUserIDName, ApplyDeptID, ");
            sbSql.Append("  (SELECT     DeptName ");
            sbSql.Append("  FROM          officedba.DeptInfo AS di1 ");
            sbSql.Append("  WHERE      (st.ApplyDeptID = ID)) AS ApplyDeptIDName, InStorageID,CONVERT(VARCHAR(10),RequireInDate, 21)RequireInDate , ReasonType, OutDeptID, ");
            sbSql.Append("  (SELECT     DeptName ");
            sbSql.Append("  FROM          officedba.DeptInfo AS di2 ");
            sbSql.Append("  WHERE      (st.OutDeptID = ID)) AS OutDeptIDName, OutStorageID, CONVERT(VARCHAR(10),OutDate, 21)OutDate, BusiStatus, Summary, TransferCount, TransferPrice, TransferFeeSum,  ");
            sbSql.Append("  Creator, ");
            sbSql.Append("  (SELECT     EmployeeName ");
            sbSql.Append("  FROM          officedba.EmployeeInfo AS ei2 ");
            sbSql.Append("  WHERE      (st.Creator = ID)) AS CreatorName, CONVERT(VARCHAR(10),CreateDate, 21)CreateDate, BillStatus, Remark, ");
            sbSql.Append("  (SELECT     EmployeeName ");
            sbSql.Append("  FROM          officedba.EmployeeInfo AS ei3 ");
            sbSql.Append("  WHERE      (st.Confirmor = ID)) AS ConfirmorName, CONVERT(VARCHAR(10),ConfirmDate, 21)ConfirmDate , Closer, ");
            sbSql.Append("  (SELECT     EmployeeName ");
            sbSql.Append("  FROM          officedba.EmployeeInfo AS ei4 ");
            sbSql.Append("  WHERE      (st.Closer = ID)) AS CloserName, CONVERT(VARCHAR(10),CloseDate, 21)CloseDate , CONVERT(VARCHAR(10),ModifiedDate, 21)ModifiedDate, ModifiedUserID, OutFeeSum, InFeeSum, OutCount, InCount, OutUserID, ");
            sbSql.Append("  (SELECT     EmployeeName ");
            sbSql.Append("  FROM          officedba.EmployeeInfo AS ei5 ");
            sbSql.Append("  WHERE      (st.OutUserID = ID)) AS OutUserIDName, OutDate AS Expr1, InUserID,CONVERT(VARCHAR(10),InDate, 21)InDate , ");
            sbSql.Append("  (SELECT     EmployeeName ");
            sbSql.Append("  FROM          officedba.EmployeeInfo AS ei6 ");
            sbSql.Append("  WHERE      (st.InUserID = ID)) AS InUserIDName,  ");
            sbSql.Append("  (CASE st.BillStatus WHEN '1' THEN '制单' WHEN '2' THEN '执行' WHEN '4' THEN '手工结单' WHEN '5' THEN '自动结单' END)  ");
            sbSql.Append("  AS BillStatusText, ");
            sbSql.Append("isnull(st.ExtField1,'')ExtField1,isnull(st.ExtField2,'')ExtField2,isnull(st.ExtField3,'')ExtField3,isnull(st.ExtField4,'')ExtField4,");
            sbSql.Append("isnull(st.ExtField5,'')ExtField5,isnull(st.ExtField6,''),ExtField6,isnull(st.ExtField7,'')ExtField7,isnull(st.ExtField8,'')ExtField8,");
            sbSql.Append("   isnull(st.ExtField9,'')ExtField9,isnull(st.ExtField10,'')ExtField10 ");
            sbSql.Append("  FROM         officedba.StorageTransfer AS st ");
            sbSql.Append(" where ID=@ID");
            SqlParameter[] Paras = { 
                                       new SqlParameter("@ID",SqlDbType.Int)
                                   };
            Paras[0].Value = st.ID;

            return SqlHelper.ExecuteSql(sbSql.ToString(), Paras);
        }
        public static string UpdateStorageTransfer(StorageTransfer st, List<StorageTransferDetail> stdList, Hashtable ht)
        {
            #region 构造调拨单SQL字符串

            StringBuilder strSql = new StringBuilder();
            strSql.Append("update officedba.StorageTransfer set ");
            strSql.Append("Title=@Title,");
            strSql.Append("ReasonType=@ReasonType,");
            strSql.Append("InStorageID=@InStorageID,");
            strSql.Append("OutStorageID=@OutStorageID,");
            strSql.Append("ApplyUserID=@ApplyUserID,");
            strSql.Append("ApplyDeptID=@ApplyDeptID,");
            strSql.Append("OutDeptID=@OutDeptID,");
            strSql.Append("RequireInDate=@RequireInDate,");
            strSql.Append("TransferCount=@TransferCount,");
            strSql.Append("TransferFeeSum=@TransferFeeSum,");
            strSql.Append("Remark=@Remark,");
            strSql.Append("ModifiedDate=@ModifiedDate,");
            strSql.Append("ModifiedUserID=@ModifiedUserID");
            strSql.Append(",Summary=@Summary ");
            strSql.Append(" where ID=@ID ");
            SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4),
					new SqlParameter("@Title", SqlDbType.VarChar,100),
					new SqlParameter("@ReasonType", SqlDbType.Int,4),
					new SqlParameter("@InStorageID", SqlDbType.Int,4),
					new SqlParameter("@OutStorageID", SqlDbType.Int,4),
					new SqlParameter("@ApplyUserID", SqlDbType.Int,4),
					new SqlParameter("@ApplyDeptID", SqlDbType.Int,4),
					new SqlParameter("@OutDeptID", SqlDbType.Int,4),
					new SqlParameter("@RequireInDate", SqlDbType.DateTime),
					new SqlParameter("@TransferPrice", SqlDbType.Decimal,9),
					new SqlParameter("@TransferCount", SqlDbType.Decimal,9),
                    new SqlParameter("@TransferFeeSum",SqlDbType.Decimal,9),
					new SqlParameter("@Remark", SqlDbType.VarChar,800),
					new SqlParameter("@ModifiedDate", SqlDbType.DateTime),
					new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50),
                    new SqlParameter("@Summary",SqlDbType.VarChar)
                                        };
            parameters[0].Value = st.ID;
            parameters[1].Value = st.Title;
            parameters[2].Value = st.ReasonType;
            parameters[3].Value = st.InStorageID;
            parameters[4].Value = st.OutStorageID;
            parameters[5].Value = st.ApplyUserID;
            parameters[6].Value = st.ApplyDeptID;
            parameters[7].Value = st.OutDeptID;
            parameters[8].Value = st.RequireInDate;
            parameters[9].Value = st.TransferPrice;
            parameters[10].Value = st.TransferCount;
            parameters[11].Value = st.TransferFeeSum;
            parameters[12].Value = st.Remark;
            parameters[13].Value = st.ModifiedDate;
            parameters[14].Value = st.ModifiedUserID;
            parameters[15].Value = st.Summary;

            #endregion

            SqlCommand SqlMainCmd = new SqlCommand();
            SqlMainCmd.CommandText = strSql.ToString();
            SqlMainCmd.Parameters.AddRange(parameters);
            ArrayList SqlCmdList = new ArrayList();
            SqlCmdList.Add(SqlMainCmd);
            #region 拓展属性
            SqlCommand cmd = new SqlCommand();
            GetExtAttrCmd(st, ht, cmd);
            if (ht.Count > 0)
                SqlCmdList.Add(cmd);
            #endregion
            #region 构造调拨单明细SQL字符串
            StringBuilder sbDel = new StringBuilder();
            sbDel.Append("DELETE officedba.StorageTransferDetail WHERE TransferNo=@TransferNo AND CompanyCD=@CompanyCD");
            SqlParameter[] Paras = { 
                                       new SqlParameter("@TransferNo",SqlDbType.VarChar),
                                       new SqlParameter("@CompanyCD",SqlDbType.VarChar)
                                   };
            Paras[0].Value = st.TransferNo;
            Paras[1].Value = st.CompanyCD;

            SqlCommand sqlDelCmd = new SqlCommand();
            sqlDelCmd.CommandText = sbDel.ToString();
            sqlDelCmd.Parameters.AddRange(Paras);
            SqlCmdList.Add(sqlDelCmd);

            foreach (StorageTransferDetail std in stdList)
            {
                StringBuilder strSubSql = new StringBuilder();
                strSubSql.Append("insert into officedba.StorageTransferDetail(");
                strSubSql.Append("CompanyCD,TransferNo,SortNo,ProductID,UnitID,TranCount,TranPrice,TranPriceTotal,Remark,ModifiedDate,ModifiedUserID,UsedUnitID,UsedUnitCount,UsedPrice,ExRate,BatchNo)");
                strSubSql.Append(" values (");
                strSubSql.Append("@CompanyCD,@TransferNo,@SortNo,@ProductID,@UnitID,@TranCount,@TranPrice,@TranPriceTotal,@Remark,@ModifiedDate,@ModifiedUserID,@UsedUnitID,@UsedUnitCount,@UsedPrice,@ExRate,@BatchNo)");
                SqlParameter[] subparas = {
					new SqlParameter("@CompanyCD", SqlDbType.VarChar,8),
					new SqlParameter("@TransferNo", SqlDbType.VarChar,50),
					new SqlParameter("@SortNo", SqlDbType.Int,4),
					new SqlParameter("@ProductID", SqlDbType.Int,4),
					new SqlParameter("@UnitID", SqlDbType.Int,4),
					new SqlParameter("@TranCount", SqlDbType.Decimal,9),
					new SqlParameter("@TranPrice", SqlDbType.Decimal,9),
					new SqlParameter("@TranPriceTotal", SqlDbType.Decimal,9),
					new SqlParameter("@Remark", SqlDbType.VarChar,800),
					new SqlParameter("@ModifiedDate", SqlDbType.DateTime),
					new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50),
                    new SqlParameter("@UsedUnitID", SqlDbType.Int,4),
					new SqlParameter("@UsedUnitCount", SqlDbType.Decimal,9),
					new SqlParameter("@UsedPrice", SqlDbType.Decimal,9),
					new SqlParameter("@ExRate", SqlDbType.Decimal,9),
                    new SqlParameter("@BatchNo",SqlDbType.VarChar)};
                subparas[0].Value = std.CompanyCD;
                subparas[1].Value = std.TransferNo;
                subparas[2].Value = std.SortNo;
                subparas[3].Value = std.ProductID;
                if (std.UnitID != null)
                    subparas[4].Value = std.UnitID;
                else
                    subparas[4].Value = DBNull.Value;
                subparas[5].Value = std.TranCount;
                subparas[6].Value = std.TranPrice;
                subparas[7].Value = std.TranPriceTotal;
                subparas[8].Value = std.Remark;
                subparas[9].Value = std.ModifiedDate;
                subparas[10].Value = std.ModifiedUserID;
                subparas[11].Value = std.UsedUnitID;
                subparas[12].Value = std.UsedUnitCount;
                subparas[13].Value = std.UsedPrice;
                subparas[14].Value = std.ExRate;
                subparas[15].Value = std.BatchNo;

                SqlCommand sqlSubCmd = new SqlCommand();
                sqlSubCmd.Parameters.AddRange(subparas);
                sqlSubCmd.CommandText = strSubSql.ToString();
                SqlCmdList.Add(sqlSubCmd);

            }



            #endregion

            bool result = SqlHelper.ExecuteTransWithArrayList(SqlCmdList);
            if (result)
                return "1|";
            else
                return "3|";


        }
        /// <summary>
        /// 扩展属性保存操作
        /// </summary>
        /// <returns></returns>
        private static void GetExtAttrCmd(StorageTransfer model, Hashtable htExtAttr, SqlCommand cmd)
        {
            try
            {
                string strSql = string.Empty;

                strSql = "UPDATE officedba.StorageTransfer set ";
                foreach (DictionaryEntry de in htExtAttr)// fileht为一个Hashtable实例
                {
                    strSql += de.Key.ToString().Trim() + "=@" + de.Key.ToString().Trim() + ",";
                    cmd.Parameters.AddWithValue("@" + de.Key.ToString().Trim(), de.Value.ToString().Trim());
                }
                int iLength = strSql.Length - 1;
                strSql = strSql.Substring(0, iLength);
                strSql += " where CompanyCD = @CompanyCD  AND TransferNo = @TransferNo";
                cmd.Parameters.AddWithValue("@CompanyCD", model.CompanyCD);
                cmd.Parameters.AddWithValue("@TransferNo", model.TransferNo);
                cmd.CommandText = strSql;
            }
            catch (Exception)
            { }


        }
        public static string AddStorageTransfer(StorageTransfer st, List<StorageTransferDetail> stdList, Hashtable ht)
        {

            #region 构造SQL字符串
            StringBuilder strMainSql = new StringBuilder();
            strMainSql.Append("insert into officedba.StorageTransfer(");
            strMainSql.Append("CompanyCD,TransferNo,Title,ReasonType,InStorageID,OutStorageID,ApplyUserID,ApplyDeptID,OutDeptID,RequireInDate,TransferPrice,TransferFeeSum,TransferCount,BusiStatus,Remark,Creator,CreateDate,BillStatus,ModifiedDate,ModifiedUserID,Summary)");
            strMainSql.Append(" values (");
            strMainSql.Append("@CompanyCD,@TransferNo,@Title,@ReasonType,@InStorageID,@OutStorageID,@ApplyUserID,@ApplyDeptID,@OutDeptID,@RequireInDate,@TransferPrice,@TransferFeeSum,@TransferCount,@BusiStatus,@Remark,@Creator,@CreateDate,@BillStatus,@ModifiedDate,@ModifiedUserID,@Summary)");
            strMainSql.Append(";select @ID=@@IDENTITY");
            SqlParameter[] MainParas = {
					new SqlParameter("@CompanyCD", SqlDbType.VarChar,8),
					new SqlParameter("@TransferNo", SqlDbType.VarChar,50),
					new SqlParameter("@Title", SqlDbType.VarChar,100),
					new SqlParameter("@ReasonType", SqlDbType.Int,4),
					new SqlParameter("@InStorageID", SqlDbType.Int,4),
					new SqlParameter("@OutStorageID", SqlDbType.Int,4),
					new SqlParameter("@ApplyUserID", SqlDbType.Int,4),
					new SqlParameter("@ApplyDeptID", SqlDbType.Int,4),
					new SqlParameter("@OutDeptID", SqlDbType.Int,4),
					new SqlParameter("@RequireInDate", SqlDbType.DateTime),
					new SqlParameter("@TransferPrice", SqlDbType.Decimal,9),
                    new SqlParameter("@TransferFeeSum",SqlDbType.Decimal,9),
					new SqlParameter("@TransferCount", SqlDbType.Decimal,9),
					new SqlParameter("@BusiStatus", SqlDbType.Char,1),
					new SqlParameter("@Remark", SqlDbType.VarChar,800),
					new SqlParameter("@Creator", SqlDbType.Int,4),
					new SqlParameter("@CreateDate", SqlDbType.DateTime),
					new SqlParameter("@BillStatus", SqlDbType.Char,1),
					new SqlParameter("@ModifiedDate", SqlDbType.DateTime),
					new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50),
                    new SqlParameter("@Summary",SqlDbType.VarChar),
                    new SqlParameter("@ID",SqlDbType.Int)};
            MainParas[0].Value = st.CompanyCD;
            MainParas[1].Value = st.TransferNo;
            MainParas[2].Value = st.Title;
            MainParas[3].Value = st.ReasonType;
            MainParas[4].Value = st.InStorageID;
            MainParas[5].Value = st.OutStorageID;
            MainParas[6].Value = st.ApplyUserID;
            MainParas[7].Value = st.ApplyDeptID;
            MainParas[8].Value = st.OutDeptID;
            MainParas[9].Value = st.RequireInDate;
            MainParas[10].Value = st.TransferPrice;
            MainParas[11].Value = st.TransferFeeSum;
            MainParas[12].Value = st.TransferCount;
            MainParas[13].Value = st.BusiStatus;
            MainParas[14].Value = st.Remark;
            MainParas[15].Value = st.Creator;
            MainParas[16].Value = st.CreateDate;
            MainParas[17].Value = st.BillStatus;
            MainParas[18].Value = st.ModifiedDate;
            MainParas[19].Value = st.ModifiedUserID;
            MainParas[20].Value = st.Summary;
            MainParas[21].Direction = ParameterDirection.Output;

            #endregion

            SqlCommand sqlMainCmd = new SqlCommand();
            sqlMainCmd.CommandText = strMainSql.ToString();
            sqlMainCmd.Parameters.AddRange(MainParas);
            ArrayList SqlCmdList = new ArrayList();
            SqlCmdList.Add(sqlMainCmd);
            #region 拓展属性
            SqlCommand cmd = new SqlCommand();
            GetExtAttrCmd(st, ht, cmd);
            if (ht.Count > 0)
                SqlCmdList.Add(cmd);
            #endregion
            #region 构造明细SQL字符串
            foreach (StorageTransferDetail std in stdList)
            {
                StringBuilder strSubSql = new StringBuilder();
                strSubSql.Append("insert into officedba.StorageTransferDetail(");
                strSubSql.Append("CompanyCD,TransferNo,SortNo,ProductID,UnitID,TranCount,TranPrice,TranPriceTotal,Remark,ModifiedDate,ModifiedUserID,UsedUnitID,UsedUnitCount,UsedPrice,ExRate,BatchNo)");
                strSubSql.Append(" values (");
                strSubSql.Append("@CompanyCD,@TransferNo,@SortNo,@ProductID,@UnitID,@TranCount,@TranPrice,@TranPriceTotal,@Remark,@ModifiedDate,@ModifiedUserID,@UsedUnitID,@UsedUnitCount,@UsedPrice,@ExRate,@BatchNo)");
                SqlParameter[] parameters = {
					new SqlParameter("@CompanyCD", SqlDbType.VarChar,8),
					new SqlParameter("@TransferNo", SqlDbType.VarChar,50),
					new SqlParameter("@SortNo", SqlDbType.Int,4),
					new SqlParameter("@ProductID", SqlDbType.Int,4),
					new SqlParameter("@UnitID", SqlDbType.Int,4),
					new SqlParameter("@TranCount", SqlDbType.Decimal,9),
					new SqlParameter("@TranPrice", SqlDbType.Decimal,9),
					new SqlParameter("@TranPriceTotal", SqlDbType.Decimal,9),
					new SqlParameter("@Remark", SqlDbType.VarChar,800),
					new SqlParameter("@ModifiedDate", SqlDbType.DateTime),
					new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50),
                    new SqlParameter("@UsedUnitID", SqlDbType.Int,4),
					new SqlParameter("@UsedUnitCount", SqlDbType.Decimal,9),
					new SqlParameter("@UsedPrice", SqlDbType.Decimal,9),
					new SqlParameter("@ExRate", SqlDbType.Decimal,9),
                    new SqlParameter("@BatchNo",SqlDbType.VarChar)};
                parameters[0].Value = std.CompanyCD;
                parameters[1].Value = std.TransferNo;
                parameters[2].Value = std.SortNo;
                parameters[3].Value = std.ProductID;
                if (std.UnitID != null)
                    parameters[4].Value = std.UnitID;
                else
                    parameters[4].Value = DBNull.Value;
                parameters[5].Value = std.TranCount;
                parameters[6].Value = std.TranPrice;
                parameters[7].Value = std.TranPriceTotal;
                parameters[8].Value = std.Remark;
                parameters[9].Value = std.ModifiedDate;
                parameters[10].Value = std.ModifiedUserID;
                parameters[11].Value = std.UsedUnitID;
                parameters[12].Value = std.UsedUnitCount;
                parameters[13].Value = std.UsedPrice;
                parameters[14].Value = std.ExRate;
                parameters[15].Value = std.BatchNo;

                SqlCommand sqlSubCmd = new SqlCommand();
                sqlSubCmd.Parameters.AddRange(parameters);
                sqlSubCmd.CommandText = strSubSql.ToString();
                SqlCmdList.Add(sqlSubCmd);

            }
            #endregion

            bool result = SqlHelper.ExecuteTransWithArrayList(SqlCmdList);
            if (result)
            {
                return "1|" + ((SqlCommand)SqlCmdList[0]).Parameters["@ID"].Value.ToString() + "#" + st.TransferNo;
            }
            else
                return "3|保存数据失败";

        }
    protected void LoadPrintInfo()
    {
        PrintParameterSettingModel model = new PrintParameterSettingModel();
        model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_STORAGE);
        model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_TRANSFER;

        StorageInitailModel OutSellM_ = new StorageInitailModel();
        OutSellM_.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        OutSellM_.ID = this.intMrpID.ToString();

        /*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
        string[,] aBase = { 
                                { "{ExtField1}", "ExtField1"},
                                { "{ExtField2}", "ExtField2"},
                                { "{ExtField3}", "ExtField3"},
                                { "{ExtField4}", "ExtField4"},
                                { "{ExtField5}", "ExtField5"},
                                { "{ExtField6}", "ExtField6"},
                                { "{ExtField7}", "ExtField7"},
                                { "{ExtField8}", "ExtField8"},
                                { "{ExtField9}", "ExtField9"},
                                { "{ExtField10}", "ExtField10"},
                                { "调拨单编号", "TransferNo"}, 
                                { "调拨单主题", "Title"}, 
                                { "调拨申请人", "ApplyUserIDName" },
                                { "要货部门", "ApplyDeptIDName" },
                                { "调入仓库", "InStorageName"},
                                { "要求到货日期", "RequireInDate"},
                                { "调拨原因 ", "Reason"},
                                { "调货部门 ", "OutDeptIDName"},
                                { "调出仓库 ", "OutStorageName"},
                             
                                { "业务状态", "BusiStatusText"},
                                { "摘要", "Summary"},
                                { "调拨数量合计 ", "TransferCount"},

                                { "调拨金额合计 ", "TransferPrice"},
                                { "调拨费用 ", "TransferFeeSum"},


                                { "制单人", "CreatorName"},

                                { "制单日期", "CreateDate"},
                                { "单据状态", "BillStatusText"},
                                { "确认人", "ConfirmorName"},
                                { "确认日期", "ConfirmDate"},
                                { "结单人", "CloserName"},
                                { "结单日期", "CloseDate"},
                                { "最后更新人", "ModifiedUserID"},
                                { "最后更新日期", "ModifiedDate"},
                                { "备注", "Remark"},

                          };

        string[,] aDetail =null;
        if(!UserInfo.IsMoreUnit)
      aDetail= new string[,] { 
                                { "序号", "SortNo"}, 
                                { "物品编号", "ProdNo"}, 
                                { "物品名称", "ProductName" },
                                {"批次","BatchNo"},
                                { "规格", "Specification" },
                                { "单位", "UnitName"},
                                { "调拨单价", "TranPrice"},
                                { "调拨数量 ", "TranCount"},
                                { "调拨金额 ", "TranPriceTotal"},
                                { "已出库数量 ", "OutCount"},
                                { "已入库数量 ", "InCount"},
                                { "备注 ", "Remark"},

                           };
        else
            aDetail = new string[,] { 
                                { "序号", "SortNo"}, 
                                { "物品编号", "ProdNo"}, 
                                { "物品名称", "ProductName" },
                                 {"批次","BatchNo"},
                                { "规格", "Specification" },
                                { "基本单位", "UnitName"},
                                {"基本数量","TranCount"},
                                { "单位", "UsedUnitName"},
                                { "调拨单价", "TranPrice"},
                                { "调拨数量 ", "UsedUnitCount"},
                                { "调拨金额 ", "TranPriceTotal"},
                                { "已出库数量 ", "OutCount"},
                                { "已入库数量 ", "InCount"},
                                { "备注 ", "Remark"},

                           };



        #region 1.扩展属性
        int countExt = 0;
        DataTable dtExtTable = XBase.Business.Office.SupplyChain.TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.StorageTransfer");
        if (dtExtTable.Rows.Count > 0)
        {
            for (int i = 0; i < dtExtTable.Rows.Count; i++)
            {
                for (int x = 0; x < (aBase.Length / 2) - 15; x++)
                {
                    if (x == i)
                    {
                        aBase[x, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
                        countExt++;
                    }
                }
            }
        }
        #endregion
        string No = Request.QueryString["No"].ToString();
        DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);

        XBase.Model.Office.StorageManager.StorageTransfer st = new XBase.Model.Office.StorageManager.StorageTransfer();
        st.ID = intMrpID;
        XBase.Model.Office.StorageManager.StorageTransferDetail std = new XBase.Model.Office.StorageManager.StorageTransferDetail();
        std.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        std.TransferNo = No;
        /*读取数据*/
        DataTable dtMRP =  XBase.Business.Office.StorageManager.StorageTransferBus.GetStorageTransferInfoPrint(st);
        DataTable dtDetail = XBase.Business.Office.StorageManager.StorageTransferBus.GetStorageTransferDetailInfo(std);
        string strBaseFields = "";
        string strDetailFields = "";


        if (dbPrint.Rows.Count > 0)
        {
            #region 设置过打印模板设置时 直接取出表里设置的值
            isSeted.Value = "1";
            strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
            strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
            #endregion
        }
        else
        {
            #region 未设置过打印模板设置 默认显示所有的
            isSeted.Value = "0";

            /*未设置过打印模板设置时,默认显示的字段  基本信息字段*/
            for (int m = 10; m < aBase.Length / 2; m++)
            {
                strBaseFields = strBaseFields + aBase[m, 1] + "|";
            }
            /*未设置过打印模板设置时,默认显示的字段 基本信息字段+扩展信息字段*/
            if (countExt > 0)
            {
                for (int i = 0; i < countExt; i++)
                {
                    strBaseFields = strBaseFields + "ExtField" + (i + 1) + "|";
                }
            }
            /*未设置过打印模板设置时,默认显示的字段 明细信息字段*/
            for (int n = 0; n < aDetail.Length / 2; n++)
            {
                strDetailFields = strDetailFields + aDetail[n, 1] + "|";
            }
            #endregion
        }

        #region 2.主表信息
        if (!string.IsNullOrEmpty(strBaseFields))
        {
            tableBase.InnerHtml = WritePrintPageTable("库存调拨单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMRP, dtDetail, true);
        }
        #endregion

        #region 3.明细信息
        if (!string.IsNullOrEmpty(strDetailFields))
        {
            tableDetail.InnerHtml = WritePrintPageTable("库存调拨单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMRP, dtDetail, false);
        }
        #endregion

    }
예제 #9
0
    protected void LoadPrintInfo()
    {
        PrintParameterSettingModel model = new PrintParameterSettingModel();

        model.CompanyCD     = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        model.BillTypeFlag  = int.Parse(ConstUtil.BILL_TYPEFLAG_STORAGE);
        model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_TRANSFER;

        StorageInitailModel OutSellM_ = new StorageInitailModel();

        OutSellM_.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        OutSellM_.ID        = this.intMrpID.ToString();

        /*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
        string[,] aBase =
        {
            { "{ExtField1}",  "ExtField1"       },
            { "{ExtField2}",  "ExtField2"       },
            { "{ExtField3}",  "ExtField3"       },
            { "{ExtField4}",  "ExtField4"       },
            { "{ExtField5}",  "ExtField5"       },
            { "{ExtField6}",  "ExtField6"       },
            { "{ExtField7}",  "ExtField7"       },
            { "{ExtField8}",  "ExtField8"       },
            { "{ExtField9}",  "ExtField9"       },
            { "{ExtField10}", "ExtField10"      },
            { "调拨单编号",        "TransferNo"      },
            { "调拨单主题",        "Title"           },
            { "调拨申请人",        "ApplyUserIDName" },
            { "要货部门",         "ApplyDeptIDName" },
            { "调入仓库",         "InStorageName"   },
            { "要求到货日期",       "RequireInDate"   },
            { "调拨原因 ",        "Reason"          },
            { "调货部门 ",        "OutDeptIDName"   },
            { "调出仓库 ",        "OutStorageName"  },

            { "业务状态",         "BusiStatusText"  },
            { "摘要",           "Summary"         },
            { "调拨数量合计 ",      "TransferCount"   },

            { "调拨金额合计 ",      "TransferPrice"   },
            { "调拨费用 ",        "TransferFeeSum"  },


            { "制单人",          "CreatorName"     },

            { "制单日期",         "CreateDate"      },
            { "单据状态",         "BillStatusText"  },
            { "确认人",          "ConfirmorName"   },
            { "确认日期",         "ConfirmDate"     },
            { "结单人",          "CloserName"      },
            { "结单日期",         "CloseDate"       },
            { "最后更新人",        "ModifiedUserID"  },
            { "最后更新日期",       "ModifiedDate"    },
            { "备注",           "Remark"          },
        };

        string[,] aDetail = null;
        if (!UserInfo.IsMoreUnit)
        {
            aDetail = new string[, ] {
                { "序号", "SortNo" },
                { "物品编号", "ProdNo" },
                { "物品名称", "ProductName" },
                { "批次", "BatchNo" },
                { "规格", "Specification" },
                { "单位", "UnitName" },
                { "调拨单价", "TranPrice" },
                { "调拨数量 ", "TranCount" },
                { "调拨金额 ", "TranPriceTotal" },
                { "已出库数量 ", "OutCount" },
                { "已入库数量 ", "InCount" },
                { "备注 ", "Remark" },
            }
        }
        ;
        else
        {
            aDetail = new string[, ] {
                { "序号", "SortNo" },
                { "物品编号", "ProdNo" },
                { "物品名称", "ProductName" },
                { "批次", "BatchNo" },
                { "规格", "Specification" },
                { "基本单位", "UnitName" },
                { "基本数量", "TranCount" },
                { "单位", "UsedUnitName" },
                { "调拨单价", "TranPrice" },
                { "调拨数量 ", "UsedUnitCount" },
                { "调拨金额 ", "TranPriceTotal" },
                { "已出库数量 ", "OutCount" },
                { "已入库数量 ", "InCount" },
                { "备注 ", "Remark" },
            }
        };



        #region 1.扩展属性
        int       countExt   = 0;
        DataTable dtExtTable = XBase.Business.Office.SupplyChain.TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.StorageTransfer");
        if (dtExtTable.Rows.Count > 0)
        {
            for (int i = 0; i < dtExtTable.Rows.Count; i++)
            {
                for (int x = 0; x < (aBase.Length / 2) - 15; x++)
                {
                    if (x == i)
                    {
                        aBase[x, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
                        countExt++;
                    }
                }
            }
        }
        #endregion
        string    No      = Request.QueryString["No"].ToString();
        DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);

        XBase.Model.Office.StorageManager.StorageTransfer st = new XBase.Model.Office.StorageManager.StorageTransfer();
        st.ID = intMrpID;
        XBase.Model.Office.StorageManager.StorageTransferDetail std = new XBase.Model.Office.StorageManager.StorageTransferDetail();
        std.CompanyCD  = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        std.TransferNo = No;
        /*读取数据*/
        DataTable dtMRP           = XBase.Business.Office.StorageManager.StorageTransferBus.GetStorageTransferInfoPrint(st);
        DataTable dtDetail        = XBase.Business.Office.StorageManager.StorageTransferBus.GetStorageTransferDetailInfo(std);
        string    strBaseFields   = "";
        string    strDetailFields = "";


        if (dbPrint.Rows.Count > 0)
        {
            #region 设置过打印模板设置时 直接取出表里设置的值
            isSeted.Value   = "1";
            strBaseFields   = dbPrint.Rows[0]["BaseFields"].ToString();
            strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
            #endregion
        }
        else
        {
            #region 未设置过打印模板设置 默认显示所有的
            isSeted.Value = "0";

            /*未设置过打印模板设置时,默认显示的字段  基本信息字段*/
            for (int m = 10; m < aBase.Length / 2; m++)
            {
                strBaseFields = strBaseFields + aBase[m, 1] + "|";
            }
            /*未设置过打印模板设置时,默认显示的字段 基本信息字段+扩展信息字段*/
            if (countExt > 0)
            {
                for (int i = 0; i < countExt; i++)
                {
                    strBaseFields = strBaseFields + "ExtField" + (i + 1) + "|";
                }
            }
            /*未设置过打印模板设置时,默认显示的字段 明细信息字段*/
            for (int n = 0; n < aDetail.Length / 2; n++)
            {
                strDetailFields = strDetailFields + aDetail[n, 1] + "|";
            }
            #endregion
        }

        #region 2.主表信息
        if (!string.IsNullOrEmpty(strBaseFields))
        {
            tableBase.InnerHtml = WritePrintPageTable("库存调拨单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMRP, dtDetail, true);
        }
        #endregion

        #region 3.明细信息
        if (!string.IsNullOrEmpty(strDetailFields))
        {
            tableDetail.InnerHtml = WritePrintPageTable("库存调拨单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMRP, dtDetail, false);
        }
        #endregion
    }