public RMASendAccessoryInfo Load(int sysno)
{
try
{
RMASendAccessoryInfo oInfo = new RMASendAccessoryInfo();
string sql = "select * from RMA_SendAccessory (NOLOCK) where sysno=" + sysno;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
DataRow dr = ds.Tables[0].Rows[0];
map(oInfo, dr);
string itemSql = @"select RMA_SendAccessory_Item.*
from RMA_SendAccessory_Item (NOLOCK)
inner join RMA_SendAccessory (NOLOCK) on RMA_SendAccessory_Item.SendAccessorySysNo = RMA_SendAccessory.SysNo
where RMA_SendAccessory.sysno=" + sysno;
DataSet itemds = SqlHelper.ExecuteDataSet(itemSql);
if (Util.HasMoreRow(itemds))
{
foreach (DataRow itemdr in itemds.Tables[0].Rows)
{
RMASendAccessoryItemInfo oSAItem = new RMASendAccessoryItemInfo();
mapItem(oSAItem, itemdr);
oInfo.ItemHash.Add(Util.TrimIntNull(itemdr["SysNo"]), oSAItem);
}
}
}
return(oInfo);
}
catch
{
throw new BizException("Load RMASendAccessoryInfo Error!");
}
}
private void mapItem(RMASendAccessoryItemInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.SendAccessorySysNo = Util.TrimIntNull(tempdr["SendAccessorySysNo"]);
oParam.SOSysNo = Util.TrimIntNull(tempdr["SOSysNo"]);
oParam.ProductSysNo = Util.TrimIntNull(tempdr["ProductSysNo"]);
oParam.ProductIDSysNo = Util.TrimIntNull(tempdr["ProductIDSysNo"]);
oParam.NewProductSysNo = Util.TrimIntNull(tempdr["NewProductSysNo"]);
oParam.NewProductQty = Util.TrimIntNull(tempdr["NewProductQty"]);
oParam.NewProductIDSysNo = Util.TrimIntNull(tempdr["NewProductIDSysNo"]);
oParam.AccessoryType = Util.TrimIntNull(tempdr["AccessoryType"]);
oParam.AccessoryName = Util.TrimNull(tempdr["AccessoryName"]);
oParam.SOItemPODesc = Util.TrimNull(tempdr["SOItemPODesc"]);
oParam.Note = Util.TrimNull(tempdr["Note"]);
}
public int DeleteItem(int productSysNo, int saSysNo)
{
int result;
RMASendAccessoryItemInfo saItemInfo = RMASendAccessoryManager.GetInstance().LoadItem(productSysNo, saSysNo);
RMASendAccessoryInfo saInfo = RMASendAccessoryManager.GetInstance().Load(saSysNo);
if (saInfo.Status != (int)AppEnum.RMASendAccessoryStatus.WaitingAudit)
{
throw new BizException("补发附件单不是待审核状态，不能删除相关Item!");
}
else
{
result = new RMASendAccessoryDac().DeleteItem(saItemInfo.SysNo);
}
return(result);
}
public RMASendAccessoryItemInfo LoadItem(int productSysNo, int saSysNo)
{
try
{
RMASendAccessoryItemInfo oInfo = new RMASendAccessoryItemInfo();
string sql = "select * from RMA_SendAccessory_Item (NOLOCK) where productSysNo=" + productSysNo + "and SendAccessorySysNo=" + saSysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
DataRow dr = ds.Tables[0].Rows[0];
mapItem(oInfo, dr);
}
return(oInfo);
}
catch
{
throw new BizException("Load RMASendAccessoryItemInfo Error!");
}
}
public int UpdateItem(RMASendAccessoryItemInfo oParam)
{
string sql = @"UPDATE RMA_SendAccessory_Item SET
SendAccessorySysNo=@SendAccessorySysNo, SOSysNo=@SOSysNo,
ProductSysNo=@ProductSysNo, ProductIDSysNo=@ProductIDSysNo,
NewProductSysNo=@NewProductSysNo, NewProductQty=@NewProductQty,
NewProductIDSysNo=@NewProductIDSysNo, AccessoryType=@AccessoryType,
AccessoryName=@AccessoryName, SOItemPODesc=@SOItemPODesc,
Note=@Note
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramSendAccessorySysNo = new SqlParameter("@SendAccessorySysNo", SqlDbType.Int, 4);
SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int, 4);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4);
SqlParameter paramProductIDSysNo = new SqlParameter("@ProductIDSysNo", SqlDbType.Int, 4);
SqlParameter paramNewProductSysNo = new SqlParameter("@NewProductSysNo", SqlDbType.Int, 4);
SqlParameter paramNewProductQty = new SqlParameter("@NewProductQty", SqlDbType.Int, 4);
SqlParameter paramNewProductIDSysNo = new SqlParameter("@NewProductIDSysNo", SqlDbType.Int, 4);
SqlParameter paramAccessoryType = new SqlParameter("@AccessoryType", SqlDbType.Int, 4);
SqlParameter paramAccessoryName = new SqlParameter("@AccessoryName", SqlDbType.NVarChar, 100);
SqlParameter paramSOItemPODesc = new SqlParameter("@SOItemPODesc", SqlDbType.NVarChar, 200);
SqlParameter paramNote = new SqlParameter("@Note", SqlDbType.NVarChar, 200);
if (oParam.SysNo != AppConst.IntNull)
{
paramSysNo.Value = oParam.SysNo;
}
else
{
paramSysNo.Value = System.DBNull.Value;
}
if (oParam.SendAccessorySysNo != AppConst.IntNull)
{
paramSendAccessorySysNo.Value = oParam.SendAccessorySysNo;
}
else
{
paramSendAccessorySysNo.Value = System.DBNull.Value;
}
if (oParam.SOSysNo != AppConst.IntNull)
{
paramSOSysNo.Value = oParam.SOSysNo;
}
else
{
paramSOSysNo.Value = System.DBNull.Value;
}
if (oParam.ProductSysNo != AppConst.IntNull)
{
paramProductSysNo.Value = oParam.ProductSysNo;
}
else
{
paramProductSysNo.Value = System.DBNull.Value;
}
if (oParam.ProductIDSysNo != AppConst.IntNull)
{
paramProductIDSysNo.Value = oParam.ProductIDSysNo;
}
else
{
paramProductIDSysNo.Value = System.DBNull.Value;
}
if (oParam.NewProductSysNo != AppConst.IntNull)
{
paramNewProductSysNo.Value = oParam.NewProductSysNo;
}
else
{
paramNewProductSysNo.Value = System.DBNull.Value;
}
if (oParam.NewProductQty != AppConst.IntNull)
{
paramNewProductQty.Value = oParam.NewProductQty;
}
else
{
paramNewProductQty.Value = System.DBNull.Value;
}
if (oParam.NewProductIDSysNo != AppConst.IntNull)
{
paramNewProductIDSysNo.Value = oParam.NewProductIDSysNo;
}
else
{
paramNewProductIDSysNo.Value = System.DBNull.Value;
}
if (oParam.AccessoryType != AppConst.IntNull)
{
paramAccessoryType.Value = oParam.AccessoryType;
}
else
{
paramAccessoryType.Value = System.DBNull.Value;
}
if (oParam.AccessoryName != AppConst.StringNull)
{
paramAccessoryName.Value = oParam.AccessoryName;
}
else
{
paramAccessoryName.Value = System.DBNull.Value;
}
if (oParam.SOItemPODesc != AppConst.StringNull)
{
paramSOItemPODesc.Value = oParam.SOItemPODesc;
}
else
{
paramSOItemPODesc.Value = System.DBNull.Value;
}
if (oParam.Note != AppConst.StringNull)
{
paramNote.Value = oParam.Note;
}
else
{
paramNote.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramSendAccessorySysNo);
cmd.Parameters.Add(paramSOSysNo);
cmd.Parameters.Add(paramProductSysNo);
cmd.Parameters.Add(paramProductIDSysNo);
cmd.Parameters.Add(paramNewProductSysNo);
cmd.Parameters.Add(paramNewProductQty);
cmd.Parameters.Add(paramNewProductIDSysNo);
cmd.Parameters.Add(paramAccessoryType);
cmd.Parameters.Add(paramAccessoryName);
cmd.Parameters.Add(paramSOItemPODesc);
cmd.Parameters.Add(paramNote);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public int InsertItem(RMASendAccessoryItemInfo oParam)
{
string sql = @"INSERT INTO RMA_SendAccessory_Item
(
SendAccessorySysNo, SOSysNo, ProductSysNo, ProductIDSysNo,
NewProductSysNo, NewProductQty, NewProductIDSysNo, AccessoryType,
AccessoryName, SOItemPODesc, Note
)
VALUES (
@SendAccessorySysNo, @SOSysNo, @ProductSysNo, @ProductIDSysNo,
@NewProductSysNo, @NewProductQty, @NewProductIDSysNo, @AccessoryType,
@AccessoryName, @SOItemPODesc, @Note
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramSendAccessorySysNo = new SqlParameter("@SendAccessorySysNo", SqlDbType.Int, 4);
SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int, 4);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4);
SqlParameter paramProductIDSysNo = new SqlParameter("@ProductIDSysNo", SqlDbType.Int, 4);
SqlParameter paramNewProductSysNo = new SqlParameter("@NewProductSysNo", SqlDbType.Int, 4);
SqlParameter paramNewProductQty = new SqlParameter("@NewProductQty", SqlDbType.Int, 4);
SqlParameter paramNewProductIDSysNo = new SqlParameter("@NewProductIDSysNo", SqlDbType.Int, 4);
SqlParameter paramAccessoryType = new SqlParameter("@AccessoryType", SqlDbType.Int, 4);
SqlParameter paramAccessoryName = new SqlParameter("@AccessoryName", SqlDbType.NVarChar, 100);
SqlParameter paramSOItemPODesc = new SqlParameter("@SOItemPODesc", SqlDbType.NVarChar, 200);
SqlParameter paramNote = new SqlParameter("@Note", SqlDbType.NVarChar, 200);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.SendAccessorySysNo != AppConst.IntNull)
{
paramSendAccessorySysNo.Value = oParam.SendAccessorySysNo;
}
else
{
paramSendAccessorySysNo.Value = System.DBNull.Value;
}
if (oParam.SOSysNo != AppConst.IntNull)
{
paramSOSysNo.Value = oParam.SOSysNo;
}
else
{
paramSOSysNo.Value = System.DBNull.Value;
}
if (oParam.ProductSysNo != AppConst.IntNull)
{
paramProductSysNo.Value = oParam.ProductSysNo;
}
else
{
paramProductSysNo.Value = System.DBNull.Value;
}
if (oParam.ProductIDSysNo != AppConst.IntNull)
{
paramProductIDSysNo.Value = oParam.ProductIDSysNo;
}
else
{
paramProductIDSysNo.Value = System.DBNull.Value;
}
if (oParam.NewProductSysNo != AppConst.IntNull)
{
paramNewProductSysNo.Value = oParam.NewProductSysNo;
}
else
{
paramNewProductSysNo.Value = System.DBNull.Value;
}
if (oParam.NewProductQty != AppConst.IntNull)
{
paramNewProductQty.Value = oParam.NewProductQty;
}
else
{
paramNewProductQty.Value = System.DBNull.Value;
}
if (oParam.NewProductIDSysNo != AppConst.IntNull)
{
paramNewProductIDSysNo.Value = oParam.NewProductIDSysNo;
}
else
{
paramNewProductIDSysNo.Value = System.DBNull.Value;
}
if (oParam.AccessoryType != AppConst.IntNull)
{
paramAccessoryType.Value = oParam.AccessoryType;
}
else
{
paramAccessoryType.Value = System.DBNull.Value;
}
if (oParam.AccessoryName != AppConst.StringNull)
{
paramAccessoryName.Value = oParam.AccessoryName;
}
else
{
paramAccessoryName.Value = System.DBNull.Value;
}
if (oParam.SOItemPODesc != AppConst.StringNull)
{
paramSOItemPODesc.Value = oParam.SOItemPODesc;
}
else
{
paramSOItemPODesc.Value = System.DBNull.Value;
}
if (oParam.Note != AppConst.StringNull)
{
paramNote.Value = oParam.Note;
}
else
{
paramNote.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramSendAccessorySysNo);
cmd.Parameters.Add(paramSOSysNo);
cmd.Parameters.Add(paramProductSysNo);
cmd.Parameters.Add(paramProductIDSysNo);
cmd.Parameters.Add(paramNewProductSysNo);
cmd.Parameters.Add(paramNewProductQty);
cmd.Parameters.Add(paramNewProductIDSysNo);
cmd.Parameters.Add(paramAccessoryType);
cmd.Parameters.Add(paramAccessoryName);
cmd.Parameters.Add(paramSOItemPODesc);
cmd.Parameters.Add(paramNote);
return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
}
public RMASendAccessoryInfo BuildfromSO(int soSysNo)
{
RMASendAccessoryInfo rmaInfo = new RMASendAccessoryInfo();
SOInfo soInfo = SaleManager.GetInstance().LoadSO(soSysNo);
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.AreaSysNo = soInfo.ReceiveAreaSysNo;
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++)
{
RMASendAccessoryItemInfo rmaItem = new RMASendAccessoryItemInfo();
rmaItem.ProductSysNo = soItem.ProductSysNo;
rmaItem.AccessoryType =
rmaItem.AccessoryType = (int)AppEnum.RMAAccessoryType.Accessory;
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"]);
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>";
}
rmaItem.ProductIDSysNo = ProductIDSysNo;
rmaItem.AccessoryType = (int)AppEnum.RMAAccessoryType.Accessory;
}
rmaInfo.ItemHash.Add(j, rmaItem);
j = j + 1;
}
}
}
}
}
else
{
rmaInfo = null;
}
return(rmaInfo);
}
public void InsertSentAccessoryItem(RMASendAccessoryItemInfo oInfo)
{
new RMASendAccessoryDac().InsertItem(oInfo);
}
public void UpdateItem(RMASendAccessoryItemInfo oParam)
{
new RMASendAccessoryDac().UpdateItem(oParam);
}
