/// <summary>
/// 单元格编辑与修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
//Window1.Hidden = true;
//Window2.Hidden = true;
//Window3.Hidden = true;
////新增行事件
//var addList = Grid1.GetNewAddedList();
//#region AddRow
//foreach (var add in addList)
//{
// var dictValues = add.Values;
// //商品代码
// var firstOrDefault = dictValues.First();
// if (firstOrDefault != null && !string.IsNullOrEmpty(firstOrDefault.ToString()))
// {
// DataSet dataSet = GasHelper.GetSalesItem(firstOrDefault.ToString(), CurrentUser.AccountComId);
// DataTable table = dataSet.Tables[0];
// if (table != null && table.Rows.Count > 0)
// {
// }
// }
//}
//#endregion
//if (addList.Count > 0)
// BindDataGrid();
}
/// <summary>
/// 五金明细编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gdHandWare_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = gdHandWare.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
//根据绑定列的记录编号，获取发货物品信息和物品基本信息
int rowID = Convert.ToInt32(gdHandWare.DataKeys[rowIndex][0]);
ContractHandWareDetail objInfo = Core.Container.Instance.Resolve <IServiceContractHandWareDetail>().GetEntity(rowID);
//修改数量
if (modifiedDict[rowIndex].Keys.Contains("GoodsNumber"))
{
objInfo.GoodsNumber = Convert.ToInt32(modifiedDict[rowIndex]["GoodsNumber"]);
}
//修改单价
if (modifiedDict[rowIndex].Keys.Contains("GoodsUnitPrice"))
{
objInfo.GoodsUnitPrice = Convert.ToDecimal(modifiedDict[rowIndex]["GoodsUnitPrice"]);
}
//更新总价和成本金额
objInfo.GoodAmount = objInfo.GoodsNumber * objInfo.GoodsUnitPrice;
objInfo.CostAmount = objInfo.GoodsNumber * objInfo.CostPrice;
//更新订单明细
Core.Container.Instance.Resolve <IServiceContractHandWareDetail>().Update(objInfo);
}
//重新加载
BindHandWareDetail();
}
/// <summary>
/// 菜品数量和价格变动处理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
tm_TabieDishesInfo tabieDishesInfo = Core.Container.Instance.Resolve <IServiceTabieDishesInfo>().GetEntity(rowID);
if (tabieDishesInfo.DishesType == "2" || tabieDishesInfo.IsFree == "1" || tabieDishesInfo.DishesType == "3")
{
continue;
}
//更新菜品总价
decimal Amount = tabieDishesInfo.Moneys;
tabieDishesInfo.DishesCount = decimal.Parse(modifiedDict[rowIndex]["DishesCount"].ToString());
tabieDishesInfo.Moneys = tabieDishesInfo.DishesCount * tabieDishesInfo.Price;
Core.Container.Instance.Resolve <IServiceTabieDishesInfo>().Update(tabieDishesInfo);
//根据菜品变动前总价和变动后总价差异更新就餐信息消费金额
tm_TabieUsingInfo tabieUsingInfo = Core.Container.Instance.Resolve <IServiceTabieUsingInfo>().GetEntity(TabieUsingID);
tabieUsingInfo.Moneys += (tabieDishesInfo.Moneys - Amount);
tabieUsingInfo.FactPrice += (tabieDishesInfo.Moneys - Amount);
Core.Container.Instance.Resolve <IServiceTabieUsingInfo>().Update(tabieUsingInfo);
}
//绑定餐台点菜信息
BindTabieDishesInfo();
}
protected void GridCom_AfterEdit(object sender, GridAfterEditEventArgs e)
{
string [] strCell = GridCom.SelectedCell;
int selectedRowIndex = GridCom.SelectedRowIndex;
List <Dictionary <string, object> > newDict = GridCom.GetNewAddedList();
if (newDict.Count == 0)
{
return;
}
if (e.ColumnID == "BZSL" || e.ColumnID == "HSJJ")
{
//string cell = string.Format("[{0},{1}]", e.RowIndex, intCell[1]);
if (!PubFunc.isNumeric(newDict[e.RowIndex]["BZHL"].ToString()) || !PubFunc.isNumeric((newDict[e.RowIndex]["BZSL"] ?? "").ToString()) || !PubFunc.isNumeric(newDict[e.RowIndex]["HSJJ"].ToString()))
{
Alert.Show("商品信息异常，请详细检查商品信息：包装含量、价格或数量！", "异常信息", MessageBoxIcon.Warning);
return;
}
PageContext.RegisterStartupScript(GridCom.GetUpdateCellValueReference(e.RowIndex, GetJObject(newDict[e.RowIndex])));
if (e.RowIndex != selectedRowIndex)
{
//PageContext.RegisterStartupScript(GridCom.GetUpdateCellValueReference(GetJObject(newDict[selectedRowIndex]), string.Format("[{0},{1}]", intCell[0], intCell[1])));
PageContext.RegisterStartupScript(GridCom.GetUpdateCellValueReference(strCell[0], GetJObject(newDict[selectedRowIndex])));
}
//计算合计数量
UpdateSum(newDict);
}
}
/// <summary>
/// 主材买赔数量编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gdGoodsDetail_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = gdGoodsDetail.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
//根据绑定列的记录编号，获取买赔物品信息和物品基本信息
int rowID = Convert.ToInt32(gdGoodsDetail.DataKeys[rowIndex][0]);
ContractPayOrderDetail objInfo = Core.Container.Instance.Resolve <IServiceContractPayOrderDetail>().GetEntity(rowID);
objInfo.GoodsTypeInfo = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(objInfo.GoodTypeID);
//修改买赔数量
if (modifiedDict[rowIndex].Keys.Contains("GoodsNumber"))
{
objInfo.GoodsNumber = Convert.ToDecimal(modifiedDict[rowIndex]["GoodsNumber"]); //最终买赔数量
}
//修改买赔单价
if (modifiedDict[rowIndex].Keys.Contains("GoodsUnitPrice"))
{
objInfo.GoodsUnitPrice = Convert.ToDecimal(modifiedDict[rowIndex]["GoodsUnitPrice"]); //最终买赔单价
}
//计算并更新买赔金额
objInfo.PayAmount = objInfo.GoodsNumber * objInfo.GoodsUnitPrice;
//更新订单明细
Core.Container.Instance.Resolve <IServiceContractPayOrderDetail>().Update(objInfo);
}
//重新加载订单买赔信息
BindMainGoodsInfo();
}
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
// 当前选中的单元格
string[] selectedCell = Grid1.SelectedCell;
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
DataRow row = FindRowByID(rowID);
UpdateDataRow(modifiedDict[rowIndex], row);
}
// 数据绑定时，会清空选中的行和选中的单元格
BindGrid();
labResult.Text = String.Format("用户修改的数据：<pre>{0}</pre>", Grid1.GetModifiedData().ToString(Newtonsoft.Json.Formatting.Indented));
if (selectedCell != null)
{
// 重新选中之前的单元格
PageContext.RegisterStartupScript(String.Format("F('{0}').f_selectCell('{1}','{2}');", Grid1.ClientID, selectedCell[0], selectedCell[1]));
}
}
/// <summary>
/// 主材单价及发货数量编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
//根据绑定列的记录编号，获取发货物品信息和物品基本信息
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
ContractOrderDetail objInfo = Core.Container.Instance.Resolve <IServiceContractOrderDetail>().GetEntity(rowID);
objInfo.GoodsInfo = Core.Container.Instance.Resolve <IServiceEquipmentInfo>().GetEntity(objInfo.GoodsID);
//修改发货数量
if (modifiedDict[rowIndex].Keys.Contains("FixGoodsNumber"))
{
objInfo.GoodsNumber = objInfo.FormerlyGoodsNumber + Convert.ToDecimal(modifiedDict[rowIndex]["FixGoodsNumber"]);
objInfo.FixGoodsNumber = Convert.ToDecimal(modifiedDict[rowIndex]["FixGoodsNumber"]);
objInfo.NotOffsetNumber = objInfo.FormerlyGoodsNumber + Convert.ToDecimal(modifiedDict[rowIndex]["FixGoodsNumber"]);
}
//计算并更新计价数量及重量
if (objInfo.PayUnit == 1)
{
//按计价单位计价，计价数量=商品规格*发货数量
// objInfo.GoodCalcPriceNumber = objInfo.GoodsInfo.Standard * objInfo.GoodsNumber;
}
else
{
//按出库数量计价，计价数量=发货数量
objInfo.GoodCalcPriceNumber = objInfo.GoodsNumber;
}
//更新订单明细
Core.Container.Instance.Resolve <IServiceContractOrderDetail>().Update(objInfo);
}
//重新加载订单发货信息
BindOrderDetail();
}
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
ContractCarPriceSetInfo objInfo = Core.Container.Instance.Resolve <IServiceContractCarPriceSetInfo>().GetEntity(rowID);
if (modifiedDict[rowIndex].Keys.Contains("TonPayPrice"))
{
objInfo.TonPayPrice = Convert.ToDecimal(modifiedDict[rowIndex]["TonPayPrice"]);
}
if (modifiedDict[rowIndex].Keys.Contains("CarPayPrice"))
{
objInfo.CarPayPrice = Convert.ToDecimal(modifiedDict[rowIndex]["CarPayPrice"]);
}
if (modifiedDict[rowIndex].Keys.Contains("MinTon"))
{
objInfo.MinTon = Convert.ToDecimal(modifiedDict[rowIndex]["MinTon"]);
}
Core.Container.Instance.Resolve <IServiceContractCarPriceSetInfo>().Update(objInfo);
}
BindGrid();
}
/// <summary>
/// 相关费用单价及数量编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gdCostInfo_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = gdCostInfo.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
//根据绑定列的记录编号，获取发货费用信息和费用项基本信息
int rowID = Convert.ToInt32(gdCostInfo.DataKeys[rowIndex][0]);
ContractOrderCostInfo objInfo = Core.Container.Instance.Resolve <IServiceContractOrderCostInfo>().GetEntity(rowID);
//修改费用计价单价
if (modifiedDict[rowIndex].Keys.Contains("PayPrice"))
{
objInfo.PayPrice = Convert.ToDecimal(modifiedDict[rowIndex]["PayPrice"]);
}
//修改费用计价数量
if (modifiedDict[rowIndex].Keys.Contains("OrderNumber"))
{
objInfo.OrderNumber = Convert.ToDecimal(modifiedDict[rowIndex]["OrderNumber"]);
}
//计算费用金额
objInfo.CostAmount = objInfo.PayPrice * objInfo.OrderNumber;
//更新费用项信息
Core.Container.Instance.Resolve <IServiceContractOrderCostInfo>().Update(objInfo);
}
//重新加载订单费用信息
BindCostsInfo();
}
/// <summary>
/// 五金明细编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gdHandWare_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = gdHandWare.GetModifiedDict();
ContractInfo contractInfo = Core.Container.Instance.Resolve <IServiceContractInfo>().GetEntity(OrderID);
foreach (int rowIndex in modifiedDict.Keys)
{
//根据绑定列的记录编号，获取发货物品信息和物品基本信息
int rowID = Convert.ToInt32(gdHandWare.DataKeys[rowIndex][0]);
ContractCostInfo objInfo = Core.Container.Instance.Resolve <IServiceContractCostInfo>().GetEntity(rowID);
//修改成本单价
if (modifiedDict[rowIndex].Keys.Contains("CostAmount"))
{
objInfo.CostAmount = Convert.ToDecimal(modifiedDict[rowIndex]["CostAmount"]);
objInfo.ProduceState = 1;
contractInfo.ContractState = 4;
}
//修改生产备注
if (modifiedDict[rowIndex].Keys.Contains("ProduceRemark"))
{
objInfo.ProduceRemark = modifiedDict[rowIndex]["ProduceRemark"].ToString();
}
//修改生产状态
if (modifiedDict[rowIndex].Keys.Contains("ProduceState"))
{
//判断订单状态是否是生产中或者生产完成，其他状态不能修改生产状态
if (contractInfo.ContractState == 3 || contractInfo.ContractState == 4)
{
objInfo.ProduceState = Convert.ToInt32(modifiedDict[rowIndex]["ProduceState"]);
}
}
//更新订单明细
Core.Container.Instance.Resolve <IServiceContractCostInfo>().Update(objInfo);
}
//判断是否所有厂家产品都生产完成
IList <ICriterion> qryList = new List <ICriterion>();
qryList.Add(Expression.Eq("ContractID", OrderID));
qryList.Add(Expression.Eq("ProduceState", 1));
Order[] orderList = new Order[1];
Order orderli = new Order("ID", true);
orderList[0] = orderli;
IList <ContractCostInfo> list = Core.Container.Instance.Resolve <IServiceContractCostInfo>().GetAllByKeys(qryList, orderList);
//更新合同整体进度，如果厂商都生产完成，合同整体进度为生产完成，否则为生产中
if (list.Count == 0)
{
contractInfo.ContractState = 5;
}
Core.Container.Instance.Resolve <IServiceContractInfo>().Update(contractInfo);
//重新加载
BindGrid();
//更新订单生产成本
CalcCost();
}
/// <summary>
/// 主材单价及发货数量编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gdCostInfo_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = gdCostInfo.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
//根据绑定列的记录编号，获取发货物品信息和物品基本信息
int rowID = Convert.ToInt32(gdCostInfo.DataKeys[rowIndex][0]);
ContractCabinetInfo objInfo = Core.Container.Instance.Resolve <IServiceContractCabinetInfo>().GetEntity(rowID);
//修改高度
if (modifiedDict[rowIndex].Keys.Contains("GHeight"))
{
objInfo.GHeight = Convert.ToDecimal(modifiedDict[rowIndex]["GHeight"]);
}
//修改宽度
if (modifiedDict[rowIndex].Keys.Contains("GWide"))
{
objInfo.GWide = Convert.ToDecimal(modifiedDict[rowIndex]["GWide"]);
}
//修改数量
if (modifiedDict[rowIndex].Keys.Contains("OrderNumber"))
{
objInfo.OrderNumber = Convert.ToDecimal(modifiedDict[rowIndex]["OrderNumber"]);
}
//修改单价
if (modifiedDict[rowIndex].Keys.Contains("GPrice"))
{
objInfo.GPrice = Convert.ToDecimal(modifiedDict[rowIndex]["GPrice"]);
}
//修改备注
if (modifiedDict[rowIndex].Keys.Contains("Remark"))
{
objInfo.Remark = modifiedDict[rowIndex]["Remark"].ToString();
}
//修改颜色1
if (modifiedDict[rowIndex].Keys.Contains("GColorOne"))
{
objInfo.GColorOne = modifiedDict[rowIndex]["GColorOne"].ToString();
}
//修改颜色2
if (modifiedDict[rowIndex].Keys.Contains("GColorTwo"))
{
objInfo.GColorTwo = modifiedDict[rowIndex]["GColorTwo"].ToString();
}
//更新面积和金额
objInfo.GArea = (objInfo.GHeight / 1000) * (objInfo.GWide / 1000) * objInfo.OrderNumber;
objInfo.OrderAmount = objInfo.GArea * objInfo.GPrice;
//更新订单明细
Core.Container.Instance.Resolve <IServiceContractCabinetInfo>().Update(objInfo);
}
//更新订单总金额
UpdateOrderAmount();
//重新加载订单发货信息
BindOrderDetail();
}
/// <summary>
/// 单元格编辑与修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Window1.Hidden = true;
Window2.Hidden = true;
Window3.Hidden = true;
//新增行事件
var addList = Grid1.GetNewAddedList();
#region AddRow
foreach (var add in addList)
{
var dictValues = add.Values;
//商品代码
var firstOrDefault = dictValues.First();
if (firstOrDefault != null && !string.IsNullOrEmpty(firstOrDefault.ToString()))
{
DataSet dataSet = GasHelper.GetSalesItem(firstOrDefault.ToString(), CurrentUser.AccountComId);
DataTable table = dataSet.Tables[0];
if (table != null && table.Rows.Count > 0)
{
//decimal price = GasHelper.GeCustomerPrice(txtFCode.Text.Trim(),//
// table.Rows[0]["FItemCode"].ToString(), CurrentUser.AccountComId);
table.Rows[0]["FPrice"] = 0;
var details = new LHPassCardDetails
{
FItemCode = table.Rows[0]["FItemCode"].ToString(),
FPrice = 0,
FQty = 1,
FAmount = 0,
FBottleQty = 0,
FBottleOweQty = 0,
FRecycleQty = 0,
FCompanyId = CurrentUser.AccountComId,
KeyId = txtKeyId.Text.Trim(),
FBottle = table.Rows[0]["FBottleCode"].ToString(),
FCateId = Convert.ToInt32(table.Rows[0]["FId"].ToString())
};
StockOutDetailsService.Add(details);
}
}
}
#endregion
if (addList.Count > 0)
{
BindDataGrid();
}
}
/// <summary>
/// 单元格编辑与修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
AddListGrid();
ModifiedGrid();
//处理余量问题
BindDataGrid();
}
/// <summary>
/// 主材单价及发货数量编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
//根据绑定列的记录编号，获取发货物品信息和物品基本信息
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
ContractInfo contractInfo = Core.Container.Instance.Resolve <IServiceContractInfo>().GetEntity(rowID);
//修改高度
if (modifiedDict[rowIndex].Keys.Contains("DoorAmount"))
{
contractInfo.DoorAmount = Convert.ToDecimal(modifiedDict[rowIndex]["DoorAmount"]);
}
//修改宽度
if (modifiedDict[rowIndex].Keys.Contains("CabinetAmount"))
{
contractInfo.CabinetAmount = Convert.ToDecimal(modifiedDict[rowIndex]["CabinetAmount"]);
}
//修改厚度
if (modifiedDict[rowIndex].Keys.Contains("CabinetCost"))
{
contractInfo.CabinetCost = Convert.ToDecimal(modifiedDict[rowIndex]["CabinetCost"]);
}
//修改五金费用
if (modifiedDict[rowIndex].Keys.Contains("DoorCost"))
{
contractInfo.DoorCost = Convert.ToDecimal(modifiedDict[rowIndex]["DoorCost"]);
}
//修改超标加价
if (modifiedDict[rowIndex].Keys.Contains("SendCost"))
{
contractInfo.SendCost = Convert.ToDecimal(modifiedDict[rowIndex]["SendCost"]);
}
//修改标准单价
if (modifiedDict[rowIndex].Keys.Contains("HandWareCost"))
{
contractInfo.HandWareCost = Convert.ToDecimal(modifiedDict[rowIndex]["HandWareCost"]);
}
//修改最终单价
if (modifiedDict[rowIndex].Keys.Contains("AfterSaleCost"))
{
contractInfo.AfterSaleCost = Convert.ToDecimal(modifiedDict[rowIndex]["AfterSaleCost"]);
}
//计算商品总价
contractInfo.TotalAmount = contractInfo.DoorAmount + contractInfo.CabinetAmount;
//更新订单明细
Core.Container.Instance.Resolve <IServiceContractInfo>().Update(contractInfo);
}
BindGrid();
}
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
tm_SetMealDetail objInfo = Core.Container.Instance.Resolve <IServiceSetMealDetail>().GetEntity(rowID);
objInfo.DishCount = Int32.Parse(modifiedDict[rowIndex]["DishCount"].ToString());
objInfo.TotalPrice = objInfo.DishCount * objInfo.Price;
Core.Container.Instance.Resolve <IServiceSetMealDetail>().Update(objInfo);
}
BindGrid();
}
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, string> > modifiedDict = Grid1.GetModifiedDict();
int rowID = Convert.ToInt32(Grid1.DataKeys[e.RowIndex][0]);
DataRow row = FindRowByID(rowID);
UpdateDataRow(modifiedDict[e.RowIndex], row);
BindGrid();
labResult.Text = "用户修改的数据：" + Grid1.GetModifiedData().ToString(Newtonsoft.Json.Formatting.None);
Alert.Show("数据保存成功！（表格数据已重新绑定）");
}
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
tm_DishesBatching objInfo = Core.Container.Instance.Resolve <IServiceDishesBatching>().GetEntity(rowID);
objInfo.UsingCount = Convert.ToDecimal(modifiedDict[rowIndex]["UsingCount"]);
objInfo.CostPrice = objInfo.UsingUnitPrice * objInfo.UsingCount;
Core.Container.Instance.Resolve <IServiceDishesBatching>().Update(objInfo);
}
BindGrid();
}
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary<int, Dictionary<string, string>> modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
DataRow row = FindRowByID(rowID);
UpdateDataRow(modifiedDict[rowIndex], row);
}
BindGrid();
labResult.Text = "用户修改的数据：" + Grid1.GetModifiedData().ToString(Newtonsoft.Json.Formatting.None);
Alert.Show("数据保存成功！（表格数据已重新绑定）");
}
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
DataRow row = FindRowByID(rowID);
UpdateDataRow(modifiedDict[rowIndex], row);
}
BindGrid();
labResult.Text = String.Format("用户修改的数据：<pre>{0}</pre>", Grid1.GetModifiedData().ToString(Newtonsoft.Json.Formatting.Indented));
Alert.Show("数据保存成功！（表格数据已重新绑定）");
}
/// <summary>
/// 主材发货数量编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
//根据绑定列的记录编号，获取发货物品信息和物品基本信息
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
ContractOrderDetail objInfo = Core.Container.Instance.Resolve <IServiceContractOrderDetail>().GetEntity(rowID);
objInfo.GoodsInfo = Core.Container.Instance.Resolve <IServiceEquipmentInfo>().GetEntity(objInfo.GoodsID);
//修改发货数量
if (modifiedDict[rowIndex].Keys.Contains("GoodsNumber"))
{
objInfo.GoodsNumber = Convert.ToDecimal(modifiedDict[rowIndex]["GoodsNumber"]); //最终发货数量
objInfo.FormerlyGoodsNumber = Convert.ToDecimal(modifiedDict[rowIndex]["GoodsNumber"]); //原始发货数量
objInfo.NotOffsetNumber = Convert.ToDecimal(modifiedDict[rowIndex]["GoodsNumber"]); //商品待还数量
//更新辅材信息
UpdateSecondaryDetail(objInfo);
}
//计算并更新计价数量及重量
if (objInfo.PayUnit == 1)
{
//按计价单位计价，计价数量=商品规格*发货数量
// objInfo.GoodCalcPriceNumber = objInfo.GoodsInfo.Standard * objInfo.GoodsNumber;
}
else
{
//按出库数量计价，计价数量=发货数量
objInfo.GoodCalcPriceNumber = objInfo.GoodsNumber;
}
//计算客户、员工和司机的发货商品重量
//objInfo.GoodsCustomerWeight = objInfo.GoodsInfo.Standard * objInfo.GoodsNumber / objInfo.GoodsInfo.CustomerUnit;
//objInfo.GoodsDriverWeight = objInfo.GoodsInfo.Standard * objInfo.GoodsNumber / objInfo.GoodsInfo.DriverUnit;
//objInfo.GoodsStaffWeight = objInfo.GoodsInfo.Standard * objInfo.GoodsNumber / objInfo.GoodsInfo.StaffUnit;
////更新订单明细
Core.Container.Instance.Resolve <IServiceContractOrderDetail>().Update(objInfo);
//更新费用信息
new ContractOrderBase().CalcOrderCost(OrderNO);
//CalcOrderCost();
}
//重新加载订单发货信息
BindOrderDetail();
}
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
PriceSetGoodsInfo objInfo = Core.Container.Instance.Resolve <IServicePriceSetGoodsInfo>().GetEntity(rowID);
if (modifiedDict[rowIndex].Keys.Contains("DailyRents"))
{
objInfo.DailyRents = Convert.ToDecimal(modifiedDict[rowIndex]["DailyRents"]);
}
if (modifiedDict[rowIndex].Keys.Contains("UnitPrice"))
{
objInfo.UnitPrice = Convert.ToDecimal(modifiedDict[rowIndex]["UnitPrice"]);
}
if (modifiedDict[rowIndex].Keys.Contains("FixPrice"))
{
objInfo.FixPrice = Convert.ToDecimal(modifiedDict[rowIndex]["FixPrice"]);
}
if (modifiedDict[rowIndex].Keys.Contains("MinRentingDays"))
{
objInfo.MinRentingDays = Convert.ToInt32(modifiedDict[rowIndex]["MinRentingDays"]);
}
if (modifiedDict[rowIndex].Keys.Contains("CustomerUnit"))
{
objInfo.CustomerUnit = Convert.ToDecimal(modifiedDict[rowIndex]["CustomerUnit"]);
}
if (modifiedDict[rowIndex].Keys.Contains("DriverUnit"))
{
objInfo.DriverUnit = Convert.ToDecimal(modifiedDict[rowIndex]["DriverUnit"]);
}
if (modifiedDict[rowIndex].Keys.Contains("StaffUnit"))
{
objInfo.StaffUnit = Convert.ToDecimal(modifiedDict[rowIndex]["StaffUnit"]);
}
Core.Container.Instance.Resolve <IServicePriceSetGoodsInfo>().Update(objInfo);
}
BindGrid();
}
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
try
{
string sortindex = "";
if (Grid1.GetNewAddedList().Count != 0)
{
List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList();
string sql = "select count(*)+1 from BaseData where stype='" + newAddedList[newAddedList.Count - 1]["SType"].ToString() + "'";
SQLHelper.DbHelperSQL.SetConnectionString("");
sortindex = SQLHelper.DbHelperSQL.GetSingle(sql, 30);
Grid1.UpdateCellValue(e.RowIndex, e.ColumnID, sortindex);
}
}
catch (Exception ee)
{
Alert.Show(ee.Message);
}
}
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
EquipmentAssortInfo objInfo = Core.Container.Instance.Resolve <IServiceEquipmentAssortInfo>().GetEntity(rowID);
if (modifiedDict[rowIndex].Keys.Contains("AssortCount"))
{
objInfo.AssortCount = Convert.ToDecimal(modifiedDict[rowIndex]["AssortCount"]);
}
if (modifiedDict[rowIndex].Keys.Contains("EquipmentCount"))
{
objInfo.EquipmentCount = Convert.ToDecimal(modifiedDict[rowIndex]["EquipmentCount"]);
}
if (modifiedDict[rowIndex].Keys.Contains("IsOutCalcNumber"))
{
objInfo.IsOutCalcNumber = Convert.ToInt32(modifiedDict[rowIndex]["IsOutCalcNumber"]);
}
if (modifiedDict[rowIndex].Keys.Contains("IsOutCalcPrice"))
{
objInfo.IsOutCalcPrice = Convert.ToInt32(modifiedDict[rowIndex]["IsOutCalcPrice"]);
}
if (modifiedDict[rowIndex].Keys.Contains("IsInCalcNumber"))
{
objInfo.IsInCalcNumber = Convert.ToInt32(modifiedDict[rowIndex]["IsInCalcNumber"]);
}
if (modifiedDict[rowIndex].Keys.Contains("IsInCalcPrice"))
{
objInfo.IsInCalcPrice = Convert.ToInt32(modifiedDict[rowIndex]["IsInCalcPrice"]);
}
Core.Container.Instance.Resolve <IServiceEquipmentAssortInfo>().Update(objInfo);
}
BindGrid();
}
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
ReceiveOrderDetail objInfo = Core.Container.Instance.Resolve <IServiceReceiveOrderDetail>().GetEntity(rowID);
if (modifiedDict[rowIndex].Keys.Contains("GoodsUnitPrice"))
{
objInfo.GoodsUnitPrice = Convert.ToDecimal(modifiedDict[rowIndex]["GoodsUnitPrice"]);
}
if (modifiedDict[rowIndex].Keys.Contains("GoodsNumber"))
{
objInfo.GoodsNumber = Convert.ToDecimal(modifiedDict[rowIndex]["GoodsNumber"]);
}
objInfo.GoodTotalPrice = objInfo.GoodsUnitPrice * objInfo.GoodsNumber;
Core.Container.Instance.Resolve <IServiceReceiveOrderDetail>().Update(objInfo);
}
BindGrid();
}
/// <summary>
/// 辅材赔偿数量编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridSecondDetail_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = GridSecondDetail.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
//根据绑定列的记录编号，获取收货物品辅材信息和物品基本信息
int rowID = Convert.ToInt32(GridSecondDetail.DataKeys[rowIndex][0]);
ContractOrderSecondaryDetail objInfo = Core.Container.Instance.Resolve <IServiceContractOrderSecondaryDetail>().GetEntity(rowID);
objInfo.GoodsInfo = Core.Container.Instance.Resolve <IServiceEquipmentInfo>().GetEntity(objInfo.GoodsID);
//修改收货数量
if (modifiedDict[rowIndex].Keys.Contains("PayForNumber"))
{
objInfo.PayForNumber = Convert.ToDecimal(modifiedDict[rowIndex]["PayForNumber"]); //赔偿数量
objInfo.GoodsNumber = objInfo.FormerlyGoodsNumber - objInfo.PayForNumber; //最终收货数量
objInfo.GoodsTotalPrice = objInfo.PayForNumber * objInfo.GoodsUnitPrice;
}
//更新辅材信息
Core.Container.Instance.Resolve <IServiceContractOrderSecondaryDetail>().Update(objInfo);
}
//重新加载订单收货信息
BindSecondaryGoodsInfo();
}
/// <summary>
/// 相关费用单价及数量编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gdCostInfo_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Dictionary <int, Dictionary <string, object> > modifiedDict = gdCostInfo.GetModifiedDict();
foreach (int rowIndex in modifiedDict.Keys)
{
int rowID = Convert.ToInt32(gdCostInfo.DataKeys[rowIndex][0]);
ContractOrderCostInfo objInfo = Core.Container.Instance.Resolve <IServiceContractOrderCostInfo>().GetEntity(rowID);
if (modifiedDict[rowIndex].Keys.Contains("PayPrice"))
{
objInfo.PayPrice = Convert.ToDecimal(modifiedDict[rowIndex]["PayPrice"]);
}
if (modifiedDict[rowIndex].Keys.Contains("OrderNumber"))
{
objInfo.OrderNumber = Convert.ToDecimal(modifiedDict[rowIndex]["OrderNumber"]);
}
objInfo.CostAmount = objInfo.PayPrice * objInfo.OrderNumber;
Core.Container.Instance.Resolve <IServiceContractOrderCostInfo>().Update(objInfo);
}
BindCostsInfo();
}
/// <summary>
/// 单元格编辑与修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Window1.Hidden = true;
Window2.Hidden = true;
Window3.Hidden = true;
}
/// <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>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
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(), CurrentUser.AccountComId);
DataTable table = dataSet.Tables[0];
if (table != null && table.Rows.Count > 0)
{
decimal price = GasHelper.GeSupplierPrice("",//
table.Rows[0]["FItemCode"].ToString(), CurrentUser.AccountComId);
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,
FCompanyId = CurrentUser.AccountComId,
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;
}
StockOutDetailsService.Add(details);
}
}
}
if (addList.Count > 0)
{
BindDataGrid();
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
}
/// <summary>
/// 单元格编辑与修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e)
{
Window1.Hidden = true;
Window2.Hidden = true;
Window3.Hidden = true;
//新增行事件
var addList = Grid1.GetNewAddedList();
#region AddRow
foreach (var add in addList)
{
var dictValues = add.Values;
//商品代码
var firstOrDefault = dictValues.First();
if (firstOrDefault != null && !string.IsNullOrEmpty(firstOrDefault.ToString()))
{
DataSet dataSet = GasHelper.GetSalesItem(firstOrDefault.ToString(), CurrentUser.AccountComId);
DataTable table = dataSet.Tables[0];
if (table != null && table.Rows.Count > 0)
{
decimal price = GasHelper.GeCustomerPrice(txtFCode.Text.Trim(),//
table.Rows[0]["FItemCode"].ToString(), CurrentUser.AccountComId);
table.Rows[0]["FPrice"] = price;
var details = new LHBottleDetectionDetails
{
FItemCode = table.Rows[0]["FItemCode"].ToString(),
FPrice = price,
FQty = 1,
FAmount = price,
FBottleQty = 0,
FBottleOweQty = 0,
FRecycleQty = 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 = 0,
// FCompanyId = CurrentUser.AccountComId,
// FBottleOweQty = 0,
// KeyId = txtKeyId.Text.Trim(),
// FBottle = table.Rows[0]["FBottleCode"].ToString(),
// FStatus = "新增",
// FMemo = string.Format(@"时间：{0} 新增人：{1}", DateTime.Now, CurrentUser.AccountName)
//};
//StockOutDetailsLogService.Add(detailslog);
break;
}
BottleDetectionDetailsService.Add(details);
}
}
}
#endregion
if (addList.Count > 0)
{
BindDataGrid();
}
}
