private void map(DeliveryDelayListInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.CauseType = Util.TrimIntNull(tempdr["CauseType"]); oParam.BillID = Util.TrimNull(tempdr["BillID"]); oParam.FreightUserSysNo = Util.TrimIntNull(tempdr["FreightUserSysNo"]); oParam.SetDeliveryManTime = Util.TrimDateNull(tempdr["SetDeliveryManTime"]); oParam.UpdateUserSysNo = Util.TrimIntNull(tempdr["UpdateUserSysNo"]); oParam.UpdateTime = Util.TrimDateNull(tempdr["UpdateTime"]); oParam.ReviewBackNote = Util.TrimNull(tempdr["ReviewBackNote"]); oParam.ReviewCauseType = Util.TrimIntNull(tempdr["ReviewCauseType"]); oParam.ReviewBackUserSysNo = Util.TrimIntNull(tempdr["ReviewBackUserSysNo"]); oParam.ReviewBackTime = Util.TrimDateNull(tempdr["ReviewBackTime"]); }
public void UpdateDeliveryDelayList(DeliveryDelayListInfo oParam) { new DeliveryDelayDac().Update(oParam); }
public DeliveryDelayListInfo Load(int SysNo) { string sql = "select * from DeliveryDelayList where sysno =" + SysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); DeliveryDelayListInfo oInfo = new DeliveryDelayListInfo(); if (Util.HasMoreRow(ds)) map(oInfo, ds.Tables[0].Rows[0]); else oInfo = null; return oInfo; }
public void InsertDeliveryDelayList(DeliveryDelayListInfo oParam) { string sql = "select * from DeliveryDelayList where FreightUserSysNo=" + oParam.FreightUserSysNo + " and SetDeliveryManTime=" + Util.ToSqlString(oParam.SetDeliveryManTime.ToString()) + " and BillID=" + Util.ToSqlString(oParam.BillID); DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) throw new BizException("��ͬ�����š������ˡ�����ʱ��ļ�¼�Ѵ��ڣ������ظ���ӣ�"); new DeliveryDelayDac().Insert(oParam); }
public int Update(DeliveryDelayListInfo oParam) { string sql = @"UPDATE DeliveryDelayList SET CauseType=@CauseType, BillID=@BillID, FreightUserSysNo=@FreightUserSysNo, SetDeliveryManTime=@SetDeliveryManTime, UpdateUserSysNo=@UpdateUserSysNo, UpdateTime=@UpdateTime, ReviewBackNote=@ReviewBackNote, ReviewCauseType=@ReviewCauseType, ReviewBackUserSysNo=@ReviewBackUserSysNo, ReviewBackTime=@ReviewBackTime WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramCauseType = new SqlParameter("@CauseType", SqlDbType.Int, 4); SqlParameter paramBillID = new SqlParameter("@BillID", SqlDbType.NVarChar, 50); SqlParameter paramFreightUserSysNo = new SqlParameter("@FreightUserSysNo", SqlDbType.Int, 4); SqlParameter paramSetDeliveryManTime = new SqlParameter("@SetDeliveryManTime", SqlDbType.DateTime); SqlParameter paramUpdateUserSysNo = new SqlParameter("@UpdateUserSysNo", SqlDbType.Int, 4); SqlParameter paramUpdateTime = new SqlParameter("@UpdateTime", SqlDbType.DateTime); SqlParameter paramReviewBackNote = new SqlParameter("@ReviewBackNote", SqlDbType.NVarChar, 500); SqlParameter paramReviewCauseType = new SqlParameter("@ReviewCauseType", SqlDbType.Int, 4); SqlParameter paramReviewBackUserSysNo = new SqlParameter("@ReviewBackUserSysNo", SqlDbType.Int, 4); SqlParameter paramReviewBackTime = new SqlParameter("@ReviewBackTime", SqlDbType.DateTime); if (oParam.SysNo != AppConst.IntNull) paramSysNo.Value = oParam.SysNo; else paramSysNo.Value = System.DBNull.Value; if (oParam.CauseType != AppConst.IntNull) paramCauseType.Value = oParam.CauseType; else paramCauseType.Value = System.DBNull.Value; if (oParam.BillID != AppConst.StringNull) paramBillID.Value = oParam.BillID; else paramBillID.Value = System.DBNull.Value; if (oParam.FreightUserSysNo != AppConst.IntNull) paramFreightUserSysNo.Value = oParam.FreightUserSysNo; else paramFreightUserSysNo.Value = System.DBNull.Value; if (oParam.SetDeliveryManTime != AppConst.DateTimeNull) paramSetDeliveryManTime.Value = oParam.SetDeliveryManTime; else paramSetDeliveryManTime.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; if (oParam.ReviewBackNote != AppConst.StringNull) paramReviewBackNote.Value = oParam.ReviewBackNote; else paramReviewBackNote.Value = System.DBNull.Value; if (oParam.ReviewCauseType != AppConst.IntNull) paramReviewCauseType.Value = oParam.ReviewCauseType; else paramReviewCauseType.Value = System.DBNull.Value; if (oParam.ReviewBackUserSysNo != AppConst.IntNull) paramReviewBackUserSysNo.Value = oParam.ReviewBackUserSysNo; else paramReviewBackUserSysNo.Value = System.DBNull.Value; if (oParam.ReviewBackTime != AppConst.DateTimeNull) paramReviewBackTime.Value = oParam.ReviewBackTime; else paramReviewBackTime.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramCauseType); cmd.Parameters.Add(paramBillID); cmd.Parameters.Add(paramFreightUserSysNo); cmd.Parameters.Add(paramSetDeliveryManTime); cmd.Parameters.Add(paramUpdateUserSysNo); cmd.Parameters.Add(paramUpdateTime); cmd.Parameters.Add(paramReviewBackNote); cmd.Parameters.Add(paramReviewCauseType); cmd.Parameters.Add(paramReviewBackUserSysNo); cmd.Parameters.Add(paramReviewBackTime); return SqlHelper.ExecuteNonQuery(cmd); }
public int Insert(DeliveryDelayListInfo oParam) { string sql = @"INSERT INTO DeliveryDelayList ( CauseType, BillID, FreightUserSysNo, SetDeliveryManTime, UpdateUserSysNo, UpdateTime, ReviewBackNote, ReviewCauseType, ReviewBackUserSysNo, ReviewBackTime ) VALUES ( @CauseType, @BillID, @FreightUserSysNo, @SetDeliveryManTime, @UpdateUserSysNo, @UpdateTime, @ReviewBackNote, @ReviewCauseType, @ReviewBackUserSysNo, @ReviewBackTime );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramCauseType = new SqlParameter("@CauseType", SqlDbType.Int, 4); SqlParameter paramBillID = new SqlParameter("@BillID", SqlDbType.NVarChar, 50); SqlParameter paramFreightUserSysNo = new SqlParameter("@FreightUserSysNo", SqlDbType.Int, 4); SqlParameter paramSetDeliveryManTime = new SqlParameter("@SetDeliveryManTime", SqlDbType.DateTime); SqlParameter paramUpdateUserSysNo = new SqlParameter("@UpdateUserSysNo", SqlDbType.Int, 4); SqlParameter paramUpdateTime = new SqlParameter("@UpdateTime", SqlDbType.DateTime); SqlParameter paramReviewBackNote = new SqlParameter("@ReviewBackNote", SqlDbType.NVarChar, 500); SqlParameter paramReviewCauseType = new SqlParameter("@ReviewCauseType", SqlDbType.Int, 4); SqlParameter paramReviewBackUserSysNo = new SqlParameter("@ReviewBackUserSysNo", SqlDbType.Int, 4); SqlParameter paramReviewBackTime = new SqlParameter("@ReviewBackTime", SqlDbType.DateTime); paramSysNo.Direction = ParameterDirection.Output; if (oParam.CauseType != AppConst.IntNull) paramCauseType.Value = oParam.CauseType; else paramCauseType.Value = System.DBNull.Value; if (oParam.BillID != AppConst.StringNull) paramBillID.Value = oParam.BillID; else paramBillID.Value = System.DBNull.Value; if (oParam.FreightUserSysNo != AppConst.IntNull) paramFreightUserSysNo.Value = oParam.FreightUserSysNo; else paramFreightUserSysNo.Value = System.DBNull.Value; if (oParam.SetDeliveryManTime != AppConst.DateTimeNull) paramSetDeliveryManTime.Value = oParam.SetDeliveryManTime; else paramSetDeliveryManTime.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; if (oParam.ReviewBackNote != AppConst.StringNull) paramReviewBackNote.Value = oParam.ReviewBackNote; else paramReviewBackNote.Value = System.DBNull.Value; if (oParam.ReviewCauseType != AppConst.IntNull) paramReviewCauseType.Value = oParam.ReviewCauseType; else paramReviewCauseType.Value = System.DBNull.Value; if (oParam.ReviewBackUserSysNo != AppConst.IntNull) paramReviewBackUserSysNo.Value = oParam.ReviewBackUserSysNo; else paramReviewBackUserSysNo.Value = System.DBNull.Value; if (oParam.ReviewBackTime != AppConst.DateTimeNull) paramReviewBackTime.Value = oParam.ReviewBackTime; else paramReviewBackTime.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramCauseType); cmd.Parameters.Add(paramBillID); cmd.Parameters.Add(paramFreightUserSysNo); cmd.Parameters.Add(paramSetDeliveryManTime); cmd.Parameters.Add(paramUpdateUserSysNo); cmd.Parameters.Add(paramUpdateTime); cmd.Parameters.Add(paramReviewBackNote); cmd.Parameters.Add(paramReviewCauseType); cmd.Parameters.Add(paramReviewBackUserSysNo); cmd.Parameters.Add(paramReviewBackTime); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }