private void GetList() { DataTable dt = tmo_order.GetConOrderList(txtcustname.Text, txtconno.Text, txtyewuyuan.Text, txtstlgrd.Text, "", "", "", "", dropArea.SelectedItem.Value, dropstatus.SelectedItem.Text == "全部" ? "" : dropstatus.SelectedItem.Value, Convert.ToInt32(droptype.SelectedItem.Value), txtspec.Text, txtmatcode.Text).Tables[0]; dtExport = dt; PagedDataSource ps = new PagedDataSource(); ps.DataSource = dt.DefaultView; Pager1.RecordCount = ps.Count; if (Pager1.RecordCount > 0) { ps.AllowPaging = true; ps.PageSize = Pager1.PageSize; ps.CurrentPageIndex = Pager1.CurrentPageIndex - 1; rptList.DataSource = ps; rptList.DataBind(); ltlwgt.Text = dt.Compute("sum(N_WGT)", "true").ToString(); ltlylxwgt.Text = dt.Compute("sum(YLXWGT)", "true").ToString(); ltldlxwgt.Text = dt.Compute("sum(DLXWGT)", "true").ToString(); ltlpcwgt.Text = dt.Compute("sum(XFWGT)", "true").ToString(); } else { rptList.DataSource = null; rptList.DataBind(); ltlwgt.Text = ""; ltlylxwgt.Text = ""; ltldlxwgt.Text = ""; ltlpcwgt.Text = ""; } }
private void GetList() { DataTable dt = tmo_order.GetConOrderList(txtcustname.Text, txtconno.Text, txtyewuyuan.Text, txtstlgrd.Text, Start.Value, End.Value, "", dropexestatus.SelectedItem.Text == "全部" ? "" : dropexestatus.SelectedValue, dropArea.SelectedItem.Value, dropstatus.SelectedItem.Text == "全部" ? "" : dropstatus.SelectedItem.Value, Convert.ToInt32(droptype.SelectedItem.Value), txtspec.Text).Tables[0]; if (dt.Rows.Count > 0) { dtExport = dt; rptList.DataSource = dt; rptList.DataBind(); ltlwgt.Text = dt.Compute("sum(N_WGT)", "true").ToString(); ltlylxwgt.Text = dt.Compute("sum(YLXWGT)", "true").ToString(); ltldlxwgt.Text = dt.Compute("sum(DLXWGT)", "true").ToString(); //ltlprice.Text = dt.Compute("sum(N_ORIGINALCURSUMMNY)", "true").ToString(); } else { rptList.DataSource = null; rptList.DataBind(); ltlwgt.Text = ""; //ltlprice.Text = ""; ltlylxwgt.Text = ""; ltldlxwgt.Text = ""; } }
/// <summary> /// 加载合同订单列表 /// </summary> private void GetOrderList() { if (!string.IsNullOrEmpty(txtConNO.Text)) { dtOrder = tmo_order.GetConOrderList(txtConNO.Text, "", "", "", "", "").Tables[0]; if (dtOrder.Rows.Count > 0) { rptList.DataSource = dtOrder; rptList.DataBind(); ltlWGT_SUM.Text = dtOrder.Compute("sum(N_WGT)", "true").ToString(); ltlN_ORIGINALCURSUMMNY.Text = dtOrder.Compute("sum(N_ORIGINALCURSUMMNY)", "true").ToString(); } else { ltlWGT_SUM.Text = string.Empty; ltlN_ORIGINALCURSUMMNY.Text = string.Empty; rptList.DataSource = null; rptList.DataBind(); } } }
/// <summary> /// 订单列表 /// </summary> private void GetOrder() { DataTable dt = tmo_order.GetConOrderList(txtConNo.Text, "", txtstlgrd.Text, Start.Value, End.Value, ltlcustno.Text).Tables[0]; if (dt.Rows.Count > 0) { rptList.DataSource = dt; rptList.DataBind(); } else { rptList.DataSource = null; rptList.DataBind(); } }
/// <summary> /// 加载合同订单列表 /// </summary> private void GetOrderList() { if (!string.IsNullOrEmpty(hidconno.Value)) { DataTable dt = tmo_order.GetConOrderList(hidconno.Value, "", "", "", "", "").Tables[0]; if (dt.Rows.Count > 0) { rptList.DataSource = dt; rptList.DataBind(); txtWGT_SUM.Value = dt.Compute("sum(N_WGT)", "true").ToString(); txtN_ORIGINALCURMNY.Value = dt.Compute("sum(N_ORIGINALCURMNY)", "true").ToString(); txtN_ORIGINALCURSUMMNY.Value = dt.Compute("sum(N_ORIGINALCURSUMMNY)", "true").ToString(); txtN_ORIGINALCURTAXMNY.Value = dt.Compute("sum(N_ORIGINALCURTAXMNY)", "true").ToString(); } else { rptList.DataSource = null; rptList.DataBind(); } } }
private void GetOrderList() { if (!string.IsNullOrEmpty(ltlConNo.Text)) { DataTable dt = tmo_order.GetConOrderList(ltlConNo.Text, "", "", "", "", "").Tables[0]; if (dt.Rows.Count > 0) { rptList.DataSource = dt; rptList.DataBind(); ltlWGT_SUM.Text = dt.Compute("sum(N_WGT)", "true").ToString(); ltlN_ORIGINALCURMNY.Text = dt.Compute("sum(N_ORIGINALCURMNY)", "true").ToString(); ltlN_ORIGINALCURSUMMNY.Text = dt.Compute("sum(N_ORIGINALCURSUMMNY)", "true").ToString(); ltlN_ORIGINALCURTAXMNY.Text = dt.Compute("sum(N_ORIGINALCURTAXMNY)", "true").ToString(); } else { rptList.DataSource = null; rptList.DataBind(); } } }
public AjaxResult GetConLX([FromBody] dynamic Json) { #region //参数 string conNo = Json.conNO; //合同号 string stlGrd = Json.stlGrd; //钢种 int orderType = Json.orderType; //6钢坯/8线材 string spec = Json.spec; //规格 #endregion #region //数据操作 var cust = BaseUser.CustFile; AjaxResult result = new AjaxResult(); result.Code = DoResult.Success; DataTable dt = tmo_order.GetConOrderList(cust.C_NAME, conNo, "", stlGrd, "", "", "", "", "", "2", orderType, spec).Tables[0]; result.Code = DoResult.Success; result.Result = JsonConvert.SerializeObject(dt); #endregion return(result); }
public AjaxResult ConChange([FromBody] dynamic Json) { #region //参数 string conNO = Json.conNO; //合同号 #endregion #region //数据操作 AjaxResult result = new AjaxResult(); try { if (!string.IsNullOrEmpty(conNO)) { #region //新增变更合同 List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>(); #region //添加合同基本信息 Mod_TMO_CON modCon = tmo_con.GetModel(conNO); int NO = Convert.ToInt32(modCon.N_CHANGENUM.ToString()) + 1; modCon.C_CON_NO = modCon.C_CON_NO + "-" + NO.ToString(); modCon.C_CON_NAME = modCon.C_CON_NAME; modCon.N_STATUS = -1; //客户待提交 modCon.D_CONSING_DT = DateTime.Now; //合同签署日期 modCon.D_CONEFFE_DT = Convert.ToDateTime(DateTime.Now); //计划生效日期 modCon.D_CONINVALID_DT = Convert.ToDateTime(DateTime.Now).AddDays(60); //计划失效日期 modCon.C_CON_NO_OLD = conNO; //原始合同号 modCon.N_CHANGENUM = NO; //变更次数 #endregion #region //添加合同明细 Bll_RandomNumber randomnumber = new Bll_RandomNumber(); //流水号 DataTable dtOrder = tmo_order.GetConOrderList(conNO, "", "", "", "", "").Tables[0]; for (int i = 0; i < dtOrder.Rows.Count; i++) { Mod_TMO_ORDER modOrder = tmo_order.GetModel(dtOrder.Rows[i]["C_ID"].ToString()); //订单表 string order_no = randomnumber.CreateOrderNo(modCon.C_CON_NO); //订单号 modOrder.C_ORDER_NO = order_no; modOrder.C_CON_NO = modCon.C_CON_NO; //合同号 modOrder.C_CON_NAME = modCon.C_CON_NAME; //合同名称 modOrder.N_STATUS = -1; //客户待提交 modOrder.C_SFPJ = "N"; //是否评价 modOrder.N_EXEC_STATUS = -2; //未提报 modOrder.N_WGT = modOrder.N_WGT; //原合同数量 modOrder.C_ORDER_NO_OLD = dtOrder.Rows[i]["C_ORDER_NO"].ToString(); //原合同号 orderList.Add(modOrder); } #endregion #endregion if (tmo_con.InsertConOrder(modCon, orderList)) { result.Code = DoResult.Success; result.Result = "变更成功"; } } else { result.Code = DoResult.Success; result.Result = "合同为空,无法操作"; } } catch (Exception ex) { result.Code = DoResult.Success; result.Result = ex.Message; } #endregion return(result); }