/// <summary>
/// Page_Load
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//初始化控件数据
InitData();
//加载数据
LoadData();
}
else
{
if (GetRequestEventArgument().Contains("reloadGrid:"))
{
//查找所选商品代码，查访产品集合
string keys = GetRequestEventArgument().Split(':')[1];
var values = keys.Split(',');
string codes = String.Empty;
for (int i = 0; i < values.Count(); i++)
{
codes += string.Format("'{0}',", values[i]);
}
var value = codes.Substring(0, codes.Length - 1);
var data = SqlService.Where(string.Format("SELECT * FROM dbo.vm_PurchaseItem a WHERE a.FItemCode IN ({0}) and FCompanyId={1}", value, CurrentUser.AccountComId
));
if (data != null && data.Tables.Count > 0 && data.Tables[0].Rows.Count > 0)
{
var table = data.Tables[0];
for (int i = 0; i < table.Rows.Count; i++)
{
var details = new LHStockInDetails();
decimal price = GasHelper.GeSupplierPrice(txtFCode.Text.Trim(), //
table.Rows[i]["FItemCode"].ToString(), CurrentUser.AccountComId);
details.FItemCode = table.Rows[i]["FItemCode"].ToString();
details.FPrice = price;
details.FQty = 0;
details.FAmount = price;
details.FBottleQty = 0;
details.FBottleOweQty = 0;
details.FCompanyId = CurrentUser.AccountComId;
details.KeyId = txtKeyId.Text.Trim();
details.FCateId = Convert.ToInt32(table.Rows[i]["FId"].ToString());
details.FNum = table.Rows[i]["FINum"].ToString();//U8代码
details.FReturnQty = 0;
details.FRecycleQty = 0;
//默认包装物
details.FBottle = table.Rows[i]["FBottle"].ToString();
StockInDetailsService.AddEntity(details);
//日志
switch (Actions)
{
case WebAction.Add:
break;
case WebAction.Edit:
////记录一下当前新增人操作内容
//var detailslog = new LHStockInDetails_Log
//{
// FUpdateBy = CurrentUser.AccountName,
// FUpdateDate = DateTime.Now,
// FItemCode = details.FItemCode,
// FPrice = price,
// FQty = 1,
// FAmount = price,
// FBottleQty = 1,
// FBottleOweQty = 0,
// FCompanyId = CurrentUser.AccountComId,
// KeyId = txtKeyId.Text.Trim(),
// FBottle = details.FBottle,
// FStatus = "新增",
// FMemo = string.Format(@"时间：{0} 操作人：{1}", DateTime.Now, CurrentUser.AccountName)
//};
//StockInDetailsLogService.Add(detailslog);
break;
}
}
StockInDetailsService.SaveChanges();
//重新绑定值
BindDataGrid();
}
}
//更新合计
if (GetRequestEventArgument() == "UPDATE_SUMMARY")
{
// 页面要求重新计算合计行的值
OutputSummaryData();
//
ModifiedGrid();
// 为了保持前后台上传，回发更新合计行值后，必须进行数据绑定或者提交更改
Grid1.CommitChanges();
}
}
}
/// <summary>
/// Page_Load
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//初始化控件数据
InitData();
//加载数据
LoadData();
}
else
{
if (GetRequestEventArgument().Contains("reloadGrid:"))
{
//查找所选商品代码，查访产品集合
string keys = GetRequestEventArgument().Split(':')[1];
var values = keys.Split(',');
string codes = String.Empty;
for (int i = 0; i < values.Count(); i++)
{
codes += string.Format("'{0}',", values[i]);
}
var value = codes.Substring(0, codes.Length - 1);
var data = SqlService.Where(string.Format("SELECT * FROM dbo.vm_SalesItem a WHERE a.FItemCode IN ({0}) AND a.FCompanyId={1}", value, CurrentUser.AccountComId));
if (data != null && data.Tables.Count > 0 && data.Tables[0].Rows.Count > 0)
{
var table = data.Tables[0];
for (int i = 0; i < table.Rows.Count; i++)
{
var details = new LHStockInDetails();
decimal price = GasHelper.GeCustomerPrice(txtFCode.Text.Trim(), //
table.Rows[i]["FItemCode"].ToString(), CurrentUser.AccountComId);
details.FItemCode = table.Rows[i]["FItemCode"].ToString();
details.FPrice = price;
details.FQty = 1;
details.FAmount = price;
details.FBottleQty = 1;
details.FBottleOweQty = 0;
details.FBottle = table.Rows[i]["FItemCode"].ToString();
details.FCompanyId = CurrentUser.AccountComId;
details.KeyId = txtKeyId.Text.Trim();
details.FCateId = Convert.ToInt32(table.Rows[i]["FId"].ToString());
StockInDetailsService.AddEntity(details);
//日志
switch (Actions)
{
case WebAction.Add:
break;
case WebAction.Edit:
//记录一下当前新增人操作内容
var detailslog = new LHStockInDetails_Log
{
FUpdateBy = CurrentUser.AccountName,
FUpdateDate = DateTime.Now,
FItemCode = details.FItemCode,
FPrice = price,
FQty = 1,
FAmount = price,
FBottleQty = 1,
FBottleOweQty = 0,
KeyId = txtKeyId.Text.Trim(),
FBottle = details.FBottle,
FStatus = "新增",
FCompanyId = CurrentUser.AccountComId,
FMemo = string.Format(@"时间：{0} 操作人：{1}", DateTime.Now, CurrentUser.AccountName)
};
StockInDetailsLogService.Add(detailslog);
break;
}
}
StockInDetailsService.SaveChanges();
//重新绑定值
BindDataGrid();
}
}
}
}