/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TRC_ROLL_PDD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TRC_ROLL_PDD set "); strSql.Append("C_CK=:C_CK,"); strSql.Append("D_PDRQ=:D_PDRQ,"); strSql.Append("C_YSDH=:C_YSDH,"); strSql.Append("D_INSERT=:D_INSERT,"); strSql.Append("C_REMARK=:C_REMARK,"); strSql.Append("N_STATUS=:N_STATUS"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_CK", OracleDbType.Varchar2, 100), new OracleParameter(":D_PDRQ", OracleDbType.Date), new OracleParameter(":C_YSDH", OracleDbType.Varchar2, 100), new OracleParameter(":D_INSERT", OracleDbType.Date), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 4), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_CK; parameters[1].Value = model.D_PDRQ; parameters[2].Value = model.C_YSDH; parameters[3].Value = model.D_INSERT; parameters[4].Value = model.C_REMARK; parameters[5].Value = model.N_STATUS; parameters[6].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add_Trans(Mod_TRC_ROLL_PDD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TRC_ROLL_PDD("); strSql.Append("C_ID,C_CK,D_PDRQ,C_YSDH,D_INSERT,C_REMARK,N_STATUS)"); strSql.Append(" values ("); strSql.Append(":C_ID,:C_CK,:D_PDRQ,:C_YSDH,:D_INSERT,:C_REMARK,:N_STATUS)"); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_CK", OracleDbType.Varchar2, 100), new OracleParameter(":D_PDRQ", OracleDbType.Date), new OracleParameter(":C_YSDH", OracleDbType.Varchar2, 100), new OracleParameter(":D_INSERT", OracleDbType.Date), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 4) }; parameters[0].Value = model.C_ID; parameters[1].Value = model.C_CK; parameters[2].Value = model.D_PDRQ; parameters[3].Value = model.C_YSDH; parameters[4].Value = model.D_INSERT; parameters[5].Value = model.C_REMARK; parameters[6].Value = model.N_STATUS; int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TRC_ROLL_PDD DataRowToModel(DataRow row) { Mod_TRC_ROLL_PDD model = new Mod_TRC_ROLL_PDD(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_CK"] != null) { model.C_CK = row["C_CK"].ToString(); } if (row["D_PDRQ"] != null) { model.D_PDRQ = DateTime.Parse(row["D_PDRQ"].ToString()); } if (row["C_YSDH"] != null) { model.C_YSDH = row["C_YSDH"].ToString(); } if (row["D_INSERT"] != null && row["D_INSERT"].ToString() != "") { model.D_INSERT = DateTime.Parse(row["D_INSERT"].ToString()); } if (row["C_REMARK"] != null) { model.C_REMARK = row["C_REMARK"].ToString(); } if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "") { model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TRC_ROLL_PDD GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_CK,D_PDRQ,C_YSDH,D_INSERT,C_REMARK,N_STATUS from TRC_ROLL_PDD "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TRC_ROLL_PDD model = new Mod_TRC_ROLL_PDD(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TRC_ROLL_PDD model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TRC_ROLL_PDD model) { return(dal.Add(model)); }
/// <summary> /// 下发条码 /// </summary> /// <returns></returns> public string Down_RF(DataTable dt) { string result = "1"; try { TransactionHelper.BeginTransaction(); TransactionHelper_SQL.BeginTransaction(); string userID = RV.UI.UserInfo.UserID; DateTime dTime = RV.UI.ServerTime.timeNow(); Dal_TRC_ROLL_PDD_ITEM dalRollPddItem = new Dal_TRC_ROLL_PDD_ITEM(); Dal_TPB_LINEWH dalTpbLineWh = new Dal_TPB_LINEWH(); Int64 i_ID_Main = 0; Int64 i_ID_Item = 0; string s_id_main = dal.Get_Max_ID(); if (string.IsNullOrEmpty(s_id_main)) { i_ID_Main = 20190200000; } else { i_ID_Main = Convert.ToInt64(s_id_main) + 1; } string s_id_item = dalRollPddItem.Get_Max_ID(); if (string.IsNullOrEmpty(s_id_item)) { i_ID_Item = 2019022500000; } else { i_ID_Item = Convert.ToInt64(s_id_item) + 1; } for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["条码账存卷数"].ToString() == "0") { continue; } string NC_CK_ID = dalTpbLineWh.GetList_id(dt.Rows[i]["仓库"].ToString()).ToString(); string strDH = dal.Get_PDDH(dTime.ToString(), dt.Rows[i]["仓库"].ToString()); if (string.IsNullOrEmpty(strDH)) { strDH = dal.Get_Max_PDDH(dTime.ToString()); if (string.IsNullOrEmpty(strDH)) { strDH = "PD" + dTime.ToString("yyyyMMdd") + "0001"; } else { strDH = "PD" + (Convert.ToUInt64(strDH) + 1).ToString(); } i_ID_Main++; Mod_TRC_ROLL_PDD modPdd = new Mod_TRC_ROLL_PDD(); modPdd.C_ID = i_ID_Main.ToString(); modPdd.C_CK = dt.Rows[i]["仓库"].ToString(); modPdd.D_PDRQ = dTime; modPdd.C_YSDH = strDH; modPdd.D_INSERT = dTime; if (!dal.Add_Trans(modPdd)) { TransactionHelper.RollBack(); TransactionHelper_SQL.RollBack(); return("往CAP盘点主表插入失败!"); } string strSql = "insert into ReZJB_PDD(ZJBstatus,CAPPK,ck,pdrq,ysdh,insertts,beizhu)values('0','" + i_ID_Main.ToString() + "','" + NC_CK_ID + "','" + dTime + "','" + strDH + "','" + dTime + "','') "; if (!dal.Add_RF_Trans(strSql)) { TransactionHelper.RollBack(); TransactionHelper_SQL.RollBack(); return("往RF盘点主表插入失败!"); } } i_ID_Item++; Mod_TRC_ROLL_PDD_ITEM modItem = new Mod_TRC_ROLL_PDD_ITEM(); modItem.C_YSDH = strDH; modItem.C_MATCODE = dt.Rows[i]["物料号"].ToString(); modItem.C_PCH = dt.Rows[i]["批次号"].ToString(); modItem.C_SX = dt.Rows[i]["质量等级"].ToString(); //modItem.C_ZCSL = dt.Rows[i]["仓库"].ToString(); //modItem.C_FZCZL = dt.Rows[i]["仓库"].ToString(); //modItem.C_FREE0 = ""; modItem.C_FREE1 = dt.Rows[i]["自由项1"].ToString(); modItem.C_FREE2 = dt.Rows[i]["自由项2"].ToString(); modItem.C_FREE3 = dt.Rows[i]["自由项3"].ToString(); //modItem.C_FREE4 = ""; modItem.C_ID = i_ID_Item.ToString(); modItem.D_INSERT = dTime; //modItem.C_REMARK = ""; modItem.C_CK = dt.Rows[i]["仓库"].ToString(); modItem.C_MATDESC = dt.Rows[i]["物料名称"].ToString(); modItem.C_SPEC = dt.Rows[i]["规格"].ToString(); modItem.C_STL_GRD = dt.Rows[i]["钢种"].ToString(); modItem.C_NC_SL = Convert.ToDecimal(dt.Rows[i]["NC账存卷数"].ToString()); modItem.C_NC_ZL = Convert.ToDecimal(dt.Rows[i]["NC账存数量"].ToString()); modItem.C_CAP_SL = Convert.ToDecimal(dt.Rows[i]["CAP账存卷数"].ToString()); modItem.C_CAP_ZL = Convert.ToDecimal(dt.Rows[i]["CAP账存数量"].ToString()); modItem.C_RF_SL = Convert.ToDecimal(dt.Rows[i]["条码账存卷数"].ToString()); modItem.C_RF_ZL = Convert.ToDecimal(dt.Rows[i]["条码账存数量"].ToString()); //modItem.C_RF_SJ_SL = dt.Rows[i]["仓库"].ToString(); //modItem.C_RF_SJ_ZL = dt.Rows[i]["仓库"].ToString(); modItem.C_NC_CAP_SL = Convert.ToDecimal(dt.Rows[i]["NC与CAP卷数账差"].ToString()); modItem.C_NC_CAP_ZL = Convert.ToDecimal(dt.Rows[i]["NC与CAP数量账差"].ToString()); modItem.C_RF_CAP_SL = Convert.ToDecimal(dt.Rows[i]["条码与CAP卷数账差"].ToString()); modItem.C_RF_CAP_ZL = Convert.ToDecimal(dt.Rows[i]["条码与CAP数量账差"].ToString()); //modItem.C_CAP_SJ_SL = Convert.ToDecimal(dt.Rows[i]["CAP与实盘卷数差异"].ToString()); //modItem.C_CAP_SJ_ZL = Convert.ToDecimal(dt.Rows[i]["CAP与实盘数量差异"].ToString()); if (!dalRollPddItem.Add_Trans(modItem)) { TransactionHelper.RollBack(); TransactionHelper_SQL.RollBack(); return("往CAP盘点明细表插入失败!"); } string strSql_Item = "insert into ReZJB_PDD_Item(ysdh,BARCODE,PCH,SX,ZCSL,FZCZL,vfree0,vfree1,vfree2,vfree3,vfree4,ZJBstatus,CAPPK,insertts)values('" + strDH + "','" + dt.Rows[i]["物料号"].ToString() + "','" + dt.Rows[i]["批次号"].ToString() + "','" + dt.Rows[i]["质量等级"].ToString() + "','" + dt.Rows[i]["条码账存卷数"].ToString() + "','" + dt.Rows[i]["条码账存数量"].ToString() + "','','" + dt.Rows[i]["自由项1"].ToString() + "','" + dt.Rows[i]["自由项2"].ToString() + "','" + dt.Rows[i]["自由项3"].ToString() + "','','0','" + i_ID_Item.ToString() + "','" + dTime + "' ) "; if (!dal.Add_RF_Trans(strSql_Item)) { TransactionHelper.RollBack(); TransactionHelper_SQL.RollBack(); return("往RF盘点主表插入失败!"); } } TransactionHelper.Commit(); TransactionHelper_SQL.Commit(); } catch (Exception ex) { TransactionHelper.RollBack(); TransactionHelper_SQL.RollBack(); return(ex.Message); } return(result); }