private int CalcReturnStatus(LendInfo oParam)
{
if (oParam.itemHash.Count == 0)
{
throw new BizException("no lend item record");
}
if (oParam.returnHash.Count == 0)
{
return((int)AppEnum.LendStatus.OutStock);
}
//oParam.itemHash.Count > oParam.returnHash.Count 如果增加商品种类判断可以优化，暂时不做了
foreach (LendItemInfo itemInfo in oParam.itemHash.Values)
{
int lendqty = itemInfo.LendQty;
int returnqty = 0;
foreach (LendReturnInfo returnInfo in oParam.returnHash.Values)
{
if (itemInfo.ProductSysNo == returnInfo.ProductSysNo)
{
returnqty += returnInfo.ReturnQty;
}
}
if (lendqty > returnqty)
{
return((int)AppEnum.LendStatus.ReturnPartly);
}
}
return((int)AppEnum.LendStatus.ReturnAll);
}
public void CancelVerify(int masterSysNo, int userSysNo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
LendInfo masterInfo = Load(masterSysNo);
//必须是已审核状态
if (masterInfo.Status != (int)AppEnum.LendStatus.Verified)
{
throw new BizException("status is not verified now, cancel verify failed");
}
//设置 单号、状态
Hashtable ht = new Hashtable(4);
ht.Add("SysNo", masterInfo.SysNo);
ht.Add("Status", (int)AppEnum.LendStatus.Origin);
ht.Add("AuditTime", DateTime.Now);
ht.Add("AuditUserSysNo", userSysNo);
if (1 != new LendDac().UpdateMaster(ht))
{
throw new BizException("expected one-row update failed, cancel verify failed ");
}
scope.Complete();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["adminUserName"] == null)
{
Response.Redirect("MainPage.aspx");
}
string lendId = Request.QueryString["lendId"];
LendInfo lendInfo = new LendInfo();
lendInfo.GetLendInfo(Int32.Parse(lendId));
this.DeviceType.Text = (new DeviceType()).GetDeviceType(lendInfo.DeviceId);
this.DeviceName.Text = (new DeviceInfo()).GetDeviceName1(Convert.ToInt32(lendId));
this.LendDepartment.Text = (new Department()).GetDepartmentName(lendInfo.LendDepartmentId);
this.LendPerson.Text = lendInfo.LendPerson;
this.LendDate.Text = lendInfo.LendDate.ToShortDateString();
this.LendDays.Text = lendInfo.LendDays.ToString();
string deviceImagePath = (new DeviceInfo()).GetDeviceImagePath(lendInfo.DeviceId);
if (deviceImagePath != "")
{
this.DeviceImage.ImageUrl = deviceImagePath;
}
else
{
this.DeviceImage.ImageUrl = "iamges\\noImage.jpg";
}
}
}
public void CancelAbandon(int masterSysNo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
LendInfo masterInfo = Load(masterSysNo);
//必须是废弃状态
if (masterInfo.Status != (int)AppEnum.LendStatus.Abandon)
{
throw new BizException("status is not abandon now , cancel abandon failed");
}
//设置 单号、状态
Hashtable ht = new Hashtable(4);
ht.Add("SysNo", masterSysNo);
ht.Add("Status", (int)AppEnum.LendStatus.Origin);
if (1 != new LendDac().UpdateMaster(ht))
{
throw new BizException("expected one-row update failed, cancel abandon failed ");
}
//增加对available数量的占用
foreach (LendItemInfo item in masterInfo.itemHash.Values)
{
InventoryManager.GetInstance().SetAvailableQty(masterInfo.StockSysNo, item.ProductSysNo, item.LendQty);
}
scope.Complete();
}
}
public void UpdateMaster(LendInfo oParam)
{
//主项可以更新 lenduser, note
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
//必须是初始状态
if (getCurrentStatus(oParam.SysNo) != (int)AppEnum.LendStatus.Origin)
{
throw new BizException("status is not origin now, update failed");
}
//设置 单号, 可以修改借货人、备注
Hashtable ht = new Hashtable(3);
ht.Add("SysNo", oParam.SysNo);
ht.Add("LendUserSysNo", oParam.LendUserSysNo);
ht.Add("Note", oParam.Note);
if (1 != new LendDac().UpdateMaster(ht))
{
throw new BizException("expected one-row update failed, update failed ");
}
scope.Complete();
}
}
public void Create(LendInfo oParam)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
oParam.SysNo = SequenceDac.GetInstance().Create("St_Lend_Sequence");
oParam.LendID = getLendID(oParam.SysNo);
//建立主表记录
int rowsAffected = new LendDac().InsertMaster(oParam);
if (rowsAffected != 1)
{
throw new BizException("insert lend master error");
}
foreach (LendItemInfo item in oParam.itemHash.Values)
{
item.LendSysNo = oParam.SysNo;
rowsAffected = new LendDac().InsertItem(item);
if (rowsAffected != 1)
{
throw new BizException("insert lend item error");
}
InventoryManager.GetInstance().SetAvailableQty(oParam.StockSysNo, item.ProductSysNo, item.LendQty);
}
scope.Complete();
}
}
public void DeleteItem(LendInfo masterInfo, int itemProductSysNo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
//必须是初始
if (getCurrentStatus(masterInfo.SysNo) != (int)AppEnum.LendStatus.Origin)
{
throw new BizException("status is not origin now, delete item failed");
}
//获取数量差值
LendItemInfo oldItemInfo = masterInfo.itemHash[itemProductSysNo] as LendItemInfo;
int deltQty = -1 * oldItemInfo.LendQty;
//更新item
if (1 != new LendDac().DeleteItem(oldItemInfo.SysNo))
{
throw new BizException("expected one-row update failed, delete item qty failed");
}
//更新库存
InventoryManager.GetInstance().SetAvailableQty(masterInfo.StockSysNo, itemProductSysNo, deltQty);
//更新 masterInfo
masterInfo.itemHash.Remove(itemProductSysNo);
scope.Complete();
}
}
public void InsertReturn(LendInfo masterInfo, LendReturnInfo returnInfo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
//必须是出库状态
if (getCurrentStatus(masterInfo.SysNo) != (int)AppEnum.LendStatus.OutStock &&
getCurrentStatus(masterInfo.SysNo) != (int)AppEnum.LendStatus.ReturnPartly)
{
throw new BizException("status is not outstock or returnpartly now, return failed");
}
//获取数量差值
LendItemInfo oldItemInfo = masterInfo.itemHash[returnInfo.ProductSysNo] as LendItemInfo;
int alreadyReturnQty = 0;
foreach (LendReturnInfo item in masterInfo.returnHash.Values)
{
if (item.ProductSysNo == returnInfo.ProductSysNo)
{
alreadyReturnQty += item.ReturnQty;
}
}
if (oldItemInfo.LendQty - alreadyReturnQty < returnInfo.ReturnQty)
{
throw new BizException("you don't need to return so much");
}
//更新item
if (1 != new LendDac().InsertReturn(returnInfo))
{
throw new BizException("expected one-row update failed, update item qty failed");
}
//更新库存
InventoryManager.GetInstance().SetInStockQty(masterInfo.StockSysNo, returnInfo.ProductSysNo, returnInfo.ReturnQty);
//更新 returnInfo 到 masterInfo
masterInfo.returnHash.Add(returnInfo.SysNo, returnInfo);
//设置单号、状态
Hashtable ht = new Hashtable(2);
ht.Add("SysNo", masterInfo.SysNo);
ht.Add("Status", CalcReturnStatus(masterInfo));
if (1 != new LendDac().UpdateMaster(ht))
{
throw new BizException("expected one-row update failed, cancel outstock failed ");
}
scope.Complete();
}
}
public LendInfo Load(int lendSysNo)
{
LendInfo masterInfo;
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
string masterSql = "select * from st_lend where sysno = " + lendSysNo;
DataSet masterDs = SqlHelper.ExecuteDataSet(masterSql);
if (!Util.HasMoreRow(masterDs))
{
throw new BizException("there is no this lend sysno");
}
masterInfo = new LendInfo();
map(masterInfo, masterDs.Tables[0].Rows[0]);
string itemSql = "select * from st_lend_item where lendsysno=" + lendSysNo;
DataSet itemDs = SqlHelper.ExecuteDataSet(itemSql);
if (Util.HasMoreRow(itemDs))
{
foreach (DataRow dr in itemDs.Tables[0].Rows)
{
LendItemInfo item = new LendItemInfo();
map(item, dr);
masterInfo.itemHash.Add(item.ProductSysNo, item);
}
}
//因为还货记录的pk不是product，所以用sysno 做key
string returnSql = "select * from st_lend_return where lendsysno=" + lendSysNo;
DataSet returnDs = SqlHelper.ExecuteDataSet(returnSql);
if (Util.HasMoreRow(returnDs))
{
foreach (DataRow dr in returnDs.Tables[0].Rows)
{
LendReturnInfo item = new LendReturnInfo();
map(item, dr);
masterInfo.returnHash.Add(item.SysNo, item);
}
}
scope.Complete();
}
return(masterInfo);
}
public int InsertMaster(LendInfo oParam)
{
string sql = @"INSERT INTO St_Lend
(
SysNo, LendID, StockSysNo, LendUserSysNo,
CreateTime, CreateUserSysNo, Status, Note
)
VALUES (
@SysNo, @LendID, @StockSysNo, @LendUserSysNo,
@CreateTime, @CreateUserSysNo, @Status, @Note
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramLendID = new SqlParameter("@LendID", SqlDbType.NVarChar, 20);
SqlParameter paramStockSysNo = new SqlParameter("@StockSysNo", SqlDbType.Int, 4);
SqlParameter paramLendUserSysNo = new SqlParameter("@LendUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
SqlParameter paramNote = new SqlParameter("@Note", SqlDbType.NVarChar, 200);
paramSysNo.Value = oParam.SysNo;
paramLendID.Value = oParam.LendID;
paramStockSysNo.Value = oParam.StockSysNo;
paramLendUserSysNo.Value = oParam.LendUserSysNo;
paramCreateTime.Value = oParam.CreateTime;
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
paramStatus.Value = oParam.Status;
if (oParam.Note != AppConst.StringNull)
{
paramNote.Value = oParam.Note;
}
else
{
paramNote.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramLendID);
cmd.Parameters.Add(paramStockSysNo);
cmd.Parameters.Add(paramLendUserSysNo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramNote);
return(SqlHelper.ExecuteNonQuery(cmd));
}
private void map(LendInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.LendID = Util.TrimNull(tempdr["LendID"]);
oParam.StockSysNo = Util.TrimIntNull(tempdr["StockSysNo"]);
oParam.LendUserSysNo = Util.TrimIntNull(tempdr["LendUserSysNo"]);
oParam.CreateTime = Util.TrimDateNull(tempdr["CreateTime"]);
oParam.CreateUserSysNo = Util.TrimIntNull(tempdr["CreateUserSysNo"]);
oParam.AuditTime = Util.TrimDateNull(tempdr["AuditTime"]);
oParam.AuditUserSysNo = Util.TrimIntNull(tempdr["AuditUserSysNo"]);
oParam.OutTime = Util.TrimDateNull(tempdr["OutTime"]);
oParam.OutUserSysNo = Util.TrimIntNull(tempdr["OutUserSysNo"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
oParam.Note = Util.TrimNull(tempdr["Note"]);
}
protected void BtnReturnBack_Click(object sender, EventArgs e)
{
string lendId = Request.QueryString["lendId"];
string returnDate = this.ReturnDate.Text;
if (returnDate == "")
{
Response.Write("<script>alert('请选择归还日期!');</script>");
return;
}
LendInfo lendInfo = new LendInfo();
if (lendInfo.UpdateLendInfo(Int32.Parse(lendId), Convert.ToDateTime(returnDate)))
{
Response.Write("<script>alert('设备归还成功!');location.href='DeviceLendManage.aspx';</script>");
}
}
public void DeleteReturn(LendInfo masterInfo, int returnSysNo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
//必须是出库状态
if (getCurrentStatus(masterInfo.SysNo) != (int)AppEnum.LendStatus.ReturnAll &&
getCurrentStatus(masterInfo.SysNo) != (int)AppEnum.LendStatus.ReturnPartly)
{
throw new BizException("status is not return or returnpartly now, delete return failed");
}
//获取数量差值
LendReturnInfo oldReturnInfo = masterInfo.returnHash[returnSysNo] as LendReturnInfo;
int deltQty = -1 * oldReturnInfo.ReturnQty;
//更新item
if (1 != new LendDac().DeleteReturn(returnSysNo))
{
throw new BizException("expected one-row update failed, delete return failed");
}
//更新库存
InventoryManager.GetInstance().SetInStockQty(masterInfo.StockSysNo, oldReturnInfo.ProductSysNo, deltQty);
//更新 returnInfo 到 masterInfo
masterInfo.returnHash.Remove(oldReturnInfo.SysNo);
//设置单号、状态
Hashtable ht = new Hashtable(2);
ht.Add("SysNo", masterInfo.SysNo);
ht.Add("Status", CalcReturnStatus(masterInfo));
if (1 != new LendDac().UpdateMaster(ht))
{
throw new BizException("expected one-row update failed, cancel outstock failed ");
}
scope.Complete();
}
}
public void UpdateItemQty(LendInfo masterInfo, LendItemInfo itemInfo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
//必须是初始
if (getCurrentStatus(masterInfo.SysNo) != (int)AppEnum.LendStatus.Origin)
{
throw new BizException("status is not origin now, update item qty failed");
}
//获取数量差值
LendItemInfo oldItemInfo = masterInfo.itemHash[itemInfo.ProductSysNo] as LendItemInfo;
int deltQty = itemInfo.LendQty - oldItemInfo.LendQty;
//更新表单明细 ( 如果增加表单明细项的属性，需要在这里处理一下）
itemInfo.SysNo = oldItemInfo.SysNo;
itemInfo.LendSysNo = oldItemInfo.LendSysNo;
if (1 != new LendDac().UpdateItem(itemInfo.SysNo, deltQty, itemInfo.ExpectReturnTime))
{
throw new BizException("expected one-row update failed, update item qty failed");
}
//更新库存
InventoryManager.GetInstance().SetAvailableQty(masterInfo.StockSysNo, itemInfo.ProductSysNo, deltQty);
//更新 itemInfo 到 masterInfo 注:数据库更新成功以后才更新类
masterInfo.itemHash.Remove(itemInfo.ProductSysNo);
masterInfo.itemHash.Add(itemInfo.ProductSysNo, itemInfo);
scope.Complete();
}
}
protected void BtnLend_Click(object sender, EventArgs e)
{
LendInfo lendInfo = new LendInfo();
if (this.Device.SelectedValue == "")
{
Response.Write("<script>alert('抱歉，请选择设备!');</script>");
return;
}
lendInfo.DeviceId = Int32.Parse(this.Device.SelectedValue);
lendInfo.LendDepartmentId = Int32.Parse(this.LendDepartment.SelectedValue);
lendInfo.LendPerson = this.LendPerson.Text;
lendInfo.LendDate = Convert.ToDateTime(LendDate.Text);
lendInfo.LendDays = Convert.ToInt32(this.LendDays.Text);
if (!lendInfo.AddLendInfo())
{
Response.Write("<script>alert('" + lendInfo.ErrMessage + "');</script>");
}
else
{
Response.Write("<script>alert('借用设备成功!');location.href='DeviceLend.aspx';</script>");
}
}
public void CancelOutStock(int masterSysNo, int userSysNo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
LendInfo masterInfo = Load(masterSysNo);
//必须是已出库
if (masterInfo.Status != (int)AppEnum.LendStatus.OutStock)
{
throw new BizException("status is not outstock now, cancel outstock failed");
}
//设置 单号、状态
Hashtable ht = new Hashtable(4);
ht.Add("SysNo", masterInfo.SysNo);
ht.Add("Status", (int)AppEnum.LendStatus.Origin);
ht.Add("OutTime", DateTime.Now);
ht.Add("OutUserSysNo", userSysNo);
if (1 != new LendDac().UpdateMaster(ht))
{
throw new BizException("expected one-row update failed, cancel outstock failed ");
}
//库存设定
foreach (LendItemInfo item in masterInfo.itemHash.Values)
{
InventoryManager.GetInstance().SetOutStockQty(masterInfo.StockSysNo, item.ProductSysNo, -1 * item.LendQty);
}
scope.Complete();
}
}
public void InsertItem(LendInfo masterInfo, LendItemInfo itemInfo)
{
if (masterInfo.itemHash.ContainsKey(itemInfo.ProductSysNo))
{
throw new BizException("item duplicated!");
}
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
//必须是初始
if (getCurrentStatus(masterInfo.SysNo) != (int)AppEnum.LendStatus.Origin)
{
throw new BizException("status is not origin now, add item failed");
}
//获取数量差值
//更新item
if (1 != new LendDac().InsertItem(itemInfo))
{
throw new BizException("expected one-row update failed, add item failed");
}
//更新库存
InventoryManager.GetInstance().SetAvailableQty(masterInfo.StockSysNo, itemInfo.ProductSysNo, itemInfo.LendQty);
//更新 itemInfo 到 masterInfo
masterInfo.itemHash.Add(itemInfo.ProductSysNo, itemInfo);
scope.Complete();
}
}
public void Import()
{
/* 涉及的问题
* 1 还货记录的处理
* 2 库存的处理
* 3 状态的处理
* 4 还有单据id的对应，这个要特别注意
*/
if (!AppConfig.IsImportable)
{
throw new BizException("Is Importable is false");
}
string sql = " select top 1 sysno from st_lend";
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
throw new BizException("the table lend is not empty");
}
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
string sql_old = @"select
old.sysno, old.lendid, stock_con.newsysno as stocksysno,
lender_con.newsysno as lendusersysno,
create_con.newsysno as createusersysno,
audit_con.newsysno as auditusersysno,
out_con.newsysno as outusersysno,
createtime, audittime,outstocktime as outtime,
productstatus, auditstatus, memo as note, '1' as status
from
ipp2003..st_lend as old,
ippconvert..sys_user as lender_con,
ippconvert..sys_user as create_con,
ippconvert..sys_user as audit_con,
ippconvert..sys_user as out_con,
ippconvert..stock as stock_con
where
old.employeesysno = lender_con.oldsysno and
old.createusersysno = create_con.oldsysno and
old.auditusersysno = audit_con.oldsysno and
old.outstockusersysno = out_con.oldsysno and
old.stocksysno = stock_con.oldsysno
order by old.sysno" ;
DataSet ds_old = SqlHelper.ExecuteDataSet(sql_old);
if (!Util.HasMoreRow(ds_old))
{
return;
}
foreach (DataRow dr in ds_old.Tables[0].Rows)
{
/* newStatus aduit product
* abandon -1 n/a
* origin 0 n/a
* verified 1 n/a
* outstock n/a 1
* returnpartly n/a 2
* returnall n/a 3
*/
int newStatus = (int)AppEnum.LendStatus.Origin;
int auditStatus = Util.TrimIntNull(dr["auditStatus"]);
int productStatus = Util.TrimIntNull(dr["productStatus"]);
if (auditStatus == -1)
{
newStatus = (int)AppEnum.LendStatus.Abandon;
}
if (auditStatus == 0)
{
newStatus = (int)AppEnum.LendStatus.Origin;
}
if (auditStatus == 1)
{
newStatus = (int)AppEnum.LendStatus.Verified;
}
if (productStatus == 1)
{
newStatus = (int)AppEnum.LendStatus.OutStock;
}
if (productStatus == 2)
{
newStatus = (int)AppEnum.LendStatus.ReturnPartly;
}
if (productStatus == 3)
{
newStatus = (int)AppEnum.LendStatus.ReturnAll;
}
LendInfo oInfo = new LendInfo();
map(oInfo, dr);
oInfo.Status = newStatus;
if (new LendDac().ImportMaster(oInfo) != 1)
{
throw new BizException("master expected one row error");
}
//insert item
string sql_item = @"select '0' as sysno,
LendSysNo, con_product.newsysno as productsysno, lendqty, returnqty, restoretime as ExpectReturnTime
from
ipp2003..St_Lend_Item sli, ippconvert..productbasic as con_product
where sli.productsysno = con_product.oldsysno and LendSysNo=" + oInfo.SysNo;
DataSet ds_item = SqlHelper.ExecuteDataSet(sql_item);
if (!Util.HasMoreRow(ds_item))
{
continue;
}
foreach (DataRow drItem in ds_item.Tables[0].Rows)
{
LendItemInfo oItem = new LendItemInfo();
map(oItem, drItem);
int resultitem = new LendDac().InsertItem(oItem);
if (resultitem < 1)
{
throw new BizException("insert item row < 1");
}
if (Util.TrimIntNull(drItem["returnqty"]) != 0)
{
LendReturnInfo oReturn = new LendReturnInfo();
oReturn.LendSysNo = oItem.LendSysNo;
oReturn.ProductSysNo = oItem.ProductSysNo;
oReturn.ReturnTime = oInfo.OutTime.AddDays(30);
oReturn.ReturnQty = Util.TrimIntNull(drItem["returnqty"]);
int resultReturn = new LendDac().InsertReturn(oReturn);
if (resultReturn != 1)
{
throw new BizException("return item one-row expected error");
}
}
if (oItem.LendQty - Util.TrimIntNull(drItem["returnqty"]) != 0)
{
InventoryManager.GetInstance().SetImportLendQty(oInfo.StockSysNo, oItem.ProductSysNo, oItem.LendQty - Util.TrimIntNull(drItem["returnqty"]));
}
//调整库存
if (oInfo.Status == (int)AppEnum.LendStatus.Origin || oInfo.Status == (int)AppEnum.LendStatus.Verified)
{
InventoryManager.GetInstance().SetAvailableQty(oInfo.StockSysNo, oItem.ProductSysNo, oItem.LendQty);
}
}
}
string sqlMaxSysNo = "select top 1 sysno from ipp2003..st_lend order by sysno desc";
DataSet dsMax = SqlHelper.ExecuteDataSet(sqlMaxSysNo);
if (!Util.HasMoreRow(dsMax))
{
throw new BizException("got max sysno error");
}
int maxSysNo = Util.TrimIntNull(dsMax.Tables[0].Rows[0]["sysno"]);
// 将自动生成的sysno填到目前的最大单据号
int newSysNo;
do
{
newSysNo = SequenceDac.GetInstance().Create("St_Lend_Sequence");
} while(newSysNo < maxSysNo);
scope.Complete();
}
}