/// <summary>
/// 页面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetPermissionButtons(Toolbar1);
GasHelper.DropDownListBillStatusDataBind(ddlFStatus);
dateBegin.SelectedDate = DateTime.Now;
dateEnd.SelectedDate = DateTime.Now;
BindDataGrid();
}
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var stock = DispatchCommissionService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (stock != null)
{
AddListGrid();
ModifiedGrid();
/////////////////////////////////////////////////////////////////////////////
stock.FDate = txtFDate.SelectedDate;
stock.FMemo = txtFMemo.Text.Trim();
DispatchCommissionService.SaveChanges();
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "TC", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "14");
orderParms.Add("@companyId", CurrentUser.AccountComId);
SqlService.ExecuteProcedureCommand("proc_num", orderParms);
txtKeyId.Text = newKeyId;
//新增日志
var billStatus = new LHBillStatus
{
KeyId = newKeyId,
FCompanyId = CurrentUser.AccountComId,
FActionName = "新增",
FDate = DateTime.Now,
FDeptId = CurrentUser.AccountOrgId,
FOperator = CurrentUser.AccountName,
FMemo = String.Format("单据号{0},{1}新增送货提成单据。", newKeyId, CurrentUser.AccountName)
};
GasHelper.AddBillStatus(billStatus);
}
return(true);
}
return(false);
}
/// <summary>
/// 页面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetPermissionButtons(Toolbar1);
dpkFDate.SelectedDate = DateTime.Today;
tbxFCustomer.OnClientTriggerClick = Window1.GetSaveStateReference(txtFCode.ClientID, tbxFCustomer.ClientID)
+ Window1.GetShowReference("../../Common/WinCustomer.aspx");
GasHelper.DropDownListCompanyDataBind(ddlCompany);
GasHelper.DropDownListAuditorsDataBind(ddlSeller);
}
}
/// <summary>
/// 页面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetPermissionButtons(Toolbar1);
//单据状态
GasHelper.DropDownListBillStatusDataBind(ddlFStatus);
//btnAdd.OnClientClick = Window1.GetShowReference(string.Format("./Edit.aspx?action=1"), "发货单");
btnBatchDelete.ConfirmText = "你确定要执行作废操作吗？";
BindDataGrid();
}
}
/// <summary>
/// 作废
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnBatchDelete_Click(object sender, EventArgs e)
{
IEnumerable <string> selectIds = GetSelectIds();
try
{
Log(string.Format(@"作废单据号:{0}成功。", selectIds));
//
foreach (var ids in selectIds)
{
var status = new LHBillStatus();
status.FCompanyId = CurrentUser.AccountComId;
status.FDeptId = CurrentUser.AccountOrgId;
status.FDate = DateTime.Now;
status.FOperator = CurrentUser.AccountName;
status.FActionName = EnumDescription.GetFieldText(GasEnumBillStauts.Voided);
status.KeyId = ids;
status.FMemo = string.Format("单据号{0}被{1}作废处理。", ids, CurrentUser.AccountName);
GasHelper.AddBillStatus(status);
var parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@KeyId", ids);
parms.Add("@companyId", CurrentUser.AccountComId);
parms.Add("@Bill", 1);
SqlService.ExecuteProcedureNonQuery("proc_DeleteFlag", parms);
}
LiquidPlanTaskService.Update(p => p.FCompanyId == CurrentUser.AccountComId && selectIds.Contains(p.KeyId), p => new LHLiquidPlanTask
{
FFlag = 0, //
FStatus = Convert.ToInt32(GasEnumBillStauts.Voided), //
//FProgress = Convert.ToInt32(GasEnumBillStauts.Voided)
});
Alert.Show("作废成功！", MessageBoxIcon.Information);
BindDataGrid();
}
catch (Exception)
{
Alert.Show("作废失败！", MessageBoxIcon.Warning);
}
}
/// <summary>
/// 页面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetPermissionButtons(Toolbar1);
dpkFDateBegin.SelectedDate = DateTime.Now;
dpkFDateEnd.SelectedDate = DateTime.Now;
GasHelper.DropDownListCompanyDataBind(ddlCompany);
//GasHelper.DropDownListDriverDataBind(ddlFDriver);
//GasHelper.DropDownListSupercargoDataBind(ddlFSupercargo);
}
}
/// <summary>
/// 页面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetPermissionButtons(Toolbar1);
//单据状态
GasHelper.DropDownListBillStatusDataBind(ddlFStatus);
btnBatchDelete.ConfirmText = "你确定要执行作废操作吗？";
dateBegin.SelectedDate = DateTime.Now;
dateEnd.SelectedDate = DateTime.Now;
BindDataGrid();
}
}
/// <summary>
/// 页面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetPermissionButtons(Toolbar1);
btnAdd.OnClientClick = Window1.GetShowReference(string.Format("./SetPriceEdit.aspx?action=1"), "设置客户对应产品销售价");
//btnView.OnClientClick = Window2.GetShowReference(string.Format("./SetContractIndex.aspx"), "查看客户合同");
//btnBatchDelete.ConfirmText = "你确定要执行删除操作吗？";
GasHelper.DropDownListSalesmanDataBind(ddlFSalesman);
BindDataGrid();
}
}
/// <summary>
/// 初始化页面数据
/// </summary>
private void InitData()
{
btnClose.OnClientClick = ActiveWindow.GetHidePostBackReference();
//GasHelper.DropDownListDriverDataBind(ddlFDriver);
//GasHelper.DropDownListSupercargoDataBind(ddlFSupercargo);
//GasHelper.DropDownListVehicleNumDataBind(ddlFVehicleNum);
//物流公司
GasHelper.DropDownListLogisticsDataBind(ddlLogistics);
GasHelper.DropDownListDistributionPointDataBind(ddlFrom);
GasHelper.DropDownListDistributionPointDataBind(ddlTo);
dptBeginDate.SelectedDate = DateTime.Now;
dptEnd.SelectedDate = DateTime.Now;
dpBeginTime.SelectedDate = DateTime.Now;
string logistic = ddlLogistics.SelectedValue;
//车
ddlFVehicleNum.DataSource =
VehicleService.Where(p => p.FLogistics == logistic && p.FCompanyId == CurrentUser.AccountComId && p.FISMain == "是");
ddlFVehicleNum.DataBind();
ddlFVehicleNum.Items.Insert(0, new ListItem(@"", "-1"));
//司机
ddlFDriver.DataSource =//p.FLogistics == logistic &&
EmployeeService.Where(p => p.deleteflag == 0 && p.FCompanyId == CurrentUser.AccountComId &&//
p.professional.Contains("司机"));
ddlFDriver.DataBind();
ddlFDriver.Items.Insert(0, new ListItem(@"", "-1"));
//押运员
ddlFSupercargo.DataSource =//p.FLogistics == logistic &&
EmployeeService.Where(p => p.deleteflag == 0 && p.FCompanyId == CurrentUser.AccountComId && //
p.professional.Contains("押运员"));
ddlFSupercargo.DataBind();
ddlFSupercargo.Items.Insert(0, new ListItem(@"", "-1"));
}
/// <summary>
/// 初始化页面数据
/// </summary>
private void InitData()
{
ViewState["_AppendToEnd"] = true;
txtCreateBy.Text = CurrentUser.AccountName;
GasHelper.DropDownListDriverDataBind(ddlFDriver);
GasHelper.DropDownListSupercargoDataBind(ddlFSupercargo);
GasHelper.DropDownListVehicleNumDataBind(ddlFVehicleNum);
//删除选中单元格的客户端脚本
string deleteScript = DeleteScript();
//新增
var defaultObj = new JObject
{
{ "KeyId", "" },
{ "FDate", DateTime.Now.ToString("yyyy-MM-dd") },
{ "FCode", "" },
{ "FName", "" },
{ "FArea", "1" },
{ "FItemName", "0" },
{ "FSp", "0" },
{ "FSpPrice", "0" },
{ "FKp", "0" },
{ "FKpPrice", "0" },
{ "FSumPrice", "0" },
{ "FDriver", "" },
{ "FDriverPrice", "0" },
{ "FSupercargo", "" },
{ "FSupercargoPrice", "0" },
{ "FVehicleNum", "" },
{ "FMemo", "" },
{ "colDelete", String.Format("<a href=\"javascript:;\" onclick=\"{0}\"><img src=\"{1}\"/></a>",//
deleteScript, IconHelper.GetResolvedIconUrl(Icon.Delete)) },
};
// 在第一行新增一条数据
btnAdd.OnClientClick = Grid1.GetAddNewRecordReference(defaultObj, AppendToEnd);
txtFDate.SelectedDate = DateTime.Now;
}
/// <summary>
/// 初始化页面数据
/// </summary>
private void InitData()
{
ViewState["_AppendToEnd"] = true;
txtCreateBy.Text = CurrentUser.AccountName;
//原料
tbxFItemCode.OnClientTriggerClick = Window1.GetSaveStateReference(tbxFItemCode.ClientID)
+ Window1.GetShowReference("../../Common/WinFormula.aspx");
//产品
tbxFName.OnClientTriggerClick = Window2.GetSaveStateReference(txtFCode.ClientID, tbxFName.ClientID, tbxFBottle.ClientID)
+ Window2.GetShowReference("../../Common/WinProducReference.aspx");
GasHelper.DropDownListProducerDataBind(ddlFProducer);
GasHelper.DropDownListBottleDataBind(tbxFBottle);
GasHelper.DropDownListSurveyorDataBind(ddlFSurveyor);
GasHelper.DropDownListWorkshopDataBind(ddlWorkShop);
//删除选中单元格的客户端脚本
string deleteScript = DeleteScript();
//新增
var defaultObj = new JObject
{
{ "FItemCode", "" },
{ "FItemName", "" },
{ "FSpec", "" },
{ "FUnit", "" },
{ "FPrice", "" },
{ "FQty", "0" },
{ "FAmount", "0" },
{ "FCateName", "" },
{ "colDelete", String.Format("<a href=\"javascript:;\" onclick=\"{0}\"><img src=\"{1}\"/></a>",//
deleteScript, IconHelper.GetResolvedIconUrl(Icon.Delete)) },
};
// 在第一行新增一条数据
btnAddFormula.OnClientClick = Grid1.GetAddNewRecordReference(defaultObj, AppendToEnd);
txtFDate.SelectedDate = DateTime.Now;
}
/// <summary>
/// 页面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetPermissionButtons(Toolbar1);
dpkFDateBegin.SelectedDate = DateTime.Now;
GasHelper.DropDownListCompanyDataBind(ddlCompany);
tbxFCustomer.OnClientTriggerClick = Window1.GetSaveStateReference(txtFCode.ClientID, tbxFCustomer.ClientID)
+ Window1.GetShowReference("../../Common/WinCustomer.aspx");
//产品
//tbxFItemName.OnClientTriggerClick = Window2.GetSaveStateReference(txtItemCode.ClientID, tbxFItemName.ClientID)
// + Window2.GetShowReference("../../Common/WinProducReference.aspx");
}
}
protected void tbxFSupplier_OnTextChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(tbxFSupplier.Text.Trim()))
{
Window2.Hidden = true;
var custmoer = SupplierService.Where(p => p.FName == tbxFSupplier.Text.Trim() &&//
p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (custmoer != null)
{
txtFSupplierCode.Text = custmoer.FCode;
decimal price = GasHelper.GeSupplierPrice(custmoer.FCode, //
tbxFItemName.SelectedValue, CurrentUser.AccountComId);
tbxFPurchasedPrice.Text = price.ToString();
}
}
}
/// <summary>
/// 页面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetPermissionButtons(Toolbar1);
btnAdd.OnClientClick = Window1.GetShowReference(string.Format("./edit.aspx?action=1&FSubCateId={0}",
trDept.SelectedNodeID), "添加客户");
//btnBatchDelete.ConfirmText = "你确定要执行删除操作吗？";
GasHelper.DropDownListSalesmanDataBind(ddlFSalesman);
//客户分类
LoadTreeSource();
BindDataGrid();
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnBatchDelete_Click(object sender, EventArgs e)
{
IEnumerable <string> selectIds = GetSelectIds();
try
{
Log(string.Format(@"作废单据号:{0}成功。", selectIds));
//StockInService.Update(p => selectIds.Contains(p.KeyId), p => new LHStockIn { FFlag = 0 });
//
foreach (string ids in selectIds)
{
LHBillStatus status = new LHBillStatus
{
FCompanyId = CurrentUser.AccountComId,
FDeptId = CurrentUser.AccountOrgId,
FDate = DateTime.Now,
FOperator = CurrentUser.AccountName,
FActionName = EnumDescription.GetFieldText(GasEnumBillStauts.Voided),
KeyId = ids,
FMemo = string.Format("单据号{0}被{1}作废处理。", ids, CurrentUser.AccountName)
};
GasHelper.AddBillStatus(status);
}
StockInService.Update(p => selectIds.Contains(p.KeyId), p => new LHStockIn
{
FFlag = 0, //
FStatus = Convert.ToInt32(GasEnumBillStauts.Voided), //
FProgress = Convert.ToInt32(GasEnumBillStauts.Voided)
});
Alert.Show("作废成功！", MessageBoxIcon.Information);
BindDataGrid();
}
catch (Exception)
{
Alert.Show("作废失败！", MessageBoxIcon.Warning);
}
}
//protected void Window1_Close(object sender, WindowCloseEventArgs e)
//{
// BindDataGrid();
//}
/// <summary>
/// 页面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//关闭
btnClose.OnClientClick = ActiveWindow.GetHidePostBackReference();
dateBegin.SelectedDate = DateTime.Now;
dateEnd.SelectedDate = DateTime.Now;
//单据状态
//GasHelper.DropDownListBillStatusDataBind(ddlFBill);
GasHelper.DropDownListDistributionPointDataBind(ddlFDistributionPoint); //作业区
BindDataGrid();
BindDataDispatchCenterGrid();//调度作业
}
}
protected void tbxFName3_OnTextChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(tbxFName3.Text.Trim()))
{
var custmoer = CustomerService.Where(p => p.FName == tbxFName3.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (custmoer != null)
{
tbxFCode3.Text = custmoer.FCode;
if (!string.IsNullOrEmpty(tbxFItemName.SelectedValue))
{
decimal price = GasHelper.GeCustomerPrice(tbxFCode3.Text.Trim(), //
tbxFItemName.SelectedValue, CurrentUser.AccountComId);
txtFPrice3.Text = price.ToString(CultureInfo.InvariantCulture);
}
}
}
}
/// <summary>
/// 页面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetPermissionButtons(Toolbar1);
dpkFDateBegin.SelectedDate = DateTime.Now;
//dpkFDateEnd.SelectedDate = DateTime.Now;
GasHelper.DropDownListBottleAllDataBind(ddlBottle);
GasHelper.DropDownListSalesmanDataBind(ddlFSalesman);
LoadTreeSource();
//全部
BindDataGrid();
}
}
protected void tbxFCustomer_OnTextChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(tbxFCustomer.Text.Trim()))
{
var custmoer = CustomerService.Where(p => p.FName == tbxFCustomer.Text.Trim() && //
p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (custmoer != null)
{
txtFCode.Text = custmoer.FCode;
ddlFAddress.SelectedValue = custmoer.FAddress.Trim();
//txtFAddress.Text = custmoer.FAddress.Trim();
txtFFreight.Text = custmoer.FFreight.ToString();
txtFLinkman.Text = custmoer.FLinkman;
txtFPhone.Text = custmoer.FPhome;
GasHelper.DropDownListOrgDataBind(ddlFOrgName, custmoer.FCode);
GasHelper.DropDownListAddressDataBind(ddlFAddress, custmoer.FCode);
}
}
}
/// <summary>
/// 页面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetPermissionButtons(Toolbar1);
//GasHelper.DropDownListCompanyDataBind(ddlCompany);
LoadTreeSource();
dpkFDateBegin.SelectedDate = DateTime.Now;
GasHelper.DropDownListAreasDataBind(ddlFArea);
GasHelper.DropDownListSalesmanDataBind(ddlFSalesman);
GasHelper.DropDownListBottleAllDataBind(ddlBottle);
tbxFCustomer.OnClientTriggerClick = Window1.GetSaveStateReference(txtFCode.ClientID, tbxFCustomer.ClientID)
+ Window1.GetShowReference("../../Common/WinCustomer.aspx");
}
}
/// <summary>
/// 提交编辑
/// </summary>
private bool SubmintEdit()
{
if (LiquidPlanTask != null)
{
LiquidPlanTask.FCode = txtFCode.Text;
LiquidPlanTask.FName = tbxFCustomer.Text;
//------------------------------------------------------
LiquidPlanTask.FAddress = txtFAddress.Text.Trim();
LiquidPlanTask.FDate = txtFDate.SelectedDate;
LiquidPlanTask.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : "";
LiquidPlanTask.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : "";
LiquidPlanTask.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim());
LiquidPlanTask.FLinkman = txtFLinkman.Text.Trim();
LiquidPlanTask.FMemo = txtFMemo.Text.Trim();
LiquidPlanTask.FPhone = txtFPhone.Text.Trim();
LiquidPlanTask.FSalesman = ddlFSalesman.SelectedValue;
LiquidPlanTask.FArea = ddlFArea.SelectedValue;
LiquidPlanTask.FReconciliation = txtFReconciliation.Text;
LiquidPlanTask.FDeliveryMethod = ddlDeliveryMethod.SelectedValue;
LiquidPlanTask.FLogisticsNumber = txtFLogisticsNumber.Text;
LiquidPlanTask.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray);
LiquidPlanTask.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray);
LiquidPlanTask.FQty = Convert.ToDecimal(txtFQty.Text);
LiquidPlanTask.FPrice = Convert.ToDecimal(txtFPrice.Text);
LiquidPlanTask.FAmount = LiquidPlanTask.FPrice * LiquidPlanTask.FQty;
LiquidPlanTask.FItemCode = tbxFItemName.SelectedValue;
LiquidPlanTask.FItemName = tbxFItemName.SelectedText;
LiquidPlanTaskService.SaveChanges();
return(true);
}
return(false);
}
/// <summary>
/// 初始化页面数据
/// </summary>
private void InitData()
{
btnClose.OnClientClick = ActiveWindow.GetHidePostBackReference();
GasHelper.DropDownListLiquidDataBind(tbxFItemName);
GasHelper.DropDownListVehicleNumDataBind(tbxFVehicleNum);
GasHelper.DropDownListDriverDataBind(tbxFDriver);
GasHelper.DropDownListSupercargoDataBind(tbxFSupercargo);
GasHelper.DropDownListSalesmanDataBind(ddlFSalesman);
//GasHelper.DropDownListSupplierDataBind(tbxFSupplierName);
//GasHelper.DropDownListCustomerDataBind(tbxFName1);
//GasHelper.DropDownListCustomerDataBind(tbxFName2);
//GasHelper.DropDownListCustomerDataBind(tbxFName3);
tbxFSupplier.OnClientTriggerClick = Window1.GetSaveStateReference(txtFSupplierCode.ClientID, tbxFSupplier.ClientID)
+ Window1.GetShowReference("../../Common/WinSupplier.aspx");
tbxFName1.OnClientTriggerClick = Window2.GetSaveStateReference(tbxFCode1.ClientID, tbxFName1.ClientID)
+ Window2.GetShowReference("../../Common/WinCustomer.aspx");
tbxFName2.OnClientTriggerClick = Window2.GetSaveStateReference(tbxFCode2.ClientID, tbxFName2.ClientID)
+ Window2.GetShowReference("../../Common/WinCustomer.aspx");
tbxFName3.OnClientTriggerClick = Window2.GetSaveStateReference(tbxFCode3.ClientID, tbxFName3.ClientID)
+ Window2.GetShowReference("../../Common/WinCustomer.aspx");
FDate1.SelectedDate = DateTime.Now;
FDate2.SelectedDate = DateTime.Now;
FDate3.SelectedDate = DateTime.Now;
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var liquidPlan = new LHLiquidPlan();
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), //
"LP", CurrentUser.AccountComId);
liquidPlan.FCompanyId = CurrentUser.AccountComId;
liquidPlan.KeyId = newKeyId;
liquidPlan.CreateBy = CurrentUser.AccountName;
liquidPlan.FDate = txtFDate.SelectedDate;
liquidPlan.FItemCode = tbxFItemName.SelectedValue;
liquidPlan.FItemName = tbxFItemName.SelectedText;
liquidPlan.FBill = tbxFBill.SelectedValue;
liquidPlan.FVehicleNum = tbxFVehicleNum.SelectedValue;
liquidPlan.FDriver = GasHelper.GetDropDownListArrayString(tbxFDriver.SelectedItemArray);
liquidPlan.FSupercargo = tbxFSupercargo.SelectedValue;
liquidPlan.FMargin = Convert.ToDecimal(tbxFMargin.Text);
liquidPlan.FMemo = txtFMemo.Text;
LiquidPlanService.Add(liquidPlan);
var parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@keyId", newKeyId);
parms.Add("@companyId", CurrentUser.AccountComId);
parms.Add("@keyId1", Grid1SelectIds());
parms.Add("@keyId2", Grid2SelectIds().ToList()[0]);
parms.Add("@keyId3", Grid2SelectIds().ToList()[1]);
parms.Add("@keyId4", Grid2SelectIds().ToList()[2]);
SqlService.ExecuteProcedureCommand("proc_LiquidPlanMergeProc", parms);
return(true);
}
/// <summary>
/// 页面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetPermissionButtons(Toolbar1);
dpkFDateBegin.SelectedDate = DateTime.Now;
dpkFDateEnd.SelectedDate = DateTime.Now;
GasHelper.DropDownListCompanyDataBind(ddlCompany);
GasHelper.DropDownListGroupDataBind(ddlFGroup);//班组
//GasHelper.DropDownListProducerDataBind(ddlFProducer);
//GasHelper.DropDownListWorkshopDataBind(ddlWorkShop);
////产品
//tbxFName.OnClientTriggerClick = Window2.GetSaveStateReference(txtFCode.ClientID, tbxFName.ClientID)
// + Window2.GetShowReference("../../Common/WinProducReference.aspx");
}
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
//生成调度单
LHDispatchCenter dispatch = new LHDispatchCenter();
//调度单号生成
string newKeyId = SequenceService.CreateSequence("PC", CurrentUser.AccountComId);
dispatch.KeyId = newKeyId; lblKeyId.Text = newKeyId;
dispatch.FCompanyId = CurrentUser.AccountComId;
dispatch.FBeginDate = dptBeginDate.SelectedDate;
dispatch.FBeginTime = dpBeginTime.Text.Trim();
dispatch.FEndDate = dptEnd.SelectedDate;
dispatch.FEndTime = dpEndTime.Text.Trim();
dispatch.FDate = DateTime.Now;
dispatch.FVehicleNum = ddlFVehicleNum.SelectedValue;
dispatch.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray);
dispatch.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray);
dispatch.CreateBy = CurrentUser.AccountName;
dispatch.FFlag = 1;
dispatch.FLogistics = ddlLogistics.SelectedText;
dispatch.FLogisticsCode = ddlLogistics.SelectedValue;
dispatch.FActual = string.IsNullOrEmpty(txtFActual.Text.Trim()) ? 0M : Convert.ToDecimal(txtFActual.Text.Trim());
dispatch.FTrailerPlate = ddlFTrailerPlate.SelectedValue;
dispatch.FFrom = ddlFrom.SelectedValue;
dispatch.FTo = ddlTo.SelectedValue;
dispatch.FDeliveryMethod = ddlDeliveryMethod.SelectedValue;
dispatch.FAuditFlag = 0;
DispatchCenterService.Add(dispatch);
string[] keys = KeyId.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
string[] patch = patchid.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string key in keys)
{
if (!string.IsNullOrEmpty(key))
{
//状态
LHBillStatus flow = new LHBillStatus
{
KeyId = key,
FCompanyId = CurrentUser.AccountComId,
FDeptId = CurrentUser.AccountOrgId,
FOperator = CurrentUser.AccountName,
FDate = Convert.ToDateTime(dptBeginDate.SelectedDate),
FActionName = "配车",
FMemo = string.Format(@"单据号{0}被{1}作配车业务处理。", key, CurrentUser.AccountName)
};
BillStatusService.Add(flow);
LHStockOut info = new StockOutService().FirstOrDefault(p => p.KeyId == key && p.FCompanyId == CurrentUser.AccountComId);
if (info != null)
{
Dictionary <string, object> infoParms = new Dictionary <string, object>();
infoParms.Clear();
infoParms.Add("@keyid", info.FLogisticsNumber);
infoParms.Add("@companyId", CurrentUser.AccountComId);
infoParms.Add("@FVehicleNum", ddlFVehicleNum.SelectedValue);
infoParms.Add("@FDriver", GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray));
infoParms.Add("@FSupercargo", GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray));
infoParms.Add("@FDispatchNum", newKeyId); //调度单号
SqlService.ExecuteProcedureCommand("proc_DispatchCenter", infoParms);
}
//变更单据上的司机、押韵员、车牌号
Dictionary <string, object> parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@keyid", key);
parms.Add("@companyId", CurrentUser.AccountComId);
parms.Add("@FVehicleNum", ddlFVehicleNum.SelectedValue);
parms.Add("@FDriver", GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray));
parms.Add("@FSupercargo", GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray));
parms.Add("@FDispatchNum", newKeyId); //调度单号
SqlService.ExecuteProcedureCommand("proc_DispatchCenter", parms);
List <LHStockOut> outs = new List <LHStockOut>();
List <LHPassCard> cards = new List <LHPassCard>();
}
}
foreach (var item in patch)
{
LHStockOutDispatch dis = StockoutDispatchServices.Where(p => p.KeyId == item).FirstOrDefault();
if (dis != null)
{
dis.FState = 1;
StockoutDispatchServices.SaveChanges();
}
}
return(true);
}
/// <summary>
/// 提交编辑
/// </summary>
private bool SubmintEdit()
{
if (DispatchCenter != null)
{
DispatchCenter.FAccount = string.IsNullOrEmpty(txtAmount.Text) ? 0 : Convert.ToDecimal(txtAmount.Text);
DispatchCenter.FBeginDate = dptBeginDate.SelectedDate;
DispatchCenter.FVehicleNum = ddlFVehicleNum.SelectedValue;
DispatchCenter.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray);
DispatchCenter.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray);
DispatchCenter.FBeginTime = dpBeginTime.Text.Trim();
DispatchCenter.FEndTime = dpEndTime.Text.Trim();
DispatchCenter.FEndDate = dptEnd.SelectedDate;
DispatchCenter.FFuelingDate = dptFFuelingDate.SelectedDate;
DispatchCenter.FMileage = string.IsNullOrEmpty(txtFMileage.Text)
? 0
: Convert.ToDecimal(txtFMileage.Text);
DispatchCenter.FPrice = string.IsNullOrEmpty(txtPrice.Text) ? 0 : Convert.ToDecimal(txtPrice.Text);
DispatchCenter.FQty = string.IsNullOrEmpty(txtFQty.Text) ? 0 : Convert.ToDecimal(txtFQty.Text);
DispatchCenter.Memo = txtFMemo.Text;
DispatchCenter.FLogistics = ddlLogistics.SelectedText;
DispatchCenter.FLogisticsCode = ddlLogistics.SelectedValue;
DispatchCenter.FActual = string.IsNullOrEmpty(txtFActual.Text.Trim()) ? 0M : Convert.ToDecimal(txtFActual.Text.Trim());
DispatchCenter.FTrailerPlate = ddlFTrailerPlate.SelectedValue;
DispatchCenter.FFrom = ddlFrom.SelectedValue;
DispatchCenter.FTo = ddlTo.SelectedValue;
DispatchCenter.FDeliveryMethod = ddlDeliveryMethod.SelectedValue;
//变更单据上的司机、押韵员、车牌号
Dictionary <string, object> parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@keyid", lblKeyId.Text);
parms.Add("@FCompanyId", CurrentUser.AccountComId);
DataTable data = SqlService.ExecuteProcedureCommand("proc_DispatchDetails", parms).Tables[0];
EnumerableRowCollection <object> keys = (from x in data.AsEnumerable()
select x["keyid"]);
foreach (string item in keys)
{
parms.Clear();
parms.Add("@keyid", item);
parms.Add("@companyId", CurrentUser.AccountComId);
parms.Add("@FVehicleNum", ddlFVehicleNum.SelectedValue);
parms.Add("@FDriver", GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray));
parms.Add("@FSupercargo", GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray));
parms.Add("@FDispatchNum", lblKeyId.Text); //调度单号
SqlService.ExecuteProcedureCommand("proc_DispatchCenter", parms);
}
return(DispatchCenterService.SaveChanges() >= 0);
}
return(false);
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var stock = StockInService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (stock != null)
{
ModifiedGrid();
var prod =
StockInDetailsService.FirstOrDefault(
p => p.KeyId == txtKeyId.Text && p.FCompanyId == CurrentUser.AccountComId);
if (prod == null)
{
//生产产品入库
var product = new LHStockInDetails
{
KeyId = txtKeyId.Text,
FItemCode = txtFCode.Text,
FPrice = 0,
FAmount = 0,
FQty = Convert.ToDecimal(txtFQty.Text),
FBottle = tbxFBottle.SelectedValue,
FBottleQty = Convert.ToInt16(txtFBottleQty.Text),
FBottleOweQty = 0,
FCompanyId = CurrentUser.AccountComId,
FCateId = 2000,
FMemo = "生产入库",
FCostPrice = Convert.ToDecimal(txtFCostPrice.Text),
FBalance = Convert.ToDecimal(txtFBalance.Text),
};
StockInDetailsService.Add(product);
}
else
{
prod.FItemCode = txtFCode.Text;
prod.FQty = Convert.ToDecimal(txtFQty.Text);
prod.FBottle = tbxFBottle.SelectedValue;
prod.FBottleQty = Convert.ToInt32(txtFBottleQty.Text);
prod.FCostPrice = Convert.ToDecimal(txtFCostPrice.Text);
prod.FBalance = Convert.ToDecimal(txtFBalance.Text);
StockInDetailsService.SaveChanges();
}
//-------------------------------------------------------------------
stock.FCompanyId = CurrentUser.AccountComId;
stock.FFlag = 1;
stock.FDeleteFlag = 0;
stock.FMemo = txtFMemo.Text.Trim();
var parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@keyID", stock.KeyId);
parms.Add("@companyId", CurrentUser.AccountComId);
var amt =
Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_PurchaseAmt", parms).Tables[0].Rows[0][0]);
stock.FAmount = amt;
stock.FSurveyor = !ddlFSurveyor.SelectedValue.Equals("-1") ? ddlFSurveyor.SelectedText : "";
stock.FProducer = !ddlFProducer.SelectedValue.Equals("-1") ? ddlFProducer.SelectedText : "";//GasHelper.GetDropDownListArrayString(ddlFProducer.SelectedItemArray);
stock.FBatchNumber = txtFBatchNumber.Text.Trim();
stock.FProductionWorkshop = ddlWorkShop.SelectedValue;
stock.FCate = "内部";
stock.FCode = CurrentUser.AccountComId.ToString(CultureInfo.InvariantCulture);
stock.FName = "";
stock.FDate = txtFDate.SelectedDate;
StockInService.SaveChanges();
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "PR", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "6");
orderParms.Add("@companyId", CurrentUser.AccountComId);
SqlService.ExecuteProcedureCommand("proc_num", orderParms);
txtKeyId.Text = newKeyId;
var orders = new Dictionary <string, object>();
orders.Clear();
orders.Add("@KeyId", newKeyId);
orders.Add("@companyId", CurrentUser.AccountComId);
SqlService.ExecuteProcedureCommand("proc_ProuctOrder", orders);
//新增日志
var billStatus = new LHBillStatus
{
KeyId = newKeyId,
FCompanyId = CurrentUser.AccountComId,
FActionName = "新增",
FDate = DateTime.Now,
FDeptId = CurrentUser.AccountOrgId,
FOperator = CurrentUser.AccountName,
FMemo = String.Format("单据号{0},{1}新增生产单据。", newKeyId, CurrentUser.AccountName)
};
GasHelper.AddBillStatus(billStatus);
}
return(true);
}
return(false);
}
/// <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>
/// 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 (!string.IsNullOrEmpty(txtFCode.Text))
{
}
if (GetRequestEventArgument().Contains("reloadGrid:"))
{
#region Grid1
//查找所选商品代码，查访产品集合
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 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 LHStockOutDetails();
decimal price = GasHelper.GeSupplierPrice("", //
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.FCompanyId = CurrentUser.AccountComId;
details.KeyId = txtKeyId.Text.Trim();
details.FCateId = Convert.ToInt32(table.Rows[i]["FId"].ToString());
details.FCostPrice = 0;
details.FBalance = 0;
//默认包装物
details.FBottle = table.Rows[i]["FBottle"].ToString();
StockOutDetailsService.AddEntity(details);
//日志
switch (Actions)
{
case WebAction.Add:
break;
case WebAction.Edit:
//记录一下当前新增人操作内容
var detailslog = new LHStockOutDetails_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)
};
StockOutDetailsLogService.Add(detailslog);
break;
}
}
StockOutDetailsService.SaveChanges();
//重新绑定值
BindDataGrid();
}
#endregion
}
#region 更新合计
if (Grid1.Rows.Count > 0)
{
if (GetRequestEventArgument() == "UPDATE_SUMMARY")
{
OutputSummaryData();
ModifiedGrid();
Grid1.CommitChanges();
}
}
#endregion
}
}
/// <summary>
/// 作废
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnBatchDelete_Click(object sender, EventArgs e)
{
IEnumerable <string> selectIds = GetSelectIds();
try
{
Log(string.Format(@"作废单据号:{0}成功。", selectIds));
using (var trans = new TransactionScope())
{
//
foreach (var ids in selectIds)
{
var status = new LHBillStatus();
status.FCompanyId = CurrentUser.AccountComId;
status.FDeptId = CurrentUser.AccountOrgId;
status.FDate = DateTime.Now;
status.FOperator = CurrentUser.AccountName;
status.FActionName = EnumDescription.GetFieldText(GasEnumBillStauts.Voided);
status.KeyId = ids;
status.FMemo = string.Format("单据号{0}被{1}作废处理。", ids, CurrentUser.AccountName);
GasHelper.AddBillStatus(status);
}
LeaseReturnService.Update(p => p.FCompanyId == CurrentUser.AccountComId &&
selectIds.Contains(p.KeyId), p => new LHLeaseReturn
{
FFlag = 0, //
FStatus = Convert.ToInt32(GasEnumBillStauts.Voided), //
FProgress = Convert.ToInt32(GasEnumBillStauts.Voided)
});
foreach (var ids in selectIds)
{
var parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@keyID", ids);
parms.Add("@companyId", CurrentUser.AccountComId);
var data = SqlService.ExecuteProcedureCommand("proc_LeaseKill", parms).Tables[0];
for (int i = 0; i < data.Rows.Count; i++)
{
int id = Convert.ToInt32(data.Rows[i]["FDetailsFId"]);
int qty = Convert.ToInt32(data.Rows[i]["FBottleQty"]);
var details = LeaseDetailsService.FirstOrDefault(p => p.FId == id);
details.FReturnQty = details.FReturnQty - qty;
LeaseDetailsService.SaveChanges();
}
}
trans.Complete();
}
Alert.Show("作废成功！", MessageBoxIcon.Information);
BindDataGrid();
}
catch (Exception)
{
Alert.Show("作废失败！", MessageBoxIcon.Warning);
}
}
