Exemple #1
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool Add(Mod_TRC_PLAN_REGROUND model)
 {
     return(dal.Add(model));
 }
Exemple #2
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Mod_TRC_PLAN_REGROUND model)
 {
     return(dal.Update(model));
 }
Exemple #3
0
        /// <summary>
        /// 修磨计划
        /// </summary>
        /// <param name="stove">炉号</param>
        /// <param name="batchNo">批号</param>
        /// <param name="grd">钢种</param>
        /// <param name="spec">规格</param>
        /// <param name="std">执行标准</param>
        /// <param name="matCode">物料编码</param>
        /// <param name="matName">物料名称</param>
        /// <param name="len">长度</param>
        /// <param name="factNum">支数</param>
        /// <param name="reGroundWork">修磨工序</param>
        /// <param name="shift">班次</param>
        /// <param name="group">班组</param>
        /// <param name="remark">备注</param>
        /// <param name="slabwhCode">仓库编码</param>
        /// <param name="wgt">重量</param>
        /// <param name="grdXMGX"></param>
        /// <param name="store">仓库编码</param>
        /// <param name="area">区域编码</param>
        /// <param name="kw">库位</param>
        /// <param name="floor">层</param>
        /// <param name="dept">部门</param>
        /// <param name="slabArea">钢坯区域</param>
        /// <param name="slabLoc">钢坯地址</param>
        /// <param name="isxm">是否修磨</param>
        /// <param name="gx">标准</param>
        /// <param name="gw">工位</param>
        /// <param name="sl">砂轮</param>
        /// <returns></returns>
        public string CreateRegroundPlan(string stove, string batchNo, string grd,
                                         string spec, string std, string matCode, string matName, string len, string factNum,
                                         string reGroundWork, string shift, string group, string remark, string slabwhCode, decimal wgt
                                         , string grdXMGX, string store, string area, string kw, string floor, string dept, string slabArea, string slabLoc, string isxm
                                         , string gx, string gw, string sl, string xlloc, string emp)
        {
            DataTable dt = dal.GetWaitRegroudSlabs(slabwhCode, batchNo, stove, grd, spec, std, matCode, len, factNum, slabArea, slabLoc, isxm).Tables[0];

            string result = "1";

            TransactionHelper.BeginTransaction();
            try
            {
                Mod_TRC_PLAN_REGROUND reground = new Mod_TRC_PLAN_REGROUND();
                reground.C_ID       = Guid.NewGuid().ToString();
                reground.C_BATCH_NO = batchNo;
                reground.C_STOVE    = stove;
                reground.C_STL_GRD  = grd;
                reground.C_MAT_CODE = matCode;
                reground.C_MAT_NAME = matName;
                reground.C_SPEC     = spec;
                reground.N_LEN      = decimal.Parse(len);
                reground.N_QUA      = decimal.Parse(factNum);
                reground.N_WGT      = wgt;
                reground.C_STD_CODE = std;
                reground.C_REMARK   = remark;
                reground.C_XMGX     = reGroundWork;
                var arr = reGroundWork.Split(new char[] { '-' }, StringSplitOptions.RemoveEmptyEntries);
                reground.N_TOTALSTEP         = arr.Length;
                reground.N_QUA_VIRTUAL       = decimal.Parse(factNum);
                reground.C_SLABWH_CODE       = store;
                reground.C_SLABWH_AREA_CODE  = area;
                reground.C_SLABWH_LOC_CODE   = kw;
                reground.C_SLABWH_TIER_CODE  = floor;
                reground.C_XMGX_GRD          = grdXMGX;
                reground.C_SLAB_TYPE         = dept;
                reground.C_EXTEND16          = gx;
                reground.C_EXTEND17          = gw;
                reground.C_EXTEND18          = sl;
                reground.C_EMP_CODE          = emp;
                reground.C_SLABWH_XLLOC_CODE = xlloc;

                if (!dal.Add(reground))
                {
                    TransactionHelper.RollBack();
                    return("0");
                }


                if (dt == null || dt.Rows.Count == 0)
                {
                    TransactionHelper.RollBack();
                    return("0");
                }

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    for (int j = 0; j < arr.Length; j++)
                    {
                        Mod_TRC_PLAN_REGROUND_ITEM item = new Mod_TRC_PLAN_REGROUND_ITEM();
                        item.C_PLAN_REGROUND_ID = reground.C_ID;
                        item.C_SLAB_MAIN_ID     = dt.Rows[i]["C_ID"].ToString();
                        item.N_TOTALSTEP        = arr.Length;
                        item.N_STEP             = j + 1;
                        item.N_STEPNAME         = arr[j];
                        item.N_STATUS           = item.N_STEP == 1 ? 1 : 0;
                        item.C_EMP_ID           = RV.UI.UserInfo.userID;
                        if (!itemDal.Add(item))
                        {
                            TransactionHelper.RollBack();
                            return("0");
                        }
                    }
                }

                if (dal.UpdateSlabStatus(dt, "DX", "E", store, area, kw, floor) != int.Parse(factNum))
                {
                    TransactionHelper.RollBack();
                    return("0");
                }

                TransactionHelper.Commit();
            }
            catch (Exception ex)
            {
                TransactionHelper.RollBack();
                return("0");
            }
            return(result);
        }