/// <summary> /// 得到一个对象实体 /// </summary> public List <Mod_TRC_ROLL_WGD_ITEM> GetModels(string C_ID) { List <Mod_TRC_ROLL_WGD_ITEM> models = new List <Mod_TRC_ROLL_WGD_ITEM>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_MAIN_ID,C_ROLL_WGD_ID,C_BATCH_NO,N_STATUS,C_STD_CODE,C_STL_GRD,C_SPEC,C_MAT_CODE,C_MAT_DESC,C_SALE_AREA,C_ZYX1,C_ZYX2,C_BZYQ,C_MRSX from TRC_ROLL_WGD_ITEM "); strSql.Append(" where C_ROLL_WGD_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TRC_ROLL_WGD_ITEM model = new Mod_TRC_ROLL_WGD_ITEM(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow item in ds.Tables[0].Rows) { models.Add(DataRowToModel(item)); } return(models); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TRC_ROLL_WGD_ITEM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TRC_ROLL_WGD_ITEM("); strSql.Append("C_MAIN_ID,C_ROLL_WGD_ID,C_BATCH_NO,N_STATUS,C_STD_CODE,C_STL_GRD,C_SPEC,C_MAT_CODE,C_MAT_DESC,C_SALE_AREA,C_ZYX1,C_ZYX2,C_BZYQ,C_MRSX)"); strSql.Append(" values ("); strSql.Append(":C_MAIN_ID,:C_ROLL_WGD_ID,:C_BATCH_NO,:N_STATUS,:C_STD_CODE,:C_STL_GRD,:C_SPEC,:C_MAT_CODE,:C_MAT_DESC,:C_SALE_AREA,:C_ZYX1,:C_ZYX2,:C_BZYQ,:C_MRSX)"); OracleParameter[] parameters = { new OracleParameter(":C_MAIN_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_ROLL_WGD_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 15), new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100), new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100), new OracleParameter(":C_SALE_AREA", OracleDbType.Varchar2, 100), new OracleParameter(":C_ZYX1", OracleDbType.Varchar2, 100), new OracleParameter(":C_ZYX2", OracleDbType.Varchar2, 100), new OracleParameter(":C_BZYQ", OracleDbType.Varchar2, 100), new OracleParameter(":C_MRSX", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_MAIN_ID; parameters[1].Value = model.C_ROLL_WGD_ID; parameters[2].Value = model.C_BATCH_NO; parameters[3].Value = model.N_STATUS; parameters[4].Value = model.C_STD_CODE; parameters[5].Value = model.C_STL_GRD; parameters[6].Value = model.C_SPEC; parameters[7].Value = model.C_MAT_CODE; parameters[8].Value = model.C_MAT_DESC; parameters[9].Value = model.C_SALE_AREA; parameters[10].Value = model.C_ZYX1; parameters[11].Value = model.C_ZYX2; parameters[12].Value = model.C_BZYQ; parameters[13].Value = model.C_MRSX; int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TRC_ROLL_WGD_ITEM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TRC_ROLL_WGD_ITEM set "); strSql.Append("C_MAIN_ID=:C_MAIN_ID,"); strSql.Append("C_ROLL_WGD_ID=:C_ROLL_WGD_ID,"); strSql.Append("C_BATCH_NO=:C_BATCH_NO,"); strSql.Append("N_STATUS=:N_STATUS,"); strSql.Append("C_STD_CODE=:C_STD_CODE,"); strSql.Append("C_STL_GRD=:C_STL_GRD,"); strSql.Append("C_SPEC=:C_SPEC,"); strSql.Append("C_MAT_CODE=:C_MAT_CODE,"); strSql.Append("C_MAT_DESC=:C_MAT_DESC,"); strSql.Append("C_SALE_AREA=:C_SALE_AREA,"); strSql.Append("C_ZYX1=:C_ZYX1,"); strSql.Append("C_ZYX2=:C_ZYX2,"); strSql.Append("C_BZYQ=:C_BZYQ"); strSql.Append("C_MRSX=:C_MRSX"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_MAIN_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_ROLL_WGD_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 15), new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100), new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100), new OracleParameter(":C_SALE_AREA", OracleDbType.Varchar2, 100), new OracleParameter(":C_ZYX1", OracleDbType.Varchar2, 100), new OracleParameter(":C_ZYX2", OracleDbType.Varchar2, 100), new OracleParameter(":C_BZYQ", OracleDbType.Varchar2, 100), new OracleParameter(":C_MRSX", OracleDbType.Varchar2, 100), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_MAIN_ID; parameters[1].Value = model.C_ROLL_WGD_ID; parameters[2].Value = model.C_BATCH_NO; parameters[3].Value = model.N_STATUS; parameters[4].Value = model.C_STD_CODE; parameters[5].Value = model.C_STL_GRD; parameters[6].Value = model.C_SPEC; parameters[7].Value = model.C_MAT_CODE; parameters[8].Value = model.C_MAT_DESC; parameters[9].Value = model.C_SALE_AREA; parameters[10].Value = model.C_ZYX1; parameters[11].Value = model.C_ZYX2; parameters[12].Value = model.C_BZYQ; parameters[13].Value = model.C_MRSX; parameters[14].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TRC_ROLL_WGD_ITEM DataRowToModel(DataRow row) { Mod_TRC_ROLL_WGD_ITEM model = new Mod_TRC_ROLL_WGD_ITEM(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_MAIN_ID"] != null) { model.C_MAIN_ID = row["C_MAIN_ID"].ToString(); } if (row["C_ROLL_WGD_ID"] != null) { model.C_ROLL_WGD_ID = row["C_ROLL_WGD_ID"].ToString(); } if (row["C_BATCH_NO"] != null) { model.C_BATCH_NO = row["C_BATCH_NO"].ToString(); } if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "") { model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString()); } if (row["C_STD_CODE"] != null) { model.C_STD_CODE = row["C_STD_CODE"].ToString(); } if (row["C_STL_GRD"] != null) { model.C_STL_GRD = row["C_STL_GRD"].ToString(); } if (row["C_SPEC"] != null) { model.C_SPEC = row["C_SPEC"].ToString(); } if (row["C_MAT_CODE"] != null) { model.C_MAT_CODE = row["C_MAT_CODE"].ToString(); } if (row["C_MAT_DESC"] != null) { model.C_MAT_DESC = row["C_MAT_DESC"].ToString(); } if (row["C_SALE_AREA"] != null) { model.C_SALE_AREA = row["C_SALE_AREA"].ToString(); } if (row["C_ZYX1"] != null) { model.C_ZYX1 = row["C_ZYX1"].ToString(); } if (row["C_ZYX2"] != null) { model.C_ZYX2 = row["C_ZYX2"].ToString(); } if (row["C_BZYQ"] != null) { model.C_BZYQ = row["C_BZYQ"].ToString(); } if (row["C_MRSX"] != null) { model.C_MRSX = row["C_MRSX"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TRC_ROLL_WGD_ITEM model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TRC_ROLL_WGD_ITEM model) { return(dal.Add(model)); }
/// <summary> /// 完工单确认 /// </summary> /// <param name="stove">炉号</param> /// <param name="batchNo">批号</param> /// <param name="planID">计划id</param> /// <param name="num">支数</param> /// <param name="wgt">重量</param> /// <param name="grd">钢种</param> /// <param name="spec">规格</param> /// <param name="std">执行标准</param> /// <param name="id">主表id</param> /// <param name="staID">工位号</param> /// <param name="start">start</param> /// <param name="end">start</param> /// <param name="shift">班次ID</param> /// <param name="group">班组ID</param> /// <param name="shiftName">班次</param> /// <param name="groupName">班组</param> /// <param name="castOffQua">甩废</param> /// <param name="cuttingQua">切废</param> /// <returns></returns> public string WgdHandler(string stove, string batchNo, string planID, int num, decimal wgt, string grd, string spec, string std, string id, string staID, DateTime start, DateTime end , string shift, string group, string shiftName, string groupName, string castOffQua, string cuttingQua) { string result = "1"; try { TransactionHelper.BeginTransaction(); decimal successQua = num - decimal.Parse(castOffQua) - decimal.Parse(cuttingQua); wgdDal.UpdateWgd(start, end, num, id, decimal.Parse(castOffQua), decimal.Parse(cuttingQua), successQua, shift, group, shiftName, groupName); if (!wgdDal.UpdateRollStatus(id, 1)) { TransactionHelper.RollBack(); return("0"); } if (dal_TRC_WARM_FURNACE.UpdateWarmFurnaceRolleState(id, 3, 2) == 0) { TransactionHelper.RollBack(); return("0"); } TransactionHelper.Commit(); #region 日志模型 Mod_TRC_ROLL_WGD model = new Mod_TRC_ROLL_WGD(); var planM = planRollItem.GetModel_Item(planID); model.C_ID = Guid.NewGuid().ToString(); model.C_STA_ID = staID; model.C_STOVE = stove; model.C_BATCH_NO = batchNo; model.C_PLAN_ID = planID; model.N_QUA_PRODUCE = num; model.N_WGT_PRODUCE = wgt; model.N_STATUS = 0; model.C_STD_CODE = std; model.C_STL_GRD = grd; model.C_SPEC = spec; model.C_MAIN_ID = id; model.D_PRODUCE_DATE_B = start; model.D_PRODUCE_DATE_E = RV.UI.ServerTime.timeNow(); model.C_PRODUCE_SHIFT = shift; model.C_PRODUCE_GROUP = group; model.C_PRODUCE_EMP_ID = RV.UI.UserInfo.userID; model.D_MOD_DT = start; model.D_PRODUCE_DATE = model.D_PRODUCE_DATE_B; model.C_FREE_TERM = planM.C_FREE_TERM; model.C_FREE_TERM2 = planM.C_FREE_TERM2; model.C_PACK = planM.C_PACK; model.C_AREA = planM.C_AREA; model.C_PCLX = planM.C_PCLX; model.C_MAT_CODE = planM.C_MAT_CODE; model.C_MAT_DESC = planM.C_MAT_NAME; model.C_PRODUCE_SHIFT_NAME = shiftName; model.C_PRODUCE_GROUP_NAME = groupName; Mod_TRC_ROLL_WGD_ITEM itemM = new Mod_TRC_ROLL_WGD_ITEM(); itemM.C_MAIN_ID = model.C_MAIN_ID; itemM.C_ROLL_WGD_ID = model.C_ID; itemM.C_BATCH_NO = batchNo; itemM.N_STATUS = 0; itemM.C_STL_GRD = model.C_STL_GRD; itemM.C_STD_CODE = model.C_STD_CODE; itemM.C_SPEC = model.C_SPEC; itemM.C_MAT_CODE = planM.C_MAT_CODE; itemM.C_MAT_DESC = planM.C_MAT_NAME; itemM.C_ZYX1 = planM.C_FREE_TERM; itemM.C_ZYX2 = planM.C_FREE_TERM2; itemM.C_BZYQ = model.C_PACK; itemM.C_SALE_AREA = model.C_AREA; itemM.C_MRSX = model.C_MRSX; DataTable dt = wgdDal.Get_Item_List(planM.C_MAT_CODE).Tables[0]; if (dt != null && dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { Mod_TRC_ROLL_WGD_ITEM itemMM = new Mod_TRC_ROLL_WGD_ITEM(); itemMM.C_MAIN_ID = model.C_MAIN_ID; itemMM.C_ROLL_WGD_ID = model.C_ID; itemMM.C_BATCH_NO = batchNo; itemMM.N_STATUS = 0; itemMM.C_STL_GRD = item["钢种"].ToString(); itemMM.C_STD_CODE = item["执行标准"].ToString(); itemMM.C_SPEC = item["规格"].ToString(); itemMM.C_MAT_CODE = item["物料编码"].ToString(); itemMM.C_MAT_DESC = item["物料名称"].ToString(); itemMM.C_ZYX1 = item["自由项1"].ToString(); itemMM.C_ZYX2 = item["自由项2"].ToString(); itemMM.C_BZYQ = model.C_PACK; itemMM.C_SALE_AREA = model.C_AREA; itemMM.C_MRSX = model.C_MRSX; } } #endregion AddLog(stove, batchNo, planID, num, wgt, grd, spec, std, id, staID, start, end, shift, group, model, planM, dt); } catch (Exception ex) { TransactionHelper.RollBack(); return("0"); } return(result); }