private void map(WhProductShelvingInspectionInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.WorkType = Util.TrimIntNull(tempdr["WorkType"]); oParam.BillType = Util.TrimIntNull(tempdr["BillType"]); oParam.BillSysNo = Util.TrimIntNull(tempdr["BillSysNo"]); oParam.AllocatedUserSysNo = Util.TrimIntNull(tempdr["AllocatedUserSysNo"]); oParam.RealUserSysNo = Util.TrimIntNull(tempdr["RealUserSysNo"]); oParam.UpdateUserSysNo = Util.TrimIntNull(tempdr["UpdateUserSysNo"]); oParam.UpdateTime = Util.TrimDateNull(tempdr["UpdateTime"]); }
public WhProductShelvingInspectionInfo Load(int SysNo) { string sql = "select * from Wh_ProductShelvingInspection where sysno =" + SysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) { return(null); } WhProductShelvingInspectionInfo oInfo = new WhProductShelvingInspectionInfo(); this.map(oInfo, ds.Tables[0].Rows[0]); return(oInfo); }
public int Insert(WhProductShelvingInspectionInfo oParam) { string sql = @"INSERT INTO Wh_ProductShelvingInspection ( WorkType, BillType, BillSysNo, AllocatedUserSysNo, RealUserSysNo, UpdateUserSysNo, UpdateTime ) VALUES ( @WorkType, @BillType, @BillSysNo, @AllocatedUserSysNo, @RealUserSysNo, @UpdateUserSysNo, @UpdateTime );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramWorkType = new SqlParameter("@WorkType", SqlDbType.Int, 4); SqlParameter paramBillType = new SqlParameter("@BillType", SqlDbType.Int, 4); SqlParameter paramBillSysNo = new SqlParameter("@BillSysNo", SqlDbType.Int, 4); SqlParameter paramAllocatedUserSysNo = new SqlParameter("@AllocatedUserSysNo", SqlDbType.Int, 4); SqlParameter paramRealUserSysNo = new SqlParameter("@RealUserSysNo", SqlDbType.Int, 4); SqlParameter paramUpdateUserSysNo = new SqlParameter("@UpdateUserSysNo", SqlDbType.Int, 4); SqlParameter paramUpdateTime = new SqlParameter("@UpdateTime", SqlDbType.DateTime); paramSysNo.Direction = ParameterDirection.Output; if (oParam.WorkType != AppConst.IntNull) { paramWorkType.Value = oParam.WorkType; } else { paramWorkType.Value = System.DBNull.Value; } if (oParam.BillType != AppConst.IntNull) { paramBillType.Value = oParam.BillType; } else { paramBillType.Value = System.DBNull.Value; } if (oParam.BillSysNo != AppConst.IntNull) { paramBillSysNo.Value = oParam.BillSysNo; } else { paramBillSysNo.Value = System.DBNull.Value; } if (oParam.AllocatedUserSysNo != AppConst.IntNull) { paramAllocatedUserSysNo.Value = oParam.AllocatedUserSysNo; } else { paramAllocatedUserSysNo.Value = System.DBNull.Value; } if (oParam.RealUserSysNo != AppConst.IntNull) { paramRealUserSysNo.Value = oParam.RealUserSysNo; } else { paramRealUserSysNo.Value = System.DBNull.Value; } if (oParam.UpdateUserSysNo != AppConst.IntNull) { paramUpdateUserSysNo.Value = oParam.UpdateUserSysNo; } else { paramUpdateUserSysNo.Value = System.DBNull.Value; } if (oParam.UpdateTime != AppConst.DateTimeNull) { paramUpdateTime.Value = oParam.UpdateTime; } else { paramUpdateTime.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramWorkType); cmd.Parameters.Add(paramBillType); cmd.Parameters.Add(paramBillSysNo); cmd.Parameters.Add(paramAllocatedUserSysNo); cmd.Parameters.Add(paramRealUserSysNo); cmd.Parameters.Add(paramUpdateUserSysNo); cmd.Parameters.Add(paramUpdateTime); return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo)); }
public int Update(WhProductShelvingInspectionInfo oParam) { string sql = @"UPDATE Wh_ProductShelvingInspection SET WorkType=@WorkType, BillType=@BillType, BillSysNo=@BillSysNo, AllocatedUserSysNo=@AllocatedUserSysNo, RealUserSysNo=@RealUserSysNo, UpdateUserSysNo=@UpdateUserSysNo, UpdateTime=@UpdateTime WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramWorkType = new SqlParameter("@WorkType", SqlDbType.Int, 4); SqlParameter paramBillType = new SqlParameter("@BillType", SqlDbType.Int, 4); SqlParameter paramBillSysNo = new SqlParameter("@BillSysNo", SqlDbType.Int, 4); SqlParameter paramAllocatedUserSysNo = new SqlParameter("@AllocatedUserSysNo", SqlDbType.Int, 4); SqlParameter paramRealUserSysNo = new SqlParameter("@RealUserSysNo", SqlDbType.Int, 4); SqlParameter paramUpdateUserSysNo = new SqlParameter("@UpdateUserSysNo", SqlDbType.Int, 4); SqlParameter paramUpdateTime = new SqlParameter("@UpdateTime", SqlDbType.DateTime); if (oParam.SysNo != AppConst.IntNull) { paramSysNo.Value = oParam.SysNo; } else { paramSysNo.Value = System.DBNull.Value; } if (oParam.WorkType != AppConst.IntNull) { paramWorkType.Value = oParam.WorkType; } else { paramWorkType.Value = System.DBNull.Value; } if (oParam.BillType != AppConst.IntNull) { paramBillType.Value = oParam.BillType; } else { paramBillType.Value = System.DBNull.Value; } if (oParam.BillSysNo != AppConst.IntNull) { paramBillSysNo.Value = oParam.BillSysNo; } else { paramBillSysNo.Value = System.DBNull.Value; } if (oParam.AllocatedUserSysNo != AppConst.IntNull) { paramAllocatedUserSysNo.Value = oParam.AllocatedUserSysNo; } else { paramAllocatedUserSysNo.Value = System.DBNull.Value; } if (oParam.RealUserSysNo != AppConst.IntNull) { paramRealUserSysNo.Value = oParam.RealUserSysNo; } else { paramRealUserSysNo.Value = System.DBNull.Value; } if (oParam.UpdateUserSysNo != AppConst.IntNull) { paramUpdateUserSysNo.Value = oParam.UpdateUserSysNo; } else { paramUpdateUserSysNo.Value = System.DBNull.Value; } if (oParam.UpdateTime != AppConst.DateTimeNull) { paramUpdateTime.Value = oParam.UpdateTime; } else { paramUpdateTime.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramWorkType); cmd.Parameters.Add(paramBillType); cmd.Parameters.Add(paramBillSysNo); cmd.Parameters.Add(paramAllocatedUserSysNo); cmd.Parameters.Add(paramRealUserSysNo); cmd.Parameters.Add(paramUpdateUserSysNo); cmd.Parameters.Add(paramUpdateTime); return(SqlHelper.ExecuteNonQuery(cmd)); }
public void Update(WhProductShelvingInspectionInfo oParam) { new WhProductShelvingInspectionDac().Update(oParam); }
public void Insert(WhProductShelvingInspectionInfo oParam) { new WhProductShelvingInspectionDac().Insert(oParam); }