public int AddItem(RMARevertInfo oParam)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
foreach (int registerSysNo in oParam.ItemHash.Keys)
{
RMARevertItemInfo oRevertItem = new RMARevertItemInfo();
oRevertItem.RegisterSysNo = registerSysNo;
oRevertItem.RevertSysNo = oParam.SysNo;
//��Register�ֿ��д��RMA_Revert_Item
int revertStockSysNo = AppConst.IntNull;
DataRow regdr = RMARegisterManager.GetInstance().GetRegisterRow(registerSysNo);
revertStockSysNo = Util.TrimIntNull(regdr["RevertStockSysNo"]);
oRevertItem.StockSysNo = Util.TrimIntNull(revertStockSysNo);
this.InsertRevertItem(oRevertItem);
}
scope.Complete();
return oParam.SysNo;
}
}
public RMARevertInfo Load(int sysno)
{
RMARevertInfo oRevert = new RMARevertInfo();
string sql = "select * from RMA_Revert (NOLOCK) where sysno = " + sysno;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
MapRevert(oRevert, ds.Tables[0].Rows[0]);
}
return oRevert;
}
public void InsertRevert(RMARevertInfo oInfo)
{
new RMARevertDac().InsertRevert(oInfo);
}
public RMARevertInfo GetOutBoundRevert(int sysno)
{
RMARevertInfo orderRevert = new RMARevertInfo();
string sql = "select * from RMA_Revert (NOLOCK) where status = " + (int)AppEnum.RMARevertStatus.Reverted + " and sysno=" + sysno + "";
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
MapRevert(orderRevert, ds.Tables[0].Rows[0]);
}
return orderRevert;
}
private void MapRevert(RMARevertInfo oInfo, DataRow dr)
{
oInfo.Address = dr["Address"].ToString();
oInfo.Contact = dr["Contact"].ToString();
oInfo.CreateTime = Util.TrimDateNull(dr["CreateTime"]);
oInfo.CreateUserSysNo = Util.TrimIntNull(dr["CreateUserSysNo"]);
oInfo.CustomerSysNo = Util.TrimIntNull(dr["CustomerSysNo"]);
oInfo.Note = dr["Note"].ToString();
oInfo.OutTime = Util.TrimDateNull(dr["OutTime"]);
oInfo.OutUserSysNo = Util.TrimIntNull(dr["OutUserSysNo"]);
oInfo.Phone = dr["Phone"].ToString();
oInfo.RevertID = dr["RevertID"].ToString();
oInfo.ShipType = Util.TrimIntNull(dr["ShipType"]);
oInfo.Status = Util.TrimIntNull(dr["Status"]);
oInfo.SysNo = Util.TrimIntNull(dr["SysNo"]);
oInfo.ZIP = dr["ZIP"].ToString();
oInfo.SOSysNo = Util.TrimIntNull(dr["SOSysNo"]);
oInfo.LocationStatus = Util.TrimIntNull(dr["LocationStatus"]);
oInfo.AddressAreaSysNo = Util.TrimIntNull(dr["AddressAreaSysNo"]);
oInfo.PackageID = dr["PackageID"].ToString();
oInfo.FreightUserSysNo = Util.TrimIntNull(dr["FreightUserSysNo"]);
oInfo.SetDeliveryManTime = Util.TrimDateNull(dr["SetDeliveryManTime"]);
oInfo.CheckQtyUserSysNo = Util.TrimIntNull(dr["CheckQtyUserSysNo"]);
oInfo.CheckQtyTime = Util.TrimDateNull(dr["CheckQtyTime"]);
oInfo.IsPrintPackageCover = Util.TrimIntNull(dr["IsPrintPackageCover"]);
oInfo.IsConfirmAddress = Util.TrimIntNull(dr["IsConfirmAddress"]);
}
public int InsertRevert(RMARevertInfo oParam)
{
string sql = @"INSERT INTO RMA_Revert
(
SysNo, RevertID, CustomerSysNo, CreateTime,
CreateUserSysNo, ZIP, Address, Contact,
Phone, ShipType, OutTime, OutUserSysNo,
Note, Status ,SOSysNo ,LocationStatus,AddressAreaSysNo,PackageID,FreightUserSysNo, SetDeliveryManTime,CheckQtyUserSysNo,
CheckQtyTime,IsPrintPackageCover,IsConfirmAddress
)
VALUES (
@SysNo, @RevertID, @CustomerSysNo, @CreateTime,
@CreateUserSysNo, @ZIP, @Address, @Contact,
@Phone, @ShipType, @OutTime, @OutUserSysNo,
@Note, @Status ,@SOSysNo , @LocationStatus ,@AddressAreaSysNo,@PackageID ,@FreightUserSysNo, @SetDeliveryManTime,@CheckQtyUserSysNo,
@CheckQtyTime, @IsPrintPackageCover, @IsConfirmAddress
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4);
SqlParameter paramRevertID = new SqlParameter("@RevertID", SqlDbType.NVarChar,10);
SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int,4);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int,4);
SqlParameter paramZIP = new SqlParameter("@ZIP", SqlDbType.NVarChar,10);
SqlParameter paramAddress = new SqlParameter("@Address", SqlDbType.NVarChar,200);
SqlParameter paramContact = new SqlParameter("@Contact", SqlDbType.NVarChar,50);
SqlParameter paramPhone = new SqlParameter("@Phone", SqlDbType.NVarChar,50);
SqlParameter paramShipType = new SqlParameter("@ShipType", SqlDbType.Int,4);
SqlParameter paramOutTime = new SqlParameter("@OutTime", SqlDbType.DateTime);
SqlParameter paramOutUserSysNo = new SqlParameter("@OutUserSysNo", SqlDbType.Int,4);
SqlParameter paramNote = new SqlParameter("@Note", SqlDbType.NVarChar,200);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4);
SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int,4);
SqlParameter paramLocationStatus = new SqlParameter("@LocationStatus", SqlDbType.Int, 4);
SqlParameter paramAddressAreaSysNo = new SqlParameter("@AddressAreaSysNo",SqlDbType.Int,4);
SqlParameter paramPackageID = new SqlParameter("@PackageID", SqlDbType.NVarChar, 50);
SqlParameter paramFreightUserSysNo = new SqlParameter("@FreightUserSysNo", SqlDbType.Int,4);
SqlParameter paramSetDeliveryManTime = new SqlParameter("@SetDeliveryManTime", SqlDbType.DateTime);
SqlParameter paramCheckQtyUserSysNo = new SqlParameter("@CheckQtyUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCheckQtyTime = new SqlParameter("@CheckQtyTime", SqlDbType.DateTime);
SqlParameter paramIsPrintPackageCover = new SqlParameter("@IsPrintPackageCover", SqlDbType.Int, 4);
SqlParameter paramIsConfirmAddress = new SqlParameter("@IsConfirmAddress", SqlDbType.Int, 4);
if ( oParam.SysNo != AppConst.IntNull)
paramSysNo.Value = oParam.SysNo;
else
paramSysNo.Value = System.DBNull.Value;
if ( oParam.RevertID != AppConst.StringNull)
paramRevertID.Value = oParam.RevertID;
else
paramRevertID.Value = System.DBNull.Value;
if ( oParam.CustomerSysNo != AppConst.IntNull)
paramCustomerSysNo.Value = oParam.CustomerSysNo;
else
paramCustomerSysNo.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.ZIP != AppConst.StringNull)
paramZIP.Value = oParam.ZIP;
else
paramZIP.Value = System.DBNull.Value;
if ( oParam.Address != AppConst.StringNull)
paramAddress.Value = oParam.Address;
else
paramAddress.Value = System.DBNull.Value;
if ( oParam.Contact != AppConst.StringNull)
paramContact.Value = oParam.Contact;
else
paramContact.Value = System.DBNull.Value;
if ( oParam.Phone != AppConst.StringNull)
paramPhone.Value = oParam.Phone;
else
paramPhone.Value = System.DBNull.Value;
if ( oParam.ShipType != AppConst.IntNull)
paramShipType.Value = oParam.ShipType;
else
paramShipType.Value = System.DBNull.Value;
if ( oParam.OutTime != AppConst.DateTimeNull)
paramOutTime.Value = oParam.OutTime;
else
paramOutTime.Value = System.DBNull.Value;
if ( oParam.OutUserSysNo != AppConst.IntNull)
paramOutUserSysNo.Value = oParam.OutUserSysNo;
else
paramOutUserSysNo.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;
if ( oParam.SOSysNo != AppConst.IntNull)
paramSOSysNo.Value = oParam.SOSysNo;
else
paramSOSysNo.Value = System.DBNull.Value;
if (oParam.LocationStatus != AppConst.IntNull)
paramLocationStatus.Value = oParam.LocationStatus;
else
paramLocationStatus.Value = System.DBNull.Value;
if (oParam.AddressAreaSysNo != AppConst.IntNull)
paramAddressAreaSysNo.Value = oParam.AddressAreaSysNo;
else
paramAddressAreaSysNo.Value = System.DBNull.Value;
if (oParam.PackageID != AppConst.StringNull)
paramPackageID.Value = oParam.PackageID;
else
paramPackageID.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.CheckQtyUserSysNo != AppConst.IntNull)
paramCheckQtyUserSysNo.Value = oParam.CheckQtyUserSysNo;
else
paramCheckQtyUserSysNo.Value = System.DBNull.Value;
if (oParam.CheckQtyTime != AppConst.DateTimeNull)
paramCheckQtyTime.Value = oParam.CheckQtyTime;
else
paramCheckQtyTime.Value = System.DBNull.Value;
if (oParam.IsPrintPackageCover != AppConst.IntNull)
paramIsPrintPackageCover.Value = oParam.IsPrintPackageCover;
else
paramIsPrintPackageCover.Value = System.DBNull.Value;
if (oParam.IsConfirmAddress != AppConst.IntNull)
paramIsConfirmAddress.Value = oParam.IsConfirmAddress;
else
paramIsConfirmAddress.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramRevertID);
cmd.Parameters.Add(paramCustomerSysNo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramZIP);
cmd.Parameters.Add(paramAddress);
cmd.Parameters.Add(paramContact);
cmd.Parameters.Add(paramPhone);
cmd.Parameters.Add(paramShipType);
cmd.Parameters.Add(paramOutTime);
cmd.Parameters.Add(paramOutUserSysNo);
cmd.Parameters.Add(paramNote);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramSOSysNo);
cmd.Parameters.Add(paramLocationStatus);
cmd.Parameters.Add(paramAddressAreaSysNo);
cmd.Parameters.Add(paramPackageID);
cmd.Parameters.Add(paramFreightUserSysNo);
cmd.Parameters.Add(paramSetDeliveryManTime);
cmd.Parameters.Add(paramCheckQtyUserSysNo);
cmd.Parameters.Add(paramCheckQtyTime);
cmd.Parameters.Add(paramIsPrintPackageCover);
cmd.Parameters.Add(paramIsConfirmAddress);
return SqlHelper.ExecuteNonQuery(cmd);
}