protected void tbxFLogisticsNumber_OnTextChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(tbxFLogisticsNumber.Text.Trim()))
{
var passCard = PassCardService.Where(p => p.KeyId == tbxFLogisticsNumber.Text.Trim()).FirstOrDefault();
if (passCard != null)
{
//ddlDeliveryMethod.SelectedValue = "配送";//
txtFCode.Text = passCard.FCode;
tbxFCustomer.Text = passCard.FName;
txtFMemo.Text = passCard.FMemo;
txtFLinkman.Text = passCard.FLinkman;
txtFPhone.Text = passCard.FPhone;
txtFAddress.Text = passCard.FAddress;
var dis = new DispatchCenterService().Where(p => p.KeyId == passCard.FDispatchNum).FirstOrDefault();
if (dis != null)
{
if (!string.IsNullOrEmpty(dis.FDriver))
{
ddlFDriver.SelectedValueArray = dis.FDriver.Split(',');
}
//if (!string.IsNullOrEmpty(passCard.FShipper))
// ddlFShipper.SelectedValueArray = passCard.FShipper.Split(',');
if (!string.IsNullOrEmpty(dis.FSupercargo))
{
ddlFSupercargo.SelectedValueArray = dis.FSupercargo.Split(',');
}
//if (!string.IsNullOrEmpty(StockOut.FSalesman))
// ddlFSalesman.SelectedValueArray = passCard.FSalesman.Split(',');
ddlFVehicleNum.SelectedValue = dis.FVehicleNum;
}
var pamrs = new Dictionary <string, object>();
pamrs.Clear();
pamrs.Add("@FCode", passCard.FCode);
pamrs.Add("@SalesKeyId", txtKeyId.Text.Trim());
pamrs.Add("@FCompanyId", CurrentUser.AccountComId);
pamrs.Add("@KeyId", tbxFLogisticsNumber.Text.Trim());
SqlService.ExecuteProcedureCommand("proc_PassCardToPurchase", pamrs);
BindDataGrid();
}
}
}
/// <summary>
/// 运送列表
/// </summary>
/// <param name="context"></param>
/// <param name="model"></param>
public void mainList(HttpContext context, WeReturnModel model)
{
string fdate = context.Request["fdate"];
string person = context.Request["person"];
try
{
var starttime = DateTime.Parse(fdate + " 00:00:00");
IQueryable <LHDispatchCenter> dispatchCenters = new DispatchCenterService().Where(p => p.FDate == starttime && (p.FDriver.Contains(person) || p.FSupercargo.Contains(person)));
model.status = 0;
model.data = dispatchCenters.ToList();
model.msg = "登录成功";
}
catch (System.Exception ex)
{
model.status = 1;
model.errmsg = ex.Message;
model.msg = "登录失败";
}
}
/// <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);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
bool isSucceed = false;
try
{
switch (Actions)
{
case WebAction.Add:
isSucceed = SubmintAdd();
break;
case WebAction.Edit:
isSucceed = SubmintEdit();
break;
}
tmsModel t = new tmsModel();
try
{
IQueryable <LHDispatchCenter> center = DispatchCenterService.Where(p => p.KeyId == lblKeyId.Text);
if (center.Count() > 0)
{
t.dispatchCenterList = center.ToList();
}
IQueryable <LHStockOut> iP = new StockOutService().Where(p => p.FDispatchNum == lblKeyId.Text);
t.stockOutList = iP.ToList <LHStockOut>();
t.stockOutDetailsList = new List <LHStockOutDetails>();
foreach (LHStockOut item in iP)
{
IQueryable <LHStockOutDetails> li = new StockOutDetailsService().Where(p => p.KeyId == item.KeyId);
foreach (LHStockOutDetails outDetails in li)
{
t.stockOutDetailsList.Add(outDetails);
}
}
IQueryable <LHPassCard> lHPasses = PassCardService.Where(p => p.FDispatchNum == lblKeyId.Text);
if (lHPasses != null)
{
t.passCardList = lHPasses.ToList();
}
t.passCardDetailsList = new List <LHPassCardDetails>();
foreach (LHPassCard item in t.passCardList)
{
IQueryable <LHPassCardDetails> cardDetails = new PassCardDetailsService().Where(p => p.KeyId == item.KeyId);
foreach (LHPassCardDetails details in cardDetails)
{
t.passCardDetailsList.Add(details);
}
}
IQueryable <LHStockIn> skin = new StockInService().Where(p => p.FDispatchNum == lblKeyId.Text);
if (skin != null && skin.Count() > 0)
{
t.stockInList = skin.ToList();
t.stockInDetailsList = new List <LHStockInDetails>();
foreach (LHStockIn item in skin)
{
IQueryable <LHStockInDetails> inDetails = new StockInDetailsService().Where(p => p.KeyId == item.KeyId);
foreach (LHStockInDetails inDetail in inDetails)
{
t.stockInDetailsList.Add(inDetail);
}
}
}
new HttpRequest().httpRequest(t, "open/dbo/dboData");
}
catch (Exception)
{
}
}
catch (DbEntityValidationException ex)
{
string msg = string.Empty;
List <ICollection <DbValidationError> > errors = (from u in ex.EntityValidationErrors select u.ValidationErrors).ToList();
foreach (ICollection <DbValidationError> item in errors)
{
msg += item.FirstOrDefault().ErrorMessage;
}
isSucceed = false;
}
finally
{
if (isSucceed)
{
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
else
{
Alert.Show("提交失败！", MessageBoxIcon.Error);
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string backouts = context.Request["params"];
TmsReturnModel returnModel = new TmsReturnModel();
StockOutDetailsService service = new StockOutDetailsService();
DispatchCenterService centerService = new DispatchCenterService();
StockInDetailsService stockInDetails = new StockInDetailsService();
try
{
using (TransactionScope trans = new TransactionScope())
{
tmsModel outs = JsonConvert.DeserializeObject <tmsModel>(backouts);
if (outs.stockOutDetailsList != null)
{
foreach (LHStockOutDetails items in outs.stockOutDetailsList)
{
LHStockOutDetails details = service.Where(p => p.KeyId == items.KeyId && p.FId == items.FId).FirstOrDefault();
if (details != null)
{
details.FRecycleQty = items.FRecycleQty;
details.FReturnQty = items.FReturnQty;
details.FDevice = items.FDevice;
details.FDeviceValue = string.IsNullOrEmpty(items.FDeviceValue.ToString()) ? 0 : Convert.ToDecimal(items.FDeviceValue);
details.FInTemperature = string.IsNullOrEmpty(items.FInTemperature.ToString()) //
? 0 : Convert.ToDecimal(items.FInTemperature.ToString());
details.FInPressure = string.IsNullOrEmpty(items.FInPressure.ToString()) //
? 0 : Convert.ToDecimal(items.FInPressure.ToString());
details.FOutTemperature = string.IsNullOrEmpty(items.FOutTemperature.ToString()) //
? 0 : Convert.ToDecimal(items.FOutTemperature.ToString());
details.FOutPressure = string.IsNullOrEmpty(items.FOutPressure.ToString()) //
? 0 : Convert.ToDecimal(items.FOutPressure.ToString());
details.FPayTemperature = string.IsNullOrEmpty(items.FPayTemperature.ToString()) //
? 0 : Convert.ToDecimal(items.FPayTemperature.ToString());
details.FPayPressure = string.IsNullOrEmpty(items.FPayPressure.ToString()) //
? 0 : Convert.ToDecimal(items.FPayPressure.ToString());
details.FReceiveTemperature = string.IsNullOrEmpty(items.FReceiveTemperature.ToString()) //
? 0 : Convert.ToDecimal(items.FReceiveTemperature.ToString());
details.FReceivePressure = string.IsNullOrEmpty(items.FReceivePressure.ToString()) //
? 0 : Convert.ToDecimal(items.FReceivePressure.ToString());
//数量计算
LHStockOut StockOut = new StockOutService().Where(p => p.KeyId == items.KeyId).FirstOrDefault();
string FCode = StockOut.FCode;
//计算公式
LHTubePrice v1 = new TubePriceService().Where(p => p.FBill == "销售" &&//
p.FCode == FCode &&//
p.FItemCode == details.FItemCode).FirstOrDefault();
if (v1 != null)
{
//< font color = "red" >$W1：进厂温度、$W2：出厂温度、$W3: 交付温度、$W4: 接收温度、$V: 水容积 </ font >< br />
//< font color = "red" >$Y1：进厂压力、$Y2：出厂压力、$Y3: 交付压力、$Y4: 接收压力 </ font >< br />
string inW = Convert.ToDecimal(details.FInTemperature).ToString(CultureInfo.InvariantCulture);
string inY = Convert.ToDecimal(details.FInPressure).ToString(CultureInfo.InvariantCulture);
string outW = Convert.ToDecimal(details.FOutTemperature).ToString(CultureInfo.InvariantCulture);
string outY = Convert.ToDecimal(details.FOutPressure).ToString(CultureInfo.InvariantCulture);;
string payW = Convert.ToDecimal(details.FPayTemperature).ToString(CultureInfo.InvariantCulture);
string payY = Convert.ToDecimal(details.FPayPressure).ToString(CultureInfo.InvariantCulture);
string recW = Convert.ToDecimal(details.FReceiveTemperature).ToString(CultureInfo.InvariantCulture);
string recY = Convert.ToDecimal(details.FReceivePressure).ToString(CultureInfo.InvariantCulture);
//水溶积
string v = Convert.ToDecimal(details.FDeviceValue).ToString(CultureInfo.InvariantCulture);
//数量
string s1 = v1.FFormula.Replace("$W1", inW) //
.Replace("$W2", outW)
.Replace("$W3", payW) //
.Replace("$W4", recW) //
.Replace("$Y1", inY) //
.Replace("$Y2", outY) //
.Replace("$Y3", payY) //
.Replace("$Y4", recY) //
.Replace("$V", v);
//数量
details.FQty = Convert.ToDecimal(FormulaCalculator.Eval(s1));
//金额
details.FAmount = details.FQty * details.FPrice;
}
service.SaveChanges();
}
}
}
if (outs.dispatchCenterList != null)
{
foreach (LHDispatchCenter item in outs.dispatchCenterList)
{
LHDispatchCenter lH = centerService.Where(p => p.KeyId == item.KeyId & p.FAuditFlag == 0).FirstOrDefault();
if (lH != null)
{
lH.FDriver = item.FDriver;
lH.FSupercargo = item.FSupercargo;
lH.FMileage = item.FMileage;
}
centerService.SaveChanges();
}
}
trans.Complete();
}
returnModel.code = "200";
returnModel.msg = "成功";
}
catch (Exception ex)
{
returnModel.code = "500";
returnModel.msg = "失败";
returnModel.msg = ex.Message;
}
context.Response.Write(JsonConvert.SerializeObject(returnModel));
}
/// <summary>
/// 提交编辑
/// </summary>
private bool SubmintEdit()
{
if (DispatchCenter != null)
{
DispatchCenter.FBeginDate = dptBeginDate.SelectedDate;
DispatchCenter.FVehicleNum = ddlFVehicleNum.SelectedValue;
DispatchCenter.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray);
DispatchCenter.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray);
DispatchCenter.FMileage = string.IsNullOrEmpty(txtFMileage.Text)
? 0
: Convert.ToDecimal(txtFMileage.Text);
DispatchCenter.FFrom = ddlFrom.SelectedValue;
DispatchCenter.FTo = ddlTo.SelectedValue;
//记录数
DispatchCenter.TaskQty = txtTaskQty.Text == "" ? 0 : decimal.Parse(txtTaskQty.Text);
DispatchCenter.FDriverYQty = txtFDriverYQty.Text == "" ? 0 : decimal.Parse(txtFDriverYQty.Text);
DispatchCenter.FDriverQty = txtFDriverQty.Text == "" ? 0 : decimal.Parse(txtFDriverQty.Text);
DispatchCenter.FDriverJQty = txtFDriverJQty.Text == "" ? 0 : decimal.Parse(txtFDriverJQty.Text);
//司机
DispatchCenter.FDriverYAmount = DispatchCenter.FDriverYPrice * DispatchCenter.FDriverYQty;
DispatchCenter.FDriverAmount = DispatchCenter.FDriverPrice * DispatchCenter.FDriverQty;
DispatchCenter.FDriverJAmount = DispatchCenter.FDriverJPrice * DispatchCenter.FDriverJQty;
DispatchCenter.FDriverMileageAmt = txtFDriverMileageAmt.Text == "" ? 0 : decimal.Parse(txtFDriverMileageAmt.Text);
//押运
DispatchCenter.FSupercargoYAmount = DispatchCenter.FSupercargoYPrice * DispatchCenter.FDriverYQty;
DispatchCenter.FSupercargoAmount = DispatchCenter.FSupercargoPrice * DispatchCenter.FDriverQty;
DispatchCenter.FSupercargoJAmount = DispatchCenter.FSupercargoJPrice * DispatchCenter.FDriverJQty;
DispatchCenter.FSupercargoMileageAmt = txtFSupercargoMileageAmt.Text == "" ? 0 : decimal.Parse(txtFSupercargoMileageAmt.Text);
//变更单据上的司机、押韵员、车牌号
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);
}
