/// <summary>
/// ����rma��
/// </summary>
/// <param name="rmaInfo"></param>
public void AddRMA(RMARequestInfo rmaInfo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
rmaInfo.SysNo = SequenceDac.GetInstance().Create("RMA_Request_Sequence");
rmaInfo.RequestID = this.BuildRMAID(rmaInfo.SysNo);
rmaInfo.Status = (int)AppEnum.RMAStatus.Origin;
this.InsertRequest(rmaInfo);
foreach (RMARegisterInfo rmaItem in rmaInfo.ItemHash.Values)
{
rmaItem.SysNo = SequenceDac.GetInstance().Create("RMA_Register_Sequence");
rmaItem.Status = (int)AppEnum.RMARequestStatus.Orgin;
rmaItem.OwnBy = (int)AppEnum.RMAOwnBy.Origin;
rmaItem.Location = (int)AppEnum.RMALocation.Origin;
RMARegisterManager.GetInstance().InsertRegister(rmaItem);
RMARequestItemInfo rmaiteminfo = new RMARequestItemInfo();
rmaiteminfo.RegisterSysNo = rmaItem.SysNo;
rmaiteminfo.RequestSysNo = rmaInfo.SysNo;
this.InsertRequestItem(rmaiteminfo);
}
scope.Complete();
}
//SendMail(rmaInfo);
}
/// <summary>
/// Insert Request
/// </summary>
/// <param name="oInfo"></param>
public void InsertRequest(RMARequestInfo oInfo)
{
new RMARequestDac().InsertRequest(oInfo);
}
public RMARequestInfo BuildRMAfromSO(int soSysNo)
{
// if(!this.IfExistOpenedRMA(soSysNo))
// {
RMARequestInfo rmaInfo = new RMARequestInfo();
SOInfo soInfo = SaleManager.GetInstance().LoadSO(soSysNo);
if (soInfo.PositiveSOSysNo != AppConst.IntNull)
throw new BizException("��SOΪ����ȡ������ĸ����۵���RMA����ʧ�ܣ�");
if (soInfo != null && soInfo.Status == (int)AppEnum.SOStatus.OutStock)
{
rmaInfo.SOSysNo = soInfo.SysNo;
rmaInfo.CustomerSysNo = soInfo.CustomerSysNo;
CustomerInfo oCustomer = CustomerManager.GetInstance().Load(soInfo.CustomerSysNo);
rmaInfo.Address = soInfo.ReceiveAddress != AppConst.StringNull ? soInfo.ReceiveAddress : (oCustomer.ReceiveAddress != AppConst.StringNull ? oCustomer.ReceiveAddress : (oCustomer.DwellAddress != AppConst.StringNull ? oCustomer.DwellAddress : "��"));
rmaInfo.Contact = soInfo.ReceiveContact != AppConst.StringNull ? soInfo.ReceiveContact : (oCustomer.ReceiveContact != AppConst.StringNull ? oCustomer.ReceiveContact : (oCustomer.CustomerName != AppConst.StringNull ? oCustomer.CustomerName : "��"));
rmaInfo.CreateTime = DateTime.Now;
if (soInfo.ReceivePhone != AppConst.StringNull)
rmaInfo.Phone = soInfo.ReceivePhone;
if (soInfo.ReceiveCellPhone != AppConst.StringNull)
rmaInfo.Phone += " " + soInfo.ReceiveCellPhone;
//rmaInfo.Phone = soInfo.ReceivePhone != AppConst.StringNull ? soInfo.ReceivePhone : (oCustomer.ReceiveCellPhone != AppConst.StringNull ? oCustomer.ReceiveCellPhone : (oCustomer.ReceivePhone != AppConst.StringNull ? oCustomer.ReceivePhone : (oCustomer.CellPhone != AppConst.StringNull ? oCustomer.CellPhone : (oCustomer.Phone != AppConst.StringNull ? oCustomer.Phone : "��"))));
rmaInfo.AreaSysNo = soInfo.ReceiveAreaSysNo; //this AreaSysNo field is added lastest.
rmaInfo.Zip = soInfo.ReceiveZip;
if (soInfo.ItemHash.Count > 0)
{
int j = 0;
foreach (SOItemInfo soItem in soInfo.ItemHash.Values)
{
if (soItem.ProductType == (int)AppEnum.SOItemType.Promotion)
continue; //�����ų��Ż�ȯ��
if (soItem.Quantity > 0)
{
Hashtable htTemp = new Hashtable(1);
htTemp.Add("SOItemSysNo",soItem.SysNo.ToString());
DataSet dsTemp = SaleManager.GetInstance().GetSOProductIDSysNoList(htTemp);
int rowCount = 0;
if(Util.HasMoreRow(dsTemp))
rowCount = dsTemp.Tables[0].Rows.Count;
for (int i = 1; i <= soItem.Quantity; i++)
{
RMARegisterInfo rmaItem = new RMARegisterInfo();
rmaItem.ProductSysNo = soItem.ProductSysNo;
rmaItem.RequestType = (int)AppEnum.RMARequestType.Maintain;
if (i <= rowCount)
{
int POSysNo = Util.TrimIntNull(dsTemp.Tables[0].Rows[i-1]["posysno"].ToString());
int ProductIDSysNo = Util.TrimIntNull(dsTemp.Tables[0].Rows[i - 1]["ProductIDSysNo"]);
rmaItem.ProductIDSysNo = ProductIDSysNo;
if (POSysNo > 0)
{
rmaItem.SOItemPODesc = "�ɹ�����:<a href=\"javascript:openWindowS2('../Purchase/POSheet.aspx?sysno=" + POSysNo + "&opt=view')" + "\" >" + POSysNo + "</a><br>";
}
else if (ProductIDSysNo > 0)
{
rmaItem.SOItemPODesc = "��Ʒ���к�:<a href=\"javascript:openWindowS2('../Basic/ProductID.aspx?sysno=" + ProductIDSysNo + "')" + "\" >" + ProductIDSysNo + "</a><br>";
}
}
rmaInfo.ItemHash.Add(j, rmaItem);
j = j + 1;
}
}
}
}
}
else
rmaInfo = null;
return rmaInfo;
// }
// else
// throw new BizException("�����۵��Ѿ�����һ�ű����ڴ����У�������������ύ�µı������룬����ϵORS�̳ǿͷ�");
}
public string CheckSO(RMARequestInfo oInfo)
{
//�Ƿ��Ѵ��ڸ�SO�и���Ʒ��RMA��
//ע�⣺���ǵ�SO�ж����Ʒ��������ж��Ѵ��ڵ���RMA�������Ʒ���������С��SO����Ʒ���������Ծɿ������RMA����
string result = AppConst.StringNull;
foreach (RMARegisterInfo oRegister in oInfo.ItemHash.Values)
{
string sql = @"select count(*) as rmaqty
from rma_request (NOLOCK)
inner join rma_request_item (NOLOCK) on rma_request.sysno = rma_request_item.requestsysno
inner join rma_register (NOLOCK) on rma_register.sysno = rma_request_item.registersysno
where rma_request.sosysno = " + oInfo.SOSysNo + " and rma_register.productsysno=" + oRegister.ProductSysNo
+ " and (rma_register.status = " + (int)AppEnum.RMARequestStatus.Orgin + " or rma_register.status = " + (int)AppEnum.RMARequestStatus.Handling + ")";
DataSet ds = SqlHelper.ExecuteDataSet(sql);
DataRow dr = ds.Tables[0].Rows[0];
int rmaqty = Util.TrimIntNull(dr["rmaqty"]);
string sqlso = @"select quantity
from v_so_item (NOLOCK)
where v_so_item.sosysno = " + oInfo.SOSysNo + " and productsysno=" + oRegister.ProductSysNo;
DataSet dsso = SqlHelper.ExecuteDataSet(sqlso);
int soqty = 0;
if (Util.HasMoreRow(dsso))
{
DataRow drso = dsso.Tables[0].Rows[0];
soqty = Util.TrimIntNull(drso["quantity"]);
}
if (rmaqty >= soqty)
{
ProductBasicInfo oProduct = ProductManager.GetInstance().LoadBasic(oRegister.ProductSysNo);
if (result != AppConst.StringNull)
result += "<br>";
result += oProduct.ProductName + "(" + oProduct.ProductID + ")";
}
}
return result;
}
private RMARequestInfo MapRequest(DataRow dr)
{
RMARequestInfo oInfo = new RMARequestInfo();
oInfo.Address = dr["Address"].ToString();
oInfo.Contact = dr["Contact"].ToString();
oInfo.CreateTime = Util.TrimDateNull(dr["CreateTime"]);
oInfo.CreateUserSysNo = Util.TrimIntNull(dr["CreateUserSysNo"]);
oInfo.CanDoorGet = Util.TrimIntNull(dr["CanDoorGet"]);
oInfo.DoorGetFee = Util.TrimDecimalNull(dr["DoorGetFee"]);
oInfo.CustomerSysNo = Util.TrimIntNull(dr["CustomerSysNo"]);
oInfo.Memo = dr["Memo"].ToString();
oInfo.Note = dr["Note"].ToString();
oInfo.Phone = dr["Phone"].ToString();
oInfo.RecvTime = Util.TrimDateNull(dr["RecvTime"]);
oInfo.RecvUserSysNo = Util.TrimIntNull(dr["RecvUserSysNo"]);
oInfo.RequestID = dr["RequestID"].ToString();
oInfo.SOSysNo = Util.TrimIntNull(dr["SOSysNo"]);
oInfo.Status = Util.TrimIntNull(dr["Status"]);
oInfo.SysNo = Util.TrimIntNull(dr["SysNo"]);
oInfo.ETakeDate = Util.TrimDateNull(dr["ETakeDate"]);
oInfo.AreaSysNo = Util.TrimIntNull(dr["AreaSysNo"]);
oInfo.FreightUserSysNo = Util.TrimIntNull(dr["FreightUserSysNo"]);
oInfo.SetDeliveryManTime = Util.TrimDateNull(dr["SetDeliveryManTime"]);
oInfo.IsRevertAddress = Util.TrimIntNull(dr["IsRevertAddress"]);
oInfo.RevertAddress = Util.TrimNull(dr["RevertAddress"]);
oInfo.RevertAreaSysNo = Util.TrimIntNull(dr["RevertAreaSysNo"]);
oInfo.RevertZip = Util.TrimNull(dr["RevertZiP"]);
oInfo.Zip = Util.TrimNull(dr["Zip"]);
oInfo.RevertContact = Util.TrimNull(dr["RevertContact"]);
oInfo.RevertContactPhone = Util.TrimNull(dr["RevertContactPhone"]);
oInfo.ReceiveType = Util.TrimIntNull(dr["ReceiveType"]);
return oInfo;
}
/// <summary>
/// SendMail to customer when a rma request order is created successfully
/// </summary>
/// <param name="sysno"></param>
/// <returns></returns>
public void SendMail(RMARequestInfo rmaInfo)
{
//get mail information
string mailaddress;
string mailsubject;
string mailbodyinfo;
string requestId;
int sosysno;
string strSOID;
string requestInfo;
string allRequestInfo = null;
CustomerInfo oCustomer = new CustomerInfo();
oCustomer = CustomerManager.GetInstance().Load(rmaInfo.CustomerSysNo);
if (Util.TrimNull(oCustomer.Email) == AppConst.StringNull)
return;
mailaddress = oCustomer.Email;
requestId = rmaInfo.RequestID.ToString();
sosysno = Util.TrimIntNull(rmaInfo.SOSysNo);
strSOID = GetSOIDFromSOMaster(sosysno);
mailsubject = "���ѳɹ����뷵��" + requestId + " ";
mailbodyinfo = @"<span style='font-size:12.0pt;font-family:����Ҧ��'>��ORS�̳����û���<br>
<br>
���ã�
<br>
<br>
���ѳɹ�������������RMA��������@requestID������������Ʒʱ��������Ӧ��Ʒ�ķ�Ʊ����ӡ����Ч����ͬʱ��֤��Ʒ����������ԭ���İ�װ��û��ֲᣬ�������ɳ����ṩ��һ�и����������Ʒijһ���ֶ�ʧ������ORS�̳ǵı������������ȫ���з�Ʊ������֮ǰ������������Ʒ�ͽ����ҽ��б��ޡ�ORS�̳������е��û����ĸ�����Ʊ�������ķ��ã����ڲ�Ʒ��ȫ����ɵı�������ORS�̳������е����Ρ�
<br><br>
RMA ��������ϸĿ¼<br>
<br>
�����ţ� SO @SOID��<br> @allRequestInfo
<br>
����ѡ���ޣ���ORS�̳���ɱ����̺���ԭ�����ĵ�ַ����������
�����ĵ�ַ�б䶯���뼰ʱ�����ǵĿͷ����� 400-820-1878
ȡ����ϵ���·�����ַ�����ַδ��ʱ�ĸ��¶����µ�����Ⱥ����ORS�̳����Ų�����<br>
<br>
������ʱ�Ľ����������ʾ���ͨ����*��������ʽ����ORS�̳�����������ͨ��������**��ORS�̳Ǹ������ǻ����յ������Ի��ֵ���ʽ���ʼķ��ô�������ORS�̳������ʻ��С�<br>
*
��ָƽ�ʰ�����ʽ�����ǿ�ݰ�����EMS������ͻ������������䷽ʽ�����˷��ɿͻ��Լ�����<br>
** �������ʾ��ʷѣ���������װ�ѡ�
�Һŷѡ����۷ѣ�����Ҫ�ṩ�ʾַ�Ʊ���վݲ�����ΪORS�̳dzе��˷ѵ�ƾ֤��
��Ʒά�ú������ǽ����ｻ���ͻ���<br>
<br>
ORS�̳����յ����ķ�������,ORS�̳������ϸ��չ�������������д����������Ҫ������ϵORS�̳����ͷ����� 400-820-1878
��һ������ ����8��30 �� ����17��30�� <br>
<br>
<br>
лл֧�֣�<br>
<br>
<br>
�й�ORS�̳���<br><br></span>";
DataSet registerInfo = RMARequestManager.GetInstance().GetRegisterByRequest(Util.TrimIntNull(rmaInfo.SysNo));
foreach (DataRow row in registerInfo.Tables[0].Rows)
{
requestInfo = @"��Ʒ�ţ� @ProductId ��@ProductName��<br>
���������ࣺ@RequestType<br>
����ԭ��/����������@reason<br> ";
string requesttypeDesc = AppEnum.GetRMARequestType(row["RequestType"]);
requestInfo = requestInfo.Replace("@ProductId", row["ProductId"].ToString()).Replace("@ProductName", row["ProductName"].ToString()).Replace("@RequestType", requesttypeDesc.ToString()).Replace("@reason", row["CustomerDesc"].ToString());
allRequestInfo = allRequestInfo + requestInfo;
}
mailbodyinfo = mailbodyinfo.Replace("@requestID", requestId);
mailbodyinfo = mailbodyinfo.Replace("@SOID", strSOID);
mailbodyinfo = mailbodyinfo.Replace("@allRequestInfo", allRequestInfo.ToString());
//send mail
EmailInfo oMail = new EmailInfo();
oMail.MailAddress = mailaddress;
oMail.MailSubject = mailsubject;
oMail.MailBody = mailbodyinfo;
oMail.Status = (int)AppEnum.TriStatus.Origin;
//EmailManager.GetInstance().InsertEmail(oMail);
}
public int InsertRequest(RMARequestInfo oParam)
{
string sql = @"INSERT INTO RMA_Request
(
SysNo, SOSysNo, RequestID, CreateTime,
CustomerSysNo, CreateUserSysNo, CanDoorGet, DoorGetFee,
Address, Contact, Phone, Zip,
RecvTime, RecvUserSysNo, Note, Memo,
Status, ETakeDate, AreaSysNo, CustomerSendTime,
IsRejectRMA, FreightUserSysNo, SetDeliveryManTime, IsRevertAddress,
RevertAddress, RevertAreaSysNo, RevertZip,RevertContact,RevertContactPhone,ReceiveType
)
VALUES (
@SysNo, @SOSysNo, @RequestID, @CreateTime,
@CustomerSysNo, @CreateUserSysNo, @CanDoorGet, @DoorGetFee,
@Address, @Contact, @Phone, @Zip,
@RecvTime, @RecvUserSysNo, @Note, @Memo,
@Status, @ETakeDate, @AreaSysNo, @CustomerSendTime,
@IsRejectRMA, @FreightUserSysNo, @SetDeliveryManTime, @IsRevertAddress,
@RevertAddress, @RevertAreaSysNo, @RevertZip,@RevertContact,@RevertContactPhone,@ReceiveType
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int, 4);
SqlParameter paramRequestID = new SqlParameter("@RequestID", SqlDbType.NVarChar, 10);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCanDoorGet = new SqlParameter("@CanDoorGet", SqlDbType.Int, 4);
SqlParameter paramDoorGetFee = new SqlParameter("@DoorGetFee", SqlDbType.Decimal, 9);
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 paramZip = new SqlParameter("@Zip", SqlDbType.VarChar, 50);
SqlParameter paramRecvTime = new SqlParameter("@RecvTime", SqlDbType.DateTime);
SqlParameter paramRecvUserSysNo = new SqlParameter("@RecvUserSysNo", SqlDbType.Int, 4);
SqlParameter paramNote = new SqlParameter("@Note", SqlDbType.NVarChar, 200);
SqlParameter paramMemo = new SqlParameter("@Memo", SqlDbType.NVarChar, 200);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
SqlParameter paramETakeDate = new SqlParameter("@ETakeDate", SqlDbType.DateTime);
SqlParameter paramAreaSysNo = new SqlParameter("@AreaSysNo", SqlDbType.Int, 4);
SqlParameter paramCustomerSendTime = new SqlParameter("@CustomerSendTime", SqlDbType.DateTime);
SqlParameter paramIsRejectRMA = new SqlParameter("@IsRejectRMA", SqlDbType.Int, 4);
SqlParameter paramFreightUserSysNo = new SqlParameter("@FreightUserSysNo", SqlDbType.Int, 4);
SqlParameter paramSetDeliveryManTime = new SqlParameter("@SetDeliveryManTime", SqlDbType.DateTime);
SqlParameter paramIsRevertAddress = new SqlParameter("@IsRevertAddress", SqlDbType.Int, 4);
SqlParameter paramRevertAddress = new SqlParameter("@RevertAddress", SqlDbType.NVarChar, 200);
SqlParameter paramRevertAreaSysNo = new SqlParameter("@RevertAreaSysNo", SqlDbType.Int, 4);
SqlParameter paramRevertZip = new SqlParameter("@RevertZip", SqlDbType.NVarChar, 50);
SqlParameter paramRevertContact = new SqlParameter("@RevertContact", SqlDbType.NVarChar, 50);
SqlParameter paramRevertContactPhone= new SqlParameter("@RevertContactPhone", SqlDbType.NVarChar, 50);
SqlParameter paramReceiveType = new SqlParameter("@ReceiveType", SqlDbType.Int, 4);
if (oParam.SysNo != AppConst.IntNull)
paramSysNo.Value = oParam.SysNo;
else
paramSysNo.Value = System.DBNull.Value;
if (oParam.SOSysNo != AppConst.IntNull)
paramSOSysNo.Value = oParam.SOSysNo;
else
paramSOSysNo.Value = System.DBNull.Value;
if (oParam.RequestID != AppConst.StringNull)
paramRequestID.Value = oParam.RequestID;
else
paramRequestID.Value = System.DBNull.Value;
if (oParam.CreateTime != AppConst.DateTimeNull)
paramCreateTime.Value = oParam.CreateTime;
else
paramCreateTime.Value = System.DBNull.Value;
if (oParam.CustomerSysNo != AppConst.IntNull)
paramCustomerSysNo.Value = oParam.CustomerSysNo;
else
paramCustomerSysNo.Value = System.DBNull.Value;
if (oParam.CreateUserSysNo != AppConst.IntNull)
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
else
paramCreateUserSysNo.Value = System.DBNull.Value;
if (oParam.CanDoorGet != AppConst.IntNull)
paramCanDoorGet.Value = oParam.CanDoorGet;
else
paramCanDoorGet.Value = System.DBNull.Value;
if (oParam.DoorGetFee != AppConst.DecimalNull)
paramDoorGetFee.Value = oParam.DoorGetFee;
else
paramDoorGetFee.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.Zip != AppConst.StringNull)
paramZip.Value = oParam.Zip;
else
paramZip.Value = System.DBNull.Value;
if (oParam.RecvTime != AppConst.DateTimeNull)
paramRecvTime.Value = oParam.RecvTime;
else
paramRecvTime.Value = System.DBNull.Value;
if (oParam.RecvUserSysNo != AppConst.IntNull)
paramRecvUserSysNo.Value = oParam.RecvUserSysNo;
else
paramRecvUserSysNo.Value = System.DBNull.Value;
if (oParam.Note != AppConst.StringNull)
paramNote.Value = oParam.Note;
else
paramNote.Value = System.DBNull.Value;
if (oParam.Memo != AppConst.StringNull)
paramMemo.Value = oParam.Memo;
else
paramMemo.Value = System.DBNull.Value;
if (oParam.Status != AppConst.IntNull)
paramStatus.Value = oParam.Status;
else
paramStatus.Value = System.DBNull.Value;
if (oParam.ETakeDate != AppConst.DateTimeNull)
paramETakeDate.Value = oParam.ETakeDate;
else
paramETakeDate.Value = System.DBNull.Value;
if (oParam.AreaSysNo != AppConst.IntNull)
paramAreaSysNo.Value = oParam.AreaSysNo;
else
paramAreaSysNo.Value = System.DBNull.Value;
if (oParam.CustomerSendTime != AppConst.DateTimeNull)
paramCustomerSendTime.Value = oParam.CustomerSendTime;
else
paramCustomerSendTime.Value = System.DBNull.Value;
if (oParam.IsRejectRMA != AppConst.IntNull)
paramIsRejectRMA.Value = oParam.IsRejectRMA;
else
paramIsRejectRMA.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.IsRevertAddress != AppConst.IntNull)
paramIsRevertAddress.Value = oParam.IsRevertAddress;
else
paramIsRevertAddress.Value = System.DBNull.Value;
if (oParam.RevertAddress != AppConst.StringNull)
paramRevertAddress.Value = oParam.RevertAddress;
else
paramRevertAddress.Value = System.DBNull.Value;
if (oParam.RevertAreaSysNo != AppConst.IntNull)
paramRevertAreaSysNo.Value = oParam.RevertAreaSysNo;
else
paramRevertAreaSysNo.Value = System.DBNull.Value;
if (oParam.RevertZip != AppConst.StringNull)
paramRevertZip.Value = oParam.RevertZip;
else
paramRevertZip.Value = System.DBNull.Value;
if (oParam.RevertContact != AppConst.StringNull)
paramRevertContact.Value = oParam.RevertContact;
else
paramRevertContact.Value = System.DBNull.Value;
if (oParam.RevertContactPhone != AppConst.StringNull)
paramRevertContactPhone.Value = System.DBNull.Value;
if (oParam.ReceiveType != AppConst.IntNull)
paramReceiveType.Value = oParam.ReceiveType;
else
paramReceiveType.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramSOSysNo);
cmd.Parameters.Add(paramRequestID);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramCustomerSysNo);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCanDoorGet);
cmd.Parameters.Add(paramDoorGetFee);
cmd.Parameters.Add(paramAddress);
cmd.Parameters.Add(paramContact);
cmd.Parameters.Add(paramPhone);
cmd.Parameters.Add(paramZip);
cmd.Parameters.Add(paramRecvTime);
cmd.Parameters.Add(paramRecvUserSysNo);
cmd.Parameters.Add(paramNote);
cmd.Parameters.Add(paramMemo);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramETakeDate);
cmd.Parameters.Add(paramAreaSysNo);
cmd.Parameters.Add(paramCustomerSendTime);
cmd.Parameters.Add(paramIsRejectRMA);
cmd.Parameters.Add(paramFreightUserSysNo);
cmd.Parameters.Add(paramSetDeliveryManTime);
cmd.Parameters.Add(paramIsRevertAddress);
cmd.Parameters.Add(paramRevertAddress);
cmd.Parameters.Add(paramRevertAreaSysNo);
cmd.Parameters.Add(paramRevertZip);
cmd.Parameters.Add(paramRevertContact);
cmd.Parameters.Add(paramRevertContactPhone);
cmd.Parameters.Add(paramReceiveType);
return SqlHelper.ExecuteNonQuery(cmd);
}