예제 #1
0
 /// <summary>
 /// 根据输入的LOT格式来保存多条数据到数据库
 /// </summary>
 /// <param name="e">传入的带有数据的事件参数</param>
 /// <param name="procName">当前部门名称</param>
 /// <returns></returns>
 private bool InsertData(FormViewInsertEventArgs e, string procName)
 {
     //日期
     DateTime billDate = Convert.ToDateTime(e.Values["bill_date"]);
     //单号
     string billNum = Convert.ToString(e.Values["bill_num"]);
     //单据备注
     string billRemark = Convert.ToString(e.Values["remark"]);
     //录入员
     string addPerson = e.Values["add_person"].ToString();
     //录入时间
     DateTime addTime = Convert.ToDateTime(e.Values["add_time"]);
     //最后修改时间
     DateTime lastChangeTime = Convert.ToDateTime(e.Values["last_change_time"]);
     //数据适配器
     //当前添加语句对象
     //当前数据库连接
     using (var daHead = new t_complete_lot_card_back_headTableAdapter())
     using (var daContent = new t_complete_lot_card_back_contentTableAdapter())
     using (var daBalance = new t_complete_lot_card_balanceTableAdapter())
     using (var conn = daHead.Connection)
     {
         //打开数据库连接
         conn.Open();
         //开启事务
         using (var tran = conn.BeginTransaction())
         {
             //设置数据库连接对象
             daContent.Connection = daBalance.Connection = conn;
             //设置事务
             daHead.Transaction = daContent.Transaction = daBalance.Transaction = tran;
             //试运行
             try
             {
                 //保存表头
                 daHead.Insert(
                     billDate,
                     billNum,
                     procName,
                     billRemark,
                     addPerson,
                     addTime,
                     lastChangeTime
                 );
                 //遍历子表执行保存
                 for (int iRow = 0; iRow < 10; iRow++)
                 {
                     //子表各控件
                     var tr = tabDataListSon.Rows[iRow + 1];
                     var litRowId = (Literal)tr.Cells[0].Controls[0];
                     var txtPrevProcName = (TextBox)tr.Cells[1].Controls[0];
                     var txtLotId = (TextBox)tr.Cells[2].Controls[0];
                     var txtProductNum = (TextBox)tr.Cells[3].Controls[0];
                     var txtPnlQty = (TextBox)tr.Cells[4].Controls[0];
                     var txtPcsQty = (TextBox)tr.Cells[5].Controls[0];
                     var txtRemark = (TextBox)tr.Cells[6].Controls[0];
                     //取得数据
                     byte rowId = Convert.ToByte(litRowId.Text);
                     string prevProcName = txtPrevProcName.Text;
                     string lotId = txtLotId.Text;
                     string productNum = txtProductNum.Text;
                     int pnlQty = txtPnlQty.Text.Trim().Length <= 0 ? 0 : int.Parse(txtPnlQty.Text.Trim());
                     int pcsQty = txtPcsQty.Text.Trim().Length <= 0 ? 0 : int.Parse(txtPcsQty.Text.Trim());
                     string remark = txtRemark.Text;
                     //存在数据才保存
                     if (lotId.Length > 0 && productNum.Length > 0 && pnlQty + pcsQty > 0)
                     {
                         //保存到单据内容清单
                         daContent.Insert(
                             billNum,
                             rowId,
                             prevProcName,
                             lotId,
                             productNum,
                             pnlQty,
                             pcsQty,
                             remark
                         );
                         //保存到成品结存清单
                         daBalance.InsertData(
                             prevProcName,
                             procName,
                             lotId,
                             productNum,
                             pnlQty,
                             pcsQty,
                             "成品盘亏单写回" + (remark.Length <= 0 ? string.Empty : ":" + remark),
                             addPerson
                         );
                     }
                 }
                 //提交事务
                 tran.Commit();
                 //返回成功
                 return true;
             }
             catch (Exception ex)
             {
                 //回滚事务
                 tran.Rollback();
                 //非数字返回失败
                 throw new Exception(ex.Message);
             }
         }
     }
 }
예제 #2
0
        /// <summary>
        /// 根据输入的参数值来执行更新数据
        /// </summary>
        /// <param name="e">传入的带有数据的事件参数</param>
        /// <returns></returns>
        private bool UpdateData(FormViewUpdateEventArgs e)
        {
            //数据适配器
            //当前添加语句对象
            //当前数据库连接
            using (var da = new v_complete_lot_card_backTableAdapter())
            using (var conn = da.Connection)
            {
                //打开数据库连接
                conn.Open();
                //开启事务
                using (var tran = conn.BeginTransaction())
                {
                    //设置事务
                    da.Transaction = tran;
                    //试运行
                    try
                    {
                        //部门名称
                        string procName = e.OldValues["proc_name"].ToString();
                        //当前行单号
                        string billNum = Convert.ToString(e.Keys[0]);
                        //获取数据
                        using (var tab = da.GetDataByBillNum(billNum))
                        {
                            //检查是否获取到行
                            if (tab.Rows.Count == 0)
                            {
                                //显示失败
                                throw new Exception("当前记录已经被其他用户删除!");
                            }
                            //数据适配器
                            using (var daHead = new t_complete_lot_card_back_headTableAdapter())
                            using (var daContent = new t_complete_lot_card_back_contentTableAdapter())
                            using (var daBalance = new t_complete_lot_card_balanceTableAdapter())
                            {
                                //设置数据库连接
                                daHead.Connection = daContent.Connection = daBalance.Connection = conn;
                                //设置事务
                                daHead.Transaction = daContent.Transaction = daBalance.Transaction = tran;
                                //将之前的单据内容写回
                                foreach (DataSetCompleteBack.v_complete_lot_card_backRow row in tab.Rows)
                                {
                                    //从成品结存清单中扣除
                                    if (!ydOperateCompleteLotCard.DecreaseCompleteBalance(
                                        daBalance,
                                        row.prev_proc_name,
                                        row.lot_id,
                                        row.pnl_qty,
                                        row.pcs_qty
                                    ))
                                    {
                                        return false;
                                    }
                                }
                                //从单据内容中删除
                                daContent.DeleteByBillNum(billNum);
                                //从单据表头中删除
                                daHead.Delete(billNum);

                                //日期
                                DateTime billDate = Convert.ToDateTime(e.NewValues["bill_date"]);
                                //单据备注
                                string billRemark = Convert.ToString(e.NewValues["remark"]);
                                //录入员
                                string addPerson = e.NewValues["add_person"].ToString();
                                //录入时间
                                DateTime addTime = Convert.ToDateTime(e.NewValues["add_time"]);
                                //最后修改时间
                                DateTime lastChangeTime = Convert.ToDateTime(e.NewValues["last_change_time"]);
                                //保存表头
                                daHead.Insert(
                                    billDate,
                                    billNum,
                                    procName,
                                    billRemark,
                                    addPerson,
                                    addTime,
                                    lastChangeTime
                                );
                                //遍历子表执行保存
                                for (int iRow = 0; iRow < 10; iRow++)
                                {
                                    //子表各控件
                                    var tr = tabDataListSon.Rows[iRow + 1];
                                    var litRowId = (Literal)tr.Cells[0].Controls[0];
                                    var txtPrevProcName = (TextBox)tr.Cells[1].Controls[0];
                                    var txtLotId = (TextBox)tr.Cells[2].Controls[0];
                                    var txtProductNum = (TextBox)tr.Cells[3].Controls[0];
                                    var txtPnlQty = (TextBox)tr.Cells[4].Controls[0];
                                    var txtPcsQty = (TextBox)tr.Cells[5].Controls[0];
                                    var txtRemark = (TextBox)tr.Cells[6].Controls[0];
                                    //取得数据
                                    byte rowId = Convert.ToByte(litRowId.Text);
                                    string prevProcName = txtPrevProcName.Text;
                                    string lotId = txtLotId.Text;
                                    string productNum = txtProductNum.Text;
                                    int pnlQty = txtPnlQty.Text.Trim().Length <= 0 ? 0 : int.Parse(txtPnlQty.Text.Trim());
                                    int pcsQty = txtPcsQty.Text.Trim().Length <= 0 ? 0 : int.Parse(txtPcsQty.Text.Trim());
                                    string remark = txtRemark.Text;
                                    //存在数据才保存
                                    if (lotId.Length > 0 && productNum.Length > 0 && pnlQty + pcsQty > 0)
                                    {
                                        //保存到单据内容清单
                                        daContent.Insert(
                                            billNum,
                                            rowId,
                                            prevProcName,
                                            lotId,
                                            productNum,
                                            pnlQty,
                                            pcsQty,
                                            remark
                                        );
                                        //保存到成品结存清单
                                        daBalance.InsertData(
                                            prevProcName,
                                            procName,
                                            lotId,
                                            productNum,
                                            pnlQty,
                                            pcsQty,
                                            "成品盘亏单写回" + (remark.Length <= 0 ? string.Empty : ":" + remark),
                                            addPerson
                                        );
                                    }
                                }
                            }
                        }
                        //提交事务
                        tran.Commit();
                        //返回成功
                        return true;
                    }
                    catch (Exception ex)
                    {
                        //回滚事务
                        tran.Rollback();
                        //非数字返回失败
                        throw new Exception(ex.Message);
                    }
                }
            }
        }
예제 #3
0
 /// <summary>
 /// 根据单号从数据库中删除单据的表头和内容
 /// </summary>
 /// <param name="billNum">单据号</param>
 private bool DeleteBillByBillNum(string billNum)
 {
     //实例化数据适配器
     using (var da = new v_complete_lot_card_outTableAdapter())
     //取得数据库连接
     using (var conn = da.Connection)
     {
         //打开数据库连接
         conn.Open();
         //事务
         using (var tran = conn.BeginTransaction())
         {
             //设置事务
             da.Transaction = tran;
             try
             {
                 //取得之前出库单清单记录
                 var tab = da.GetDataByBillNum(billNum);
                 //检测是否存在数据
                 if (tab.Rows.Count >= 0)
                 {
                     //单据表头行、内容行、成品结存和已入库结存数据适配器
                     using (var daHead = new t_complete_lot_card_out_headTableAdapter())
                     using (var daContent = new t_complete_lot_card_out_contentTableAdapter())
                     using (var daBalance = new t_complete_lot_card_balanceTableAdapter())
                     {
                         //设置连接对象
                         daHead.Connection = daContent.Connection = daBalance.Connection = tran.Connection;
                         //设置事务
                         daHead.Transaction = daContent.Transaction = daBalance.Transaction = tran;
                         //遍历行执行删除各行的结存记录和写回已入库结存记录
                         foreach (DataSetCompleteOut.v_complete_lot_card_outRow row in tab.Rows)
                         {
                             //检测是否超过原下部门余数
                             if (ydOperateBalanceLotCrad.IsOutstripDeptBalance(
                                 tran,
                                 row.dept_name,
                                 row.next_dept_name,
                                 row.lot_id,
                                 row.pnl_qty,
                                 row.pcs_qty,
                                 true
                             ))
                             {
                                 return false;
                             }
                             //修改原下部门lot卡余数
                             if (!ydOperateBalanceLotCrad.UpdateBalanceAfterInsert(
                                 tran,
                                 row.dept_name,
                                 row.next_dept_name,
                                 row.lot_id,
                                 row.pnl_qty,
                                 row.pcs_qty,
                                 true
                             ))
                             {
                                 return false;
                             }
                             //执行插入到成品结存清单
                             daBalance.InsertData(
                                 row.prev_dept_name,
                                 row.dept_name,
                                 row.lot_id,
                                 row.product_num,
                                 row.pnl_qty,
                                 row.pcs_qty,
                                 "出库单写回" + (row.IsremarkNull() ? string.Empty : ":" + row.remark),
                                 Session["user_name"].ToString()
                             );
                         }
                         //根据出库单号删除全部出库内容记录
                         daContent.DeleteByBillNum(billNum);
                         //根据出库单号删除全部出库表头记录
                         daHead.Delete(billNum);
                     }
                 }
                 //提交事务
                 tran.Commit();
                 //返回成功
                 return true;
             }
             catch (Exception ex)
             {
                 //回滚事务
                 tran.Rollback();
                 //抛出错误
                 throw new Exception("删除出库单记录出现错误:\n" + ex.Message);
             }
         }
     }
 }
예제 #4
0
 /// <summary>
 /// 执行删除数据并处理相关数据一致性
 /// </summary>
 /// <param name="e">传入的带有数据的事件参数</param>
 /// <returns></returns>
 private bool DeleteData(FormViewDeleteEventArgs e)
 {
     //当前单号
     string billNum = Convert.ToString(e.Keys[0]);
     //数据适配器
     //当前数据库连接
     //当前更新语句对象
     using (var da = new v_complete_lot_card_backTableAdapter())
     using (var conn = da.Connection)
     {
         //打开数据库连接
         conn.Open();
         //开启事务
         using (var tran = conn.BeginTransaction())
         {
             //试运行
             try
             {
                 //设置事务
                 da.Transaction = tran;
                 //获取数据
                 var tab = da.GetDataByBillNum(billNum);
                 //检查是否获取到行
                 if (tab.Rows.Count == 0)
                 {
                     //显示失败
                     throw new Exception("当前记录已经被其他用户删除!");
                 }
                 //数据适配器
                 using (var daHead = new t_complete_lot_card_back_headTableAdapter())
                 using (var daContent = new t_complete_lot_card_back_contentTableAdapter())
                 using (var daBalance = new t_complete_lot_card_balanceTableAdapter())
                 {
                     //设置数据库连接
                     daHead.Connection = daContent.Connection = daBalance.Connection = conn;
                     //设置事务
                     daHead.Transaction = daContent.Transaction = daBalance.Transaction = tran;
                     //将之前的单据内容写回
                     foreach (DataSetCompleteBack.v_complete_lot_card_backRow row in tab.Rows)
                     {
                         //从成品结存清单中扣除
                         if (ydOperateCompleteLotCard.DecreaseCompleteBalance(
                             daBalance,
                             row.prev_proc_name,
                             row.lot_id,
                             row.pnl_qty,
                             row.pcs_qty
                         ))
                         {
                             return false;
                         }
                     }
                     //从单据内容中删除
                     daContent.DeleteByBillNum(billNum);
                     //从单据表头中删除
                     daHead.Delete(billNum);
                 }
                 //提交事务
                 tran.Commit();
                 //返回成功
                 return true;
             }
             catch (Exception ex)
             {
                 //回滚事务
                 tran.Rollback();
                 //非数字返回失败
                 throw new Exception(ex.Message);
             }
         }
     }
 }
예제 #5
0
 /// <summary>
 /// 根据单号从数据库中删除单据的表头和内容
 /// </summary>
 /// <param name="billNum">单据号</param>
 private bool DeleteBillByBillNum(string billNum)
 {
     //实例化数据适配器
     using (var da = new v_complete_lot_card_backTableAdapter())
     //取得数据库连接
     using (var conn = da.Connection)
     {
         //打开数据库连接
         conn.Open();
         //事务
         using (var tran = conn.BeginTransaction())
         {
             //设置事务
             da.Transaction = tran;
             try
             {
                 //取得之前盘盈单清单记录
                 var tab = da.GetDataByBillNum(billNum);
                 //检测是否存在数据
                 if (tab.Rows.Count > 0)
                 {
                     //单据表头行、内容行、成品结存和待盘盈数据适配器
                     using (var daHead = new t_complete_lot_card_back_headTableAdapter())
                     using (var daContent = new t_complete_lot_card_back_contentTableAdapter())
                     using (var daBalance = new t_complete_lot_card_balanceTableAdapter())
                     {
                         //设置连接对象
                         daHead.Connection = daContent.Connection = daBalance.Connection = tran.Connection;
                         //设置事务
                         daHead.Transaction = daContent.Transaction = daBalance.Transaction = tran;
                         //遍历行执行删除各行的结存记录
                         foreach (DataSetCompleteBack.v_complete_lot_card_backRow row in tab.Rows)
                         {
                             //执行扣减结存
                             ydOperateCompleteLotCard.DecreaseCompleteBalance(
                                 daBalance,
                                 row.prev_proc_name,
                                 row.lot_id,
                                 row.pnl_qty,
                                 row.pcs_qty
                             );
                         }
                         //根据盘盈单号删除全部盘盈内容记录
                         daContent.DeleteByBillNum(billNum);
                         //根据盘盈单号删除全部盘盈表头记录
                         daHead.Delete(billNum);
                     }
                 }
                 //提交事务
                 tran.Commit();
                 //返回成功
                 return true;
             }
             catch (Exception ex)
             {
                 //回滚事务
                 tran.Rollback();
                 //抛出错误
                 throw new Exception("删除成品盘盈单记录出现错误:\n" + ex.Message);
             }
         }
     }
 }
예제 #6
0
 /// <summary>
 /// 执行删除数据并处理相关数据一致性
 /// </summary>
 /// <param name="e">传入的带有数据的事件参数</param>
 /// <returns></returns>
 private bool DeleteData(ListViewDeleteEventArgs e)
 {
     //实例化数据适配器
     using (var da = new v_complete_lot_card_outTableAdapter())
     //取得数据库连接
     using (var conn = da.Connection)
     {
         //打开数据库连接
         conn.Open();
         //事务
         using (var tran = conn.BeginTransaction())
         {
             //设置事务
             da.Transaction = tran;
             try
             {
                 //当前出库单号
                 string billNum = e.Keys[0].ToString();
                 //当前行号
                 byte rowId = Convert.ToByte(e.Keys[1]);
                 //取得该条出库单清单记录
                 var tab = da.GetDataByBillNumAndRowId(billNum, rowId);
                 //检测是否存在数据
                 if (tab.Rows.Count <= 0)
                 {
                     throw new Exception(
                         string.Format(
                             "当前单据:\n单号:{0}\n行号:{1}\n已经被其他用户删除!",
                             billNum,
                             rowId
                         )
                     );
                 }
                 //单据内容、成品结存和已入库结存数据适配器
                 using (var daContent = new t_complete_lot_card_out_contentTableAdapter())
                 using (var daBalance = new t_complete_lot_card_balanceTableAdapter())
                 {
                     //设置连接对象
                     daContent.Connection = daBalance.Connection = tran.Connection;
                     //设置事务
                     daContent.Transaction = daBalance.Transaction = tran;
                     //遍历行执行删除各行的结存记录和写回已入库结存记录
                     foreach (DataSetCompleteOut.v_complete_lot_card_outRow row in tab.Rows)
                     {
                         //检测是否超过原下部门余数
                         if (ydOperateBalanceLotCrad.IsOutstripDeptBalance(
                             tran,
                             row.dept_name,
                             row.next_dept_name,
                             row.lot_id,
                             row.pnl_qty,
                             row.pcs_qty,
                             true
                         ))
                         {
                             return false;
                         }
                         //修改原下部门lot卡余数
                         if (!ydOperateBalanceLotCrad.UpdateBalanceAfterInsert(
                             tran,
                             row.dept_name,
                             row.next_dept_name,
                             row.lot_id,
                             row.pnl_qty,
                             row.pcs_qty,
                             true
                         ))
                         {
                             return false;
                         }
                         //执行插入到成品结存清单
                         daBalance.InsertData(
                             row.prev_dept_name,
                             row.dept_name,
                             row.lot_id,
                             row.product_num,
                             row.pnl_qty,
                             row.pcs_qty,
                             "出库单写回" + (row.IsremarkNull() ? string.Empty : ":" + row.remark),
                             Session["user_name"].ToString()
                         );
                     }
                     //根据出库单号和行号删除出库记录
                     daContent.Delete(billNum, rowId);
                     //检测当前出库记录内容行数
                     int? iCount = (int?)daContent.CountByBillNum(billNum);
                     if (iCount.HasValue && iCount.Value <= 0)
                     {
                         //表头适配器
                         using (var daHead = new t_complete_lot_card_out_headTableAdapter())
                         {
                             //删除表头
                             daHead.Delete(billNum);
                         }
                     }
                 }
                 //提交事务
                 tran.Commit();
                 //返回成功
                 return true;
             }
             catch (Exception ex)
             {
                 //回滚事务
                 tran.Rollback();
                 //抛出错误
                 throw new Exception("删除出库单记录出现错误:\n" + ex.Message);
             }
         }
     }
 }
        public void ProcessRequest(HttpContext context)
        {
            //清空之前数据
            context.Response.Clear();
            //检测是否含有session
            if (context.Session.Count < 5)
            {
                //跳转
                context.Response.Redirect("/Account/Login", true);
                //停止加载后续内容
                context.Response.End();
                //直接返回
                return;
            }
            //执行基类的方法
            if (!base.CheckIsLogin(context))
            {
                return;
            }
            //用户传入的参数
            string prevDeptName = context.Request["pdept"];
            //检测参数
            if (prevDeptName == null || prevDeptName.Trim().Length <= 0)
            {
                prevDeptName = "%";
            }
            //当前使用的查询表的类型
            var parTable = ParameterTable.None;
            //用户传入的参数
            string tabType = context.Request["ttype"];
            //转换后的结果
            int iType;
            //检测参数
            if (tabType == null || tabType.Trim().Length <= 0
                || !int.TryParse(tabType, out iType) || iType < 1 || iType > 4
            )
            {
                return;
            }
            //设置tab的值得
            parTable = (ParameterTable)iType;

            //当前使用的查询参数类型
            var parField = ParameterField.None;
            //用户传入的参数
            string lotId = context.Request["lid"];
            string productNum = string.Empty;
            //检测lot卡号
            if (lotId != null && lotId.Length > 0)
            {
                //查询字段类型为生产编号
                parField = ParameterField.LotId;
                //去掉空格
                lotId = lotId.Trim();
                //检测lot卡号重新设置参数值
                if (!lotId.Contains("-"))
                {
                    //添加减号
                    lotId = "-" + lotId;
                }
                //使用模糊查询
                lotId = "%" + lotId + "%";
            }
            else
            {
                //用户传入的生产编号
                productNum = context.Request["pnum"];
                if (productNum != null && productNum.Length > 0)
                {
                    //查询字段类型为生产编号
                    parField = ParameterField.ProductNum;
                    //设置参数值
                    productNum = "%" + productNum.Trim() + "%";
                }
            }
            //当前未使用特定的三种字段类型之一进行查询则不输出值直接退出
            if (parField == ParameterField.None)
            {
                return;
            }

            //待输出到浏览器的数据
            string strResult = string.Empty;
            //将查询到的结果保存到泛型变量中
            var l = new List<LotCardLiItem>();
            //检测查询表的类型
            switch (parTable)
            {
                //在待入库记录中查询
                case ParameterTable.Wait:
                    //数据适配器
                    using (var da = new t_complete_lot_card_waitTableAdapter())
                    {
                        //获取数据使用的表
                        DataSetCompleteWait.t_complete_lot_card_waitDataTable tab;
                        //通过lot卡号查询
                        if (parField == ParameterField.LotId)
                        {
                            //取得数据
                            tab = da.GetDataLikePrevDeptAndLotId(prevDeptName, lotId);
                        }
                        //通过生产编号查询
                        else
                        {
                            //取得数据
                            tab = da.GetDataLikePrevDeptAndProductNum(prevDeptName, productNum);
                        }
                        //获取单据数据
                        AddLotCardListItem(tab, ref l);
                    }
                    //退出switch
                    break;
                case ParameterTable.Balance:
                    //数据适配器
                    using (var da = new t_complete_lot_card_balanceTableAdapter())
                    {
                        //获取数据使用的表
                        DataSetCompleteBalance.t_complete_lot_card_balanceDataTable tab;
                        //通过lot卡号查询
                        if (parField == ParameterField.LotId)
                        {
                            //取得数据
                            tab = da.GetDataLikePrevDeptAndLotId(prevDeptName, lotId);
                        }
                        //通过生产编号查询
                        else
                        {
                            //取得数据
                            tab = da.GetDataLikePrevDeptAndProductNum(prevDeptName, productNum);
                        }
                        //获取单据数据
                        AddLotCardListItem(tab, ref l);
                    }
                    //退出switch
                    break;
                case ParameterTable.Lose:
                    //数据适配器
                    using (var da = new v_complete_lot_card_loseTableAdapter())
                    {
                        //获取数据使用的表
                        DataSetCompleteLose.v_complete_lot_card_loseDataTable tab;
                        //通过lot卡号查询
                        if (parField == ParameterField.LotId)
                        {
                            //取得数据
                            tab = da.GetDataLikePrevDeptAndLotId(prevDeptName, lotId);
                        }
                        //通过生产编号查询
                        else
                        {
                            //取得数据
                            tab = da.GetDataLikePrevDeptAndProductNum(prevDeptName, productNum);
                        }
                        //获取单据数据
                        AddLotCardListItem(tab, ref l);
                    }
                    //退出switch
                    break;
            }
            //如果在清单中查询到数据
            if (l.Count > 0)
            {
                //将泛型变量各项目放入数组
                var itms = new LotCardLiItem[l.Count];
                //复制泛型变量的内容到数组
                l.CopyTo(itms);
                //循环重新设置单只数
                foreach (var itm in itms)
                {
                    //将实例加入li
                    strResult += itm.ToString();
                }
            }
            //加入ul头尾
            strResult = "<ul>\n" + strResult + "</ul>\n";
            //写入数据
            context.Response.Write(strResult);
        }
예제 #8
0
 /// <summary>
 /// 执行删除数据并处理相关数据一致性
 /// </summary>
 /// <param name="e">传入的带有数据的事件参数</param>
 /// <returns></returns>
 private bool DeleteData(ListViewDeleteEventArgs e)
 {
     //实例化数据适配器
     using (var da = new v_complete_lot_card_backTableAdapter())
     //取得数据库连接
     using (var conn = da.Connection)
     {
         //打开数据库连接
         conn.Open();
         //事务
         using (var tran = conn.BeginTransaction())
         {
             //设置事务
             da.Transaction = tran;
             try
             {
                 //当前盘盈单号
                 string billNum = e.Keys[0].ToString();
                 //当前行号
                 byte rowId = Convert.ToByte(e.Keys[1]);
                 //取得该条盘盈单清单记录
                 var tab = da.GetDataByBillNumAndRowId(billNum, rowId);
                 //检测是否存在数据
                 if (tab.Rows.Count <= 0)
                 {
                     throw new Exception(string.Format("当前单据:\n单号:{0}\n行号:{1}\n已经被其他用户删除!", billNum, rowId));
                 }
                 //单据内容、成品结存和待盘盈数据适配器
                 using (var daContent = new t_complete_lot_card_back_contentTableAdapter())
                 using (var daBalance = new t_complete_lot_card_balanceTableAdapter())
                 {
                     //设置连接对象
                     daContent.Connection = daBalance.Connection = tran.Connection;
                     //设置事务
                     daContent.Transaction = daBalance.Transaction = tran;
                     //遍历行执行删除各行的结存记录
                     foreach (DataSetCompleteBack.v_complete_lot_card_backRow row in tab.Rows)
                     {
                         //执行扣减结存
                         ydOperateCompleteLotCard.DecreaseCompleteBalance(
                             daBalance,
                             row.prev_proc_name,
                             row.lot_id,
                             row.pnl_qty,
                             row.pcs_qty
                         );
                     }
                     //根据盘盈单号和行号删除盘盈记录
                     daContent.Delete(billNum, rowId);
                     //检测当前盘盈记录内容行数
                     int? iCount = daContent.CountByBillNum(billNum);
                     if (iCount.HasValue && iCount.Value <= 0)
                     {
                         //表头适配器
                         using (var daHead = new t_complete_lot_card_back_headTableAdapter())
                         {
                             //删除表头
                             daHead.Delete(billNum);
                         }
                     }
                 }
                 //提交事务
                 tran.Commit();
                 //返回成功
                 return true;
             }
             catch (Exception ex)
             {
                 //回滚事务
                 tran.Rollback();
                 //抛出错误
                 throw new Exception("删除成品盘盈单记录出现错误:\n" + ex.Message);
             }
         }
     }
 }
예제 #9
0
 /// <summary>
 /// 执行递归扣取结存数据
 /// </summary>
 /// <param name="daBalance">操作结存表的数据适配器</param>
 /// <param name="prevProcName">上部门名称</param>
 /// <param name="lotId">批量卡序号</param>
 /// <param name="pnlQty">pnl数量</param>
 /// <param name="pcsQty">pcs数量</param>
 /// <returns></returns>
 internal static bool DecreaseCompleteBalance(
     t_complete_lot_card_balanceTableAdapter daBalance,
     string prevProcName,
     string lotId,
     int pnlQty,
     int pcsQty
 )
 {
     try
     {
         //检测是否数量不正确
         if (pnlQty < 0 || pcsQty < 0)
         {
             throw new Exception("待扣减的pnl数量和pcs数量不能同时小于0!");
         }
         if (pnlQty > 0 && pcsQty > 0)
         {
             throw new Exception("待扣减的pnl数量和pcs数量不能同时大于0!");
         }
         if (pnlQty + pcsQty <= 0)
         {
             throw new Exception("待扣减的pnl数量和pcs数量不能同时为0!");
         }
         //扣减后剩余数量
         object iQty;
         //执行扣取已入库批量卡余数
         if (pnlQty > 0)
         {
             //扣减后剩余数量
             iQty = UpdateBalancePnlQtyByPrevProcAndLotId(
                 daBalance.Transaction,
                 prevProcName,
                 lotId,
                 pnlQty
            );
         }
         else
         {
             //扣减后剩余数量
             iQty = UpdateBalancePcsQtyByPrevProcAndLotId(
                 daBalance.Transaction,
                 prevProcName,
                 lotId,
                 pcsQty
             );
         }
         //检测扣数是否成功
         if (iQty == null || iQty == DBNull.Value)
         {
             throw new Exception("成品结存不够扣数!");
         }
         //检测返回的结果
         int qty;
         if (!int.TryParse(iQty.ToString(), out qty))
         {
             throw new Exception("成品结存扣数后的返回值不是正确的整数!");
         }
         //检测是否需要递归扣数
         if (qty < 0)
         {
             //重设待扣减数量
             pnlQty = pnlQty > 0 ? -qty : 0;
             pcsQty = pnlQty > 0 ? 0 : -qty;
             //执行递归扣减
             if (!DecreaseCompleteBalance(
                 daBalance,
                 prevProcName,
                 lotId,
                 pnlQty,
                 pcsQty
             ))
             {
                 return false;
             };
         }
         else
         {
             //删除小于或等于0的记录清单
             daBalance.DeleteEmptyData();
         }
         //返回成功
         return true;
     }
     catch (Exception ex)
     {
         //抛出错误
         throw new Exception("执行扣减成品结存数时发生错误:\n" + ex.Message);
     }
 }
예제 #10
0
 /// <summary>
 /// 根据单号从数据库中删除单据的表头和内容
 /// </summary>
 /// <param name="billNum">单据号</param>
 private bool DeleteBillByBillNum(string billNum)
 {
     //实例化数据适配器
     using (var da = new v_complete_lot_card_loseTableAdapter())
     //取得数据库连接
     using (var conn = da.Connection)
     {
         //打开数据库连接
         conn.Open();
         //事务
         using (var tran = conn.BeginTransaction())
         {
             //设置事务
             da.Transaction = tran;
             try
             {
                 //取得之前盘亏单清单记录
                 var tab = da.GetDataByBillNum(billNum);
                 //检测是否存在数据
                 if (tab.Rows.Count > 0)
                 {
                     //单据表头行、内容行、成品结存和已入库结存数据适配器
                     using (var daHead = new t_complete_lot_card_lose_headTableAdapter())
                     using (var daContent = new t_complete_lot_card_lose_contentTableAdapter())
                     using (var daBalance = new t_complete_lot_card_balanceTableAdapter())
                     {
                         //设置连接对象
                         daHead.Connection = daContent.Connection = daBalance.Connection = tran.Connection;
                         //设置事务
                         daHead.Transaction = daContent.Transaction = daBalance.Transaction = tran;
                         //遍历行执行删除各行的结存记录和写回已入库结存记录
                         foreach (DataSetCompleteLose.v_complete_lot_card_loseRow row in tab.Rows)
                         {
                             //执行插入到成品结存清单
                             daBalance.InsertData(
                                 row.prev_proc_name,
                                 row.proc_name,
                                 row.lot_id,
                                 row.product_num,
                                 row.pnl_qty,
                                 row.pcs_qty,
                                 "成品盘亏单写回" + (row.IsremarkNull() ? string.Empty : ":" + row.remark),
                                 Session["user_name"].ToString()
                             );
                         }
                         //根据盘亏单号删除全部盘亏内容记录
                         daContent.DeleteByBillNum(billNum);
                         //根据盘亏单号删除全部盘亏表头记录
                         daHead.Delete(billNum);
                     }
                 }
                 //提交事务
                 tran.Commit();
                 //返回成功
                 return true;
             }
             catch (Exception ex)
             {
                 //回滚事务
                 tran.Rollback();
                 //抛出错误
                 throw new Exception("删除成品盘亏单记录出现错误:\n" + ex.Message);
             }
         }
     }
 }
예제 #11
0
 /// <summary>
 /// 执行删除数据并处理相关数据一致性
 /// </summary>
 /// <param name="e">传入的带有数据的事件参数</param>
 /// <returns></returns>
 private bool DeleteData(FormViewDeleteEventArgs e)
 {
     //当前单号
     string billNum = Convert.ToString(e.Keys[0]);
     //数据适配器
     //当前数据库连接
     //当前更新语句对象
     using (var da = new v_complete_lot_card_outTableAdapter())
     using (var conn = da.Connection)
     {
         //打开数据库连接
         conn.Open();
         //开启事务
         using (var tran = conn.BeginTransaction())
         {
             //试运行
             try
             {
                 //设置事务
                 da.Transaction = tran;
                 //获取数据
                 var tab = da.GetDataByBillNum(billNum);
                 //检查是否获取到行
                 if (tab.Rows.Count == 0)
                 {
                     //显示失败
                     throw new Exception("当前记录已经被其他用户删除!");
                 }
                 //数据适配器
                 using (var daHead = new t_complete_lot_card_out_headTableAdapter())
                 using (var daContent = new t_complete_lot_card_out_contentTableAdapter())
                 using (var daBalance = new t_complete_lot_card_balanceTableAdapter())
                 {
                     //设置数据库连接
                     daHead.Connection = daContent.Connection = daBalance.Connection = conn;
                     //设置事务
                     daHead.Transaction = daContent.Transaction = daBalance.Transaction = tran;
                     //将之前的单据内容写回
                     foreach (DataSetCompleteOut.v_complete_lot_card_outRow row in tab.Rows)
                     {
                         //检测是否超过原下部门余数
                         if (ydOperateBalanceLotCrad.IsOutstripDeptBalance(
                             tran,
                             row.dept_name,
                             row.next_dept_name,
                             row.lot_id,
                             row.pnl_qty,
                             row.pcs_qty,
                             true
                         ))
                         {
                             return false;
                         }
                         //修改原下部门lot卡余数
                         if (!ydOperateBalanceLotCrad.UpdateBalanceAfterInsert(
                             tran,
                             row.dept_name,
                             row.next_dept_name,
                             row.lot_id,
                             row.pnl_qty,
                             row.pcs_qty,
                             true
                         ))
                         {
                             return false;
                         }
                         //执行插入到成品结存清单
                         daBalance.InsertData(
                             row.prev_dept_name,
                             row.dept_name,
                             row.lot_id,
                             row.product_num,
                             row.pnl_qty,
                             row.pcs_qty,
                             "出库单写回" + (row.IsremarkNull() ? string.Empty : ":" + row.remark),
                             Session["user_name"].ToString()
                         );
                     }
                     //从单据内容中删除
                     daContent.DeleteByBillNum(billNum);
                     //从单据表头中删除
                     daHead.Delete(billNum);
                 }
                 //提交事务
                 tran.Commit();
                 //返回成功
                 return true;
             }
             catch (Exception ex)
             {
                 //回滚事务
                 tran.Rollback();
                 //非数字返回失败
                 throw new Exception(ex.Message);
             }
         }
     }
 }
예제 #12
0
 protected void fvCompleteOutAdd_DataBound(object sender, EventArgs e)
 {
     //设置单据清单可见
     tabDataListSon.Visible = true;
     //清空出库单内容清单
     for (int i = 0; i < 10; i++)
     {
         //清空清单数据到控件
         ClearBillContent(i);
     }
     //新增状态
     switch (fvCompleteOutAdd.CurrentMode)
     {
         //新增状态
         case FormViewMode.Insert:
             //当前单号文本框
             var tb = (TextBox)fvCompleteOutAdd.FindControl("txtBillDate");
             if (tb != null)
             {
                 //检查用户提供的单据日期参数标识
                 string strBillDate = Request["bdate"];
                 DateTime billDate;
                 if (strBillDate != null && strBillDate.Length > 0 &&
                     DateTime.TryParse(strBillDate, out billDate))
                 {
                     //设置默认单据日期为传入的日期
                     tb.Text = billDate.ToString("yyyy-MM-dd");
                 }
                 else
                 {
                     //设置默认单据日期为当前日期
                     tb.Text = DateTime.Now.ToString("yyyy-MM-dd");
                 }
             }
             //当前单号文本框
             tb = (TextBox)fvCompleteOutAdd.FindControl("txtBillNum");
             if (tb != null)
             {
                 //户提供的单号参数标识
                 string strBillNum = Request["bnum"];
                 Int64 billNum;
                 if (strBillNum != null && strBillNum.Trim().Length >= 12 &&
                     Int64.TryParse(strBillNum, out billNum))
                 {
                     //设置默认单号为传入的单号加1
                     tb.Text = (billNum + 1).ToString();
                 }
                 else
                 {
                     //当前单号前缀字符串
                     string billNumPrefix = DateTime.Now.ToString("yyyyMMdd");
                     //数据适配器
                     using (var da = new t_complete_lot_card_out_headTableAdapter())
                     {
                         //获取已经使用的最大单号
                         string maxBillNum = da.GetMaxBillNumLikeBillNum(billNumPrefix + "%").ToString();
                         //检测取得的值
                         if (maxBillNum.Trim().Length < 12)
                         {
                             //执行转换
                             billNum = Int64.Parse(billNumPrefix + "0001");
                             //设置默认单号为传入的单号加1
                             tb.Text = billNum.ToString();
                         }
                         else
                         {
                             //执行转换
                             billNum = Int64.Parse(maxBillNum);
                             //设置默认单号为传入的单号加1
                             tb.Text = (billNum + 1).ToString();
                         }
                     }
                 }
             }
             //下部门名称文本框
             tb = (TextBox)fvCompleteOutAdd.FindControl("txtNextDeptName");
             if (tb != null)
             {
                 //检查用户提供的部门名称参数标识
                 string nextDept = Request["ndept"];
                 if (nextDept != null && nextDept.Length > 0)
                 {
                     //设置默认部门名称
                     tb.Text = nextDept;
                 }
                 else
                 {
                     //设置默认部门名称
                     tb.Text = "包装";
                 }
             }
             //当前部门名称
             var lit = (Literal)fvCompleteOutAdd.FindControl("litDeptName");
             if (lit != null)
             {
                 //session中保存的当前部门
                 string deptName = Session["dept_name"].ToString();
                 //写入到客户端
                 lit.Text = deptName;
             }
             //获取是否传入了多个已入库结存表的id值
             string strIdAll = Request["ids"];
             if (strIdAll != null && strIdAll.Trim().Length > 0)
             {
                 //分解出id号
                 string[] strIds = strIdAll.Split(new char[] { '|' }, 10, StringSplitOptions.RemoveEmptyEntries);
                 //检测id号数量
                 if (strIds.Length > 0)
                 {
                     //已入库结存表数据适配器
                     using (var da = new t_complete_lot_card_balanceTableAdapter())
                     {
                         //当前子表行索引
                         int iRow = 0;
                         //逐行获取数据
                         foreach (var strId in strIds)
                         {
                             //检测id
                             Int64 id;
                             if (Int64.TryParse(strId, out id))
                             {
                                 //取得数据
                                 var tab = da.GetDataById(id);
                                 //检测有无数据
                                 if (tab.Rows.Count > 0)
                                 {
                                     //首行数据
                                     var row = (DataSetCompleteBalance.t_complete_lot_card_balanceRow)tab.Rows[0];
                                     //写入清单数据到控件
                                     SetBillContent(row, iRow);
                                     //行号加1
                                     iRow++;
                                 }
                             }
                         }
                     }
                 }
             }
             break;
         case FormViewMode.Edit:
         case FormViewMode.ReadOnly:
             //设置单据清单不可见
             tabDataListSon.Visible = false;
             //通过出库单号获取数据清单
             //取得传入的出库单号
             string billNum2 = Request["bnum"];
             if (billNum2 != null && billNum2.Length > 0)
             {
                 //获取清单
                 using (var daContent = new t_complete_lot_card_out_contentTableAdapter())
                 {
                     //获取数据
                     var tabContent = daContent.GetDataByBillNum(billNum2);
                     //检测是否找到数据
                     if (tabContent.Rows.Count > 0)
                     {
                         //设置单据清单可见
                         tabDataListSon.Visible = true;
                         //把内容写入页面
                         foreach (DataSetCompleteOut.t_complete_lot_card_out_contentRow row in tabContent.Rows)
                         {
                             //当前行号
                             int i = row.row_id - 1;
                             //写入清单数据到控件
                             SetBillContent(row, i);
                         }
                     }
                 }
             }
             break;
     }
     //当前lot卡号文本框获取焦点
     var tb2 = (TextBox)fvCompleteOutAdd.FindControl("txtLotId0");
     if (tb2 != null)
     {
         //设置焦点
         tb2.Focus();
     }
 }
예제 #13
0
 /// <summary>
 /// 根据单号从数据库中删除单据的表头和内容
 /// </summary>
 /// <param name="billNum">单据号</param>
 private bool DeleteBillByBillNum(string billNum)
 {
     //实例化数据适配器
     using (var da = new v_complete_lot_card_inTableAdapter())
     //取得数据库连接
     using (var conn = da.Connection)
     {
         //打开数据库连接
         conn.Open();
         //事务
         using (var tran = conn.BeginTransaction())
         {
             //设置事务
             da.Transaction = tran;
             try
             {
                 //取得之前入库单清单记录
                 var tab = da.GetDataByBillNum(billNum);
                 //检测是否存在数据
                 if (tab.Rows.Count >= 0)
                 {
                     //单据表头行、内容行、成品结存和待入库数据适配器
                     using (var daHead = new t_complete_lot_card_in_headTableAdapter())
                     using (var daContent = new t_complete_lot_card_in_contentTableAdapter())
                     using (var daBalance = new t_complete_lot_card_balanceTableAdapter())
                     using (var daWait = new t_complete_lot_card_waitTableAdapter())
                     {
                         //设置连接对象
                         daHead.Connection = daContent.Connection = daBalance.Connection = daWait.Connection = tran.Connection;
                         //设置事务
                         daHead.Transaction = daContent.Transaction = daBalance.Transaction = daWait.Transaction = tran;
                         //遍历行执行删除各行的结存记录和写回待入库记录
                         foreach (DataSetCompleteIn.v_complete_lot_card_inRow row in tab.Rows)
                         {
                             //执行扣减结存
                             ydOperateCompleteLotCard.DecreaseCompleteBalance(
                                 daBalance,
                                 row.prev_dept_name,
                                 row.lot_id,
                                 row.pnl_qty,
                                 row.pcs_qty
                             );
                             //执行插入待入库记录
                             daWait.InsertData(
                                 row.prev_dept_name,
                                 row.dept_name,
                                 row.lot_id,
                                 row.product_num,
                                 row.pnl_qty,
                                 row.pcs_qty,
                                 row.remark,
                                 row.add_person
                             );
                         }
                         //根据入库单号删除全部入库内容记录
                         daContent.DeleteByBillNum(billNum);
                         //根据入库单号删除全部入库表头记录
                         daHead.Delete(billNum);
                     }
                 }
                 //提交事务
                 tran.Commit();
                 //返回成功
                 return true;
             }
             catch (Exception ex)
             {
                 //回滚事务
                 tran.Rollback();
                 //抛出错误
                 throw new Exception("删除入库单记录出现错误:\n" + ex.Message);
             }
         }
     }
 }