private void MapReturn(RMAReturnInfo oInfo, DataRow dr) { oInfo.CreateTime = Util.TrimDateNull(dr["CreateTime"]); oInfo.CreateUserSysNo = Util.TrimIntNull(dr["CreateUserSysNo"]); oInfo.Note = dr["Note"].ToString(); oInfo.ReturnID = dr["ReturnID"].ToString(); oInfo.ReturnTime = Util.TrimDateNull(dr["ReturnTime"]); oInfo.ReturnUserSysNo = Util.TrimIntNull(dr["ReturnUserSysNo"]); oInfo.Status = Util.TrimIntNull(dr["Status"]); oInfo.StockSysNo = Util.TrimIntNull(dr["StockSysNo"]); oInfo.SysNo = Util.TrimIntNull(dr["SysNo"]); }
public RMAReturnInfo Load(int sysno) { RMAReturnInfo oReturn = new RMAReturnInfo(); string sql = "select * from RMA_Return where sysno=" + sysno; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { DataRow dr = ds.Tables[0].Rows[0]; MapReturn(oReturn, dr); string itemsql = @"select RMA_Register.* ,RMA_Return_Item.SysNo as ItemSysNo from RMA_Return_Item (NOLOCK) inner join RMA_Register (NOLOCK) on RMA_Register.SysNo = RMA_Return_Item.RegisterSysNo where RMA_Return_Item.ReturnSysNo = " + sysno; DataSet itemds = SqlHelper.ExecuteDataSet(itemsql); if (Util.HasMoreRow(itemds)) { foreach (DataRow itemdr in itemds.Tables[0].Rows) { RMARegisterInfo oRegister = new RMARegisterInfo(); RMARequestManager.GetInstance().mapRegister(oRegister, itemdr); oReturn.ItemHash.Add(itemdr["ItemSysNo"], oRegister); } } } return oReturn; }
public void Create(RMAReturnInfo returnInfo) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { returnInfo.SysNo = SequenceDac.GetInstance().Create("RMA_Return_Sequence"); returnInfo.ReturnID = getRevertID(returnInfo.SysNo); new RMAReturnDac().Insert(returnInfo); foreach (int registerSysNo in returnInfo.ItemHash.Keys) { RMAReturnItemInfo oReturnItem = new RMAReturnItemInfo(); oReturnItem.RegisterSysNo = registerSysNo; oReturnItem.ReturnSysNo = returnInfo.SysNo; this.InsertReturnItem(oReturnItem); } scope.Complete(); } }
public void InsertReturn(RMAReturnInfo oInfo) { new RMAReturnDac().Insert(oInfo); }
public int Insert(RMAReturnInfo oParam) { string sql = @"INSERT INTO RMA_Return ( SysNo, ReturnID, StockSysNo, CreateTime, CreateUserSysNo, ReturnTime, ReturnUserSysNo, Note, Status ) VALUES ( @SysNo, @ReturnID, @StockSysNo, @CreateTime, @CreateUserSysNo, @ReturnTime, @ReturnUserSysNo, @Note, @Status )"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramReturnID = new SqlParameter("@ReturnID", SqlDbType.NVarChar, 10); SqlParameter paramStockSysNo = new SqlParameter("@StockSysNo", SqlDbType.Int, 4); SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime); SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4); SqlParameter paramReturnTime = new SqlParameter("@ReturnTime", SqlDbType.DateTime); SqlParameter paramReturnUserSysNo = new SqlParameter("@ReturnUserSysNo", SqlDbType.Int, 4); SqlParameter paramNote = new SqlParameter("@Note", SqlDbType.NVarChar, 500); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); if (oParam.SysNo != AppConst.IntNull) paramSysNo.Value = oParam.SysNo; else paramSysNo.Value = System.DBNull.Value; if (oParam.ReturnID != AppConst.StringNull) paramReturnID.Value = oParam.ReturnID; else paramReturnID.Value = System.DBNull.Value; if (oParam.StockSysNo != AppConst.IntNull) paramStockSysNo.Value = oParam.StockSysNo; else paramStockSysNo.Value = System.DBNull.Value; if (oParam.CreateTime != AppConst.DateTimeNull) paramCreateTime.Value = oParam.CreateTime; else paramCreateTime.Value = System.DBNull.Value; if (oParam.CreateUserSysNo != AppConst.IntNull) paramCreateUserSysNo.Value = oParam.CreateUserSysNo; else paramCreateUserSysNo.Value = System.DBNull.Value; if (oParam.ReturnTime != AppConst.DateTimeNull) paramReturnTime.Value = oParam.ReturnTime; else paramReturnTime.Value = System.DBNull.Value; if (oParam.ReturnUserSysNo != AppConst.IntNull) paramReturnUserSysNo.Value = oParam.ReturnUserSysNo; else paramReturnUserSysNo.Value = System.DBNull.Value; if (oParam.Note != AppConst.StringNull) paramNote.Value = oParam.Note; else paramNote.Value = System.DBNull.Value; if (oParam.Status != AppConst.IntNull) paramStatus.Value = oParam.Status; else paramStatus.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramReturnID); cmd.Parameters.Add(paramStockSysNo); cmd.Parameters.Add(paramCreateTime); cmd.Parameters.Add(paramCreateUserSysNo); cmd.Parameters.Add(paramReturnTime); cmd.Parameters.Add(paramReturnUserSysNo); cmd.Parameters.Add(paramNote); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd); }