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);
}
