/// <summary>
/// 单元格编辑与修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid2_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Window1.Hidden = true;
Window2.Hidden = true;
Window3.Hidden = true;
Window4.Hidden = true;
//新增行事件
//var addList = Grid1.GetNewAddedList();
//foreach (var add in addList)
//{
// var dictValues = add.Values;
// //商品代码
// var firstOrDefault = dictValues.First();
// if (firstOrDefault != null)
// {
// DataSet dataSet = GasHelper.GetSalesItem(firstOrDefault.ToString());
// DataTable table = dataSet.Tables[0];
// if (table != null && table.Rows.Count > 0)
// {
// decimal price = GasHelper.GeCustomerPrice(txtFCode.Text.Trim(),//
// table.Rows[0]["FItemCode"].ToString());
// table.Rows[0]["FPrice"] = price;
// var details = new LHStockOutDetails
// {
// FItemCode = table.Rows[0]["FItemCode"].ToString(),
// FPrice = price,
// FQty = 1,
// FAmount = price,
// FBottleQty = 1,
// FBottleOweQty = 0,
// FCompanyId = CurrentUser.AccountComId,
// KeyId = txtKeyId.Text.Trim(),
// FBottle = table.Rows[0]["FBottleCode"].ToString(),
// FCateId = Convert.ToInt32(table.Rows[0]["FId"].ToString())
// };
// switch (Actions)
// {
// case WebAction.Add:
// break;
// case WebAction.Edit:
// //记录一下当前新增人操作内容
// var detailslog = new LHStockOutDetails_Log
// {
// FUpdateBy = CurrentUser.AccountName,
// FUpdateDate = DateTime.Now,
// FItemCode = table.Rows[0]["FItemCode"].ToString(),
// FPrice = price,
// FQty = 1,
// FAmount = price,
// FBottleQty = 1,
// FBottleOweQty = 0,
// KeyId = txtKeyId.Text.Trim(),
// FBottle = table.Rows[0]["FBottleCode"].ToString(),
// FStatus = "新增",
// FMemo = string.Format(@"时间：{0} 新增人：{1}", DateTime.Now, CurrentUser.AccountName)
// };
// //detailslog.FCompanyId = CurrentUser.AccountComId;
// //detailslog.FCateId = Convert.ToInt32(table.Rows[0]["FId"].ToString());
// StockOutDetailsLogService.Add(detailslog);
// break;
// }
// // CollectionOrderBanksService.Add(details);
// }
// }
//}
//编辑行事件
var dictModified = Grid2.GetModifiedDict();
foreach (var index in dictModified.Keys)
{
int datakey = Convert.ToInt32(Grid2.DataKeys[index][1].ToString());
foreach (var dictValue in dictModified.Values)
{
foreach (KeyValuePair <string, object> keyValuePair in dictValue)
{
string key = keyValuePair.Key;
string value = keyValuePair.Value.ToString();
var details = FKOrderDetailsService.Where(p => p.FId == datakey && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
//写入原始，通过存储过程完成明细复制
//var parms = new Dictionary<string, object>();
//parms.Clear();
//parms.Add("@fid", datakey);
//parms.Add("@opr", CurrentUser.AccountName);
//SqlService.ExecuteProcedureCommand("proc_StockOutDetails_Log", parms);
if (details != null)
{
switch (key)
{
case "FAmount2":
details.FAmount = Convert.ToDecimal(value);
break;
case "FMemo2":
details.FMemo = value;
break;
}
//var detailslog = new LHStockOutDetails_Log
//{
// FUpdateBy = CurrentUser.AccountName,
// FUpdateDate = DateTime.Now,
// FItemCode = details.FItemCode,
// FPrice = details.FPrice,
// FQty = details.FQty,
// FAmount = details.FAmount,
// FBottleQty = details.FBottleQty,
// FBottleOweQty = details.FBottleOweQty,
// KeyId = details.KeyId,
// FBottle = details.FBottle,
// FStatus = "变更",
// FMemo = string.Format(@"时间：{0} 变更人：{1}", DateTime.Now, CurrentUser.AccountName)
//};
//StockOutDetailsLogService.Add(detailslog);
}
FKOrderDetailsService.SaveChanges();
}
}
}
BindDataGrid();
}
/// <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
{
#region 银行
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_Bank a WHERE a.FCode IN ({0}) and FCompanyId={1} and FDate='{2}'", value, CurrentUser.AccountComId, txtFDate.SelectedDate.Value.ToString("yyyy-MM")));
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 banks = new LHFKOrderBanks();
banks.FAmt = 0;
banks.FCardNo = table.Rows[i]["FComment"].ToString();
banks.KeyId = txtKeyId.Text.Trim();
banks.FCode = table.Rows[i]["FCode"].ToString();
banks.FName = table.Rows[i]["FName"].ToString();
banks.FMemo = "";
banks.FBankNo = "";
banks.FBillNo = "";
banks.FCompanyId = CurrentUser.AccountComId;
//banks.FExpireDate =
FKOrderBanksService.AddEntity(banks);
////日志
//switch (Actions)
//{
// case WebAction.Add:
// break;
// case WebAction.Edit:
// //记录一下当前新增人操作内容
// var detailslog = new LHStockOutDetails_Log
// {
// FUpdateBy = CurrentUser.AccountName,
// FUpdateDate = DateTime.Now,
// FItemCode = banks.FItemCode,
// FPrice = price,
// FQty = 1,
// FAmount = price,
// FBottleQty = 1,
// FBottleOweQty = 0,
// KeyId = txtKeyId.Text.Trim(),
// FBottle = banks.FBottle,
// FStatus = "新增",
// FMemo = string.Format(@"时间：{0} 操作人：{1}", DateTime.Now, CurrentUser.AccountName)
// };
// StockOutDetailsLogService.Add(detailslog);
// break;
//}
}
FKOrderBanksService.SaveChanges();
//重新绑定值
BindDataGrid();
}
}
#endregion
#region 报销项目
if (GetRequestEventArgument().Contains("reloadTree:"))
{
//查找所选商品代码，查访产品集合
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_Subject a WHERE a.FCode IN ({0}) and FCompanyId={1} and FDate='{2}'", value, CurrentUser.AccountComId, txtFDate.SelectedDate.Value.ToString("yyyy-MM")));
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 LHFKOrderDetails();
details.KeyId = txtKeyId.Text.Trim();
details.FCode = table.Rows[i]["FCode"].ToString();
details.FName = table.Rows[i]["FName"].ToString();
details.FMemo = "";
details.FAmount = 0;
details.FCompanyId = CurrentUser.AccountComId;
FKOrderDetailsService.AddEntity(details);
////日志
//switch (Actions)
//{
// case WebAction.Add:
// break;
// case WebAction.Edit:
// //记录一下当前新增人操作内容
// var detailslog = new LHStockOutDetails_Log
// {
// FUpdateBy = CurrentUser.AccountName,
// FUpdateDate = DateTime.Now,
// FItemCode = banks.FItemCode,
// FPrice = price,
// FQty = 1,
// FAmount = price,
// FBottleQty = 1,
// FBottleOweQty = 0,
// KeyId = txtKeyId.Text.Trim(),
// FBottle = banks.FBottle,
// FStatus = "新增",
// FMemo = string.Format(@"时间：{0} 操作人：{1}", DateTime.Now, CurrentUser.AccountName)
// };
// StockOutDetailsLogService.Add(detailslog);
// break;
//}
}
FKOrderDetailsService.SaveChanges();
//重新绑定值
BindDataGrid();
}
}
#endregion
}
}
