protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string suigongdan = Request.QueryString["suigongdan"];//随工单号
string PrintCount = Request.QueryString["PrintCount"];//随工单打印数量
string orderNum = Request.QueryString["orderNum"];//订单编号
string proType = Request.QueryString["proType"];//产品型号
if (!string.IsNullOrEmpty(orderNum)&&!string.IsNullOrEmpty(proType))
{
string strWhere = string.Format(" and orderNum='{0}' and proType='{1}' ",orderNum,proType);
orderDetail = ProOrdersDetailBLL.GetModelByWhere(strWhere);
if (orderDetail != null)
{
lblpiHao.Text = orderDetail.PiHao;
try
{
if (orderDetail.PlanSendTime != null && Convert.ToDateTime(orderDetail.PlanSendTime).ToString("yyyy-MM-dd") != "0001-01-01")
{
lblplanSendTime.Text = Convert.ToDateTime(orderDetail.PlanSendTime).ToString("yyyy-MM-dd");
}
}
catch (Exception) { }
lblproductAddress.Text = orderDetail.ProductAddress;
lblproNum.Text = orderDetail.proNum.ToString();
lblproType.Text = orderDetail.proType;
//随工单号
lblSuiGongDan.Text = suigongdan;
//随工单打印数量
lblPrintCount.Text = PrintCount;
//加载订单基本信息
orderMod = ProOrdersBLL.GetModel(orderDetail.orderNum);
if (orderMod != null)
{
txtcustomManager.Text = orderMod.customManager;
txtcustomNum.Text = orderMod.customNum;
txtcustomOrderNum.Text = orderMod.customOrderNum;
txtcustomWLBH.Text = orderMod.customWLBH;
txtheTongNum.Text = orderMod.heTongNum;
txtorderNum.Text = orderMod.orderNum;
txtremark.Text = orderMod.remark;
var db = new Web.Model.OrderPrintEntities();
var intorderDetailId = orderDetail.orderDetailId;
var gt_order = db.proOrders.FirstOrDefault(r => r.orderId == orderMod.orderId);
if (!string.IsNullOrEmpty(gt_order.发货状态))
{
lbl发货状态.Text = gt_order.发货状态;
}
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "")
{
string orderNum = Request.QueryString["id"].ToString();
//加载订单基本信息
orderMod = ProOrdersBLL.GetModel(orderNum);
if (orderMod != null)
{
txtcustomManager.Text = orderMod.customManager;
txtcustomNum.Text = orderMod.customNum;
txtcustomOrderNum.Text = orderMod.customOrderNum;
txtcustomWLBH.Text = orderMod.customWLBH;
txtheTongNum.Text = orderMod.heTongNum;
txtorderNum.Text = orderMod.orderNum;
txtremark.Text = orderMod.remark;
txtYijiekuanMoney.Text = orderMod.YijiekuanMoney.ToString();
txtYikaipiaoMoney.Text = orderMod.YikaipiaoMoney.ToString();
}
//加载订单产品
string strWhere = " and orderNum='" + orderNum + "'";
DataSet ds = ProOrdersDetailBLL.GetList(strWhere);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
rptYongpin.DataSource = ds;
rptYongpin.DataBind();
txtTRLastIndex.Value = ds.Tables[0].Rows.Count.ToString();
}
else
{
txtTRLastIndex.Value = "0";
}
//查看客户是否客户提供合同范本，如客户提供，打印合同按钮隐藏
customer = CustomerManageBLL.GetcustomerByid(orderMod.customNum);
if (customer != null)
{
if (customer.IsFanben == 0)
{
IBtn_Print.Visible = false;
}
else
{
IBtn_Print.Visible = true;
}
}
//订单号、客户编号不允许修改
txtorderNum.Enabled = false;
txtcustomNum.Enabled = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "")
{
string orderNum = Request.QueryString["id"].ToString();
//加载订单基本信息
orderMod = ProOrdersBLL.GetModel(orderNum);
if (orderMod != null)
{
txtcustomManager.Text = orderMod.customManager;
txtcustomNum.Text = orderMod.customNum;
txtcustomOrderNum.Text = orderMod.customOrderNum;
txtcustomWLBH.Text = orderMod.customWLBH;
txtheTongNum.Text = orderMod.heTongNum;
txtorderNum.Text = orderMod.orderNum;
txtremark.Text = orderMod.remark;
txtYijiekuanMoney.Text = orderMod.YijiekuanMoney.ToString();
txtYikaipiaoMoney.Text = orderMod.YikaipiaoMoney.ToString();
txtFapiaoDanhao.Text = orderMod.FaPiaoDanhao;
txtChengduihao.Text = orderMod.ChengShuiHao;
txtRemark1.Text = orderMod.Remark1;
}
//加载订单产品
string strWhere = " and orderNum='" + orderNum + "'";
DataSet ds = ProOrdersDetailBLL.GetList(strWhere);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
rptYongpin.DataSource = ds;
rptYongpin.DataBind();
}
//除结款和开票外其他不允许修改
txtorderNum.Enabled = false;
txtcustomNum.Enabled = false;
txtcustomManager.Enabled = false;
txtcustomNum.Enabled = false;
txtcustomOrderNum.Enabled = false;
txtcustomWLBH.Enabled = false;
txtheTongNum.Enabled = false;
txtorderNum.Enabled = false;
txtremark.Enabled = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "")
{
orderDetailId = Request.QueryString["id"].ToString();
orderDetail = ProOrdersDetailBLL.GetModel(Convert.ToInt32(orderDetailId));
if (orderDetail != null)
{
txtpiHao.Text = orderDetail.PiHao;
if (Convert.ToDateTime(orderDetail.PlanSendTime).ToString("yyyy-MM-dd") != "0001-01-01")
{
txtplanSendTime.Text = Convert.ToDateTime(orderDetail.PlanSendTime).ToString("yyyy-MM-dd");
}
txtproductAddress.Text = orderDetail.ProductAddress;
lblproNum.Text = orderDetail.proNum.ToString();
txtproType.Text = orderDetail.proType;
//if (orderDetail.withWorkNo != "")
//{
// txtwithWorkNo.Text = orderDetail.withWorkNo;
//}
//else
//{
// txtwithWorkNo.Text = DateTime.Now.ToString("yyyyMMddhhmmss");
//}
//随工单号
string date = DateTime.Now.ToString("yyyyMM");
string str = "";
if (SGDRecordBLL.GetSuigondanMax(date) != null)
{
str = SGDRecordBLL.GetSuigondanMax(date).ToString();
}
if (str == "")
{
txtwithWorkNo.Text = DateTime.Now.ToString("yyyyMMdd") + "-1";
}
else
{
txtwithWorkNo.Text = DateTime.Now.ToString("yyyyMMdd") + "-" + (Convert.ToInt32(str.Split('-')[1]) + 1);
}
//加载订单基本信息
orderMod = ProOrdersBLL.GetModel(orderDetail.orderNum);
if (orderMod != null)
{
txtcustomManager.Text = orderMod.customManager;
txtcustomNum.Text = orderMod.customNum;
txtcustomOrderNum.Text = orderMod.customOrderNum;
txtcustomWLBH.Text = orderMod.customWLBH;
txtheTongNum.Text = orderMod.heTongNum;
txtorderNum.Text = orderMod.orderNum;
txtremark.Text = orderMod.remark;
}
}
}
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, EventArgs e)
{
bool real = true;
//修改订单基本信息
if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "")
{
string orderNum = Request.QueryString["id"].ToString();
//加载订单基本信息
orderMod = ProOrdersBLL.GetModel(orderNum);
orderMod.customManager = txtcustomManager.Text.Trim();
orderMod.customOrderNum = txtcustomOrderNum.Text.Trim();
orderMod.customWLBH = txtcustomWLBH.Text.Trim();
orderMod.heTongNum = txtheTongNum.Text.Trim();
orderMod.remark = txtremark.Text.Trim();
orderMod.UpdateTime = DateTime.Now;
if (txtYijiekuanMoney.Text.Trim() != "")
{
orderMod.YijiekuanMoney = Convert.ToDecimal(txtYijiekuanMoney.Text.Trim());
}
else
{
orderMod.YijiekuanMoney = 0;
}
if (txtYikaipiaoMoney.Text.Trim() != "")
{
orderMod.YikaipiaoMoney = Convert.ToDecimal(txtYikaipiaoMoney.Text.Trim());
}
else
{
orderMod.YikaipiaoMoney = 0;
}
ProOrdersBLL.Update(orderMod);
}
//修改订单详情
string[] xinghao = Request.Params.GetValues("proType");
string[] shuliang = Request.Params.GetValues("proNum");
string[] danjia = Request.Params.GetValues("ProPrice");
string xianyouyongpin = "";
//原有产品的增加和修改
for (int i = 0; i < rptYongpin.Items.Count; i++)
{
Label lblProType = this.rptYongpin.Items[i].FindControl("lblProType") as Label;
TextBox txtProNum = this.rptYongpin.Items[i].FindControl("txtProNum") as TextBox;
Label lblProPrice = this.rptYongpin.Items[i].FindControl("lblProPrice") as Label;
HiddenField hdborderDetailId = this.rptYongpin.Items[i].FindControl("hdborderDetailId") as HiddenField;
xianyouyongpin += lblProType.Text.Trim() + ",";
if (txtProNum != null && txtProNum.Text.Trim() != "" && int.Parse(txtProNum.Text.Trim()) != 0)
{
//修改产品数量
int Updcount = ProOrdersDetailBLL.Update(Convert.ToInt32(hdborderDetailId.Value), Convert.ToInt32(txtProNum.Text));
if (!(Updcount > 0))
{
real = false;
}
}
else
{
//删除产品型号
ProOrdersDetailBLL.Delete(Convert.ToInt32(hdborderDetailId.Value));
}
}
//新增产品
if (xinghao != null && xinghao.Length > 0)
{
for (int i = 0; i < xinghao.Length; i++)
{
if (shuliang[i].ToString().Trim() != "" && int.Parse(shuliang[i].ToString().Trim()) != 0)
{
string xinYongpin = xinghao[i].ToString().Trim();
int num = 0;
int osid = 0;
if (xianyouyongpin.Contains(xinYongpin)) //如果新增产品已经存在于原有的产品中，则数量合并
{
DataSet ds = ProOrdersDetailBLL.GetList(" and proType='" + xinghao[i].Trim() + "' and orderNum='" + txtorderNum.Text.Trim() + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
num = Convert.ToInt32(ds.Tables[0].Rows[0]["proNum"].ToString());
osid = Convert.ToInt32(ds.Tables[0].Rows[0]["orderDetailId"].ToString());
int newNUM = num + Convert.ToInt32(shuliang[i].Trim());
//修改产品数量
int Updcount = ProOrdersDetailBLL.Update(osid, newNUM);
if (!(Updcount > 0))
{
real = false;
}
}
else
{
orderDetail = new ProOrdersDetailMOD();
orderDetail.orderNum = txtorderNum.Text.Trim();
orderDetail.proNum = Convert.ToInt32(shuliang[i].Trim());
orderDetail.ProPrice = Convert.ToDecimal(danjia[i].Trim());
orderDetail.proType = xinghao[i].Trim();
int Addcounts = ProOrdersDetailBLL.Add(orderDetail);
if (!(Addcounts > 0))
{
real = false;
}
}
}
else //直接添加
{
orderDetail = new ProOrdersDetailMOD();
orderDetail.orderNum = txtorderNum.Text.Trim();
orderDetail.proNum = Convert.ToInt32(shuliang[i].Trim());
orderDetail.ProPrice = Convert.ToDecimal(danjia[i].Trim());
orderDetail.proType = xinghao[i].Trim();
int Addcounts = ProOrdersDetailBLL.Add(orderDetail);
if (!(Addcounts > 0))
{
real = false;
}
}
}
}
}
if (real)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "DetailsPageControl.CloseBox();alert('提交成功！');DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "alert('提交失败！')", true);
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, ImageClickEventArgs e)
{
int num = 0;
if (Int32.Parse(SqlHelper.GetSingle(string.Format("select count(1) from proOrders where orderNum='{0}'", txtcustomOrderNum.Text)).ToString()) > 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('" + "订单号已存在！');DetailsPageControl.CloseBox();DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');", true);
return;
}
if (Request.QueryString["id"] != "" && Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
// num = ProductParamBLL.Updatemod(mod);
}
else
{
orderMod = new ProOrdersMOD();
orderDetailMOD = new ProOrdersDetailMOD();
try
{
//订单基本信息
orderMod.customManager = txtcustomManager.Text.Trim();
orderMod.customNum = txtcustomNum.Text.Trim();
orderMod.customOrderNum = txtcustomOrderNum.Text.Trim();
orderMod.customWLBH = "";// txtcustomWLBH.Text.Trim();
orderMod.editTime = DateTime.Now;
orderMod.heTongNum = txtheTongNum.Text.Trim();
orderMod.orderNum = txtorderNum.Text.Trim();
orderMod.remark = txtremark.Text.Trim();
orderMod.ShuChuXianchang = "";// txtshuChuXianchang.Text.Trim();
orderMod.ShuRuXianchang = "";// txtshuRuXianchang.Text.Trim();
//添加订单详细
string[] xinghao = Request.Params.GetValues("proType");
string[] shuliang = Request.Params.GetValues("proNum");
string[] danjia = Request.Params.GetValues("ProPrice");
string[] wuliaobian = Request.Params.GetValues("wuliaobian");
string errmsg = "";
int errorCount = 0;
//判断是否有填写产品信息
if (xinghao.Length < 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "DDGL", "alert('您还没有填写产品信息！')", true);
}
else
{
int flag = ProOrdersBLL.Add(orderMod);
if (flag > 0)
{
bool flag2 = true;
for (int i = 0; i < xinghao.Length; i++)
{
orderDetailMOD.orderNum = txtorderNum.Text.Trim();
if (Convert.ToInt32(shuliang[i]) > 0)
{
ProductParamMOD paramMod = ProductParamBLL.GetmodByid(txtcustomNum.Text.Trim(), xinghao[i].Trim());
if (paramMod != null)
{
orderDetailMOD.proNum = Convert.ToInt32(shuliang[i].Trim());
orderDetailMOD.ProPrice = Convert.ToDecimal(danjia[i].Trim());
orderDetailMOD.proType = xinghao[i].Trim();
//orderDetailMOD.Wuliaobian = wuliaobian[i].Trim();
if (!(ProOrdersDetailBLL.Add(orderDetailMOD) > 0))
{
flag2 = false;
break;
}
}
else
{
errmsg += xinghao[i].Trim() + ",";
errorCount++;
}
}
else
{
}
}
if (flag2)
{
string isShow = "";
if (xinghao.Length - errorCount > 0)
{
DataSet ds = CustomerManageBLL.GetcustomerAll(" and customerNo='" + txtcustomNum.Text.Trim() + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
isShow = ds.Tables[0].Rows[0]["isFanben"].ToString();
}
if (isShow != "0")
{
//ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.CloseBox();alert('提交成功');DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');print();", true);
if (errmsg == "")
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');", true);
Response.Redirect("Contract.aspx?customerNo=" + txtcustomNum.Text.Trim() + "&orderNum=" + txtorderNum.Text.Trim());
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('" + errmsg + "没有维护产品参数提交失败，其余添加成功！');DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');print();", true);
// Response.Redirect("Contract.aspx?customerNo=" + txtcustomNum.Text.Trim() + "&orderNum=" + txtorderNum.Text.Trim());
}
}
else
{
if (errmsg == "")
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.CloseBox();alert('提交成功');DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('" + errmsg + "没有维护产品参数提交失败，其余添加成功！');DetailsPageControl.CloseBox();DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');", true);
}
}
}
else
{
ProOrdersDetailBLL.Delete(txtorderNum.Text.Trim());
ProOrdersBLL.Delete(txtorderNum.Text.Trim());
ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "alert('您没有要添加的型号，添加失败！')", true);
}
}
else
{
ProOrdersDetailBLL.Delete(txtorderNum.Text.Trim());
ProOrdersBLL.Delete(txtorderNum.Text.Trim());
ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "alert('添加失败！')", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "BGYPSQLB", "alert('添加失败！')", true);
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "alert('添加失败！')", true);
}
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, ImageClickEventArgs e)
{
int num = 0;
if (Request.QueryString["id"] != "" && Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
// num = ProductParamBLL.Updatemod(mod);
}
else
{
orderMod = new ProOrdersMOD();
orderDetailMOD = new ProOrdersDetailMOD();
try
{
//订单基本信息
orderMod.customManager = txtcustomManager.Text.Trim();
orderMod.customNum = txtcustomNum.Text.Trim();
orderMod.customOrderNum = txtcustomOrderNum.Text.Trim();
orderMod.customWLBH = txtcustomWLBH.Text.Trim();
orderMod.editTime = DateTime.Now;
orderMod.heTongNum = txtheTongNum.Text.Trim();
orderMod.orderNum = txtorderNum.Text.Trim();
orderMod.remark = txtremark.Text.Trim();
//添加订单详细
string[] xinghao = Request.Params.GetValues("proType");
string[] shuliang = Request.Params.GetValues("proNum");
string[] danjia = Request.Params.GetValues("ProPrice");
//判断是否有填写产品信息
if (xinghao.Length < 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "DDGL", "alert('您还没有填写产品信息！')", true);
}
else
{
int flag = ProOrdersBLL.Add(orderMod);
if (flag > 0)
{
bool flag2 = true;
for (int i = 0; i < xinghao.Length; i++)
{
orderDetailMOD.orderNum = txtorderNum.Text.Trim();
if (Convert.ToInt32(shuliang[i]) > 0)
{
orderDetailMOD.proNum = Convert.ToInt32(shuliang[i].Trim());
orderDetailMOD.ProPrice = Convert.ToDecimal(danjia[i].Trim());
orderDetailMOD.proType = xinghao[i].Trim();
if (!(ProOrdersDetailBLL.Add(orderDetailMOD) > 0))
{
flag2 = false;
break;
}
}
}
if (flag2)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.CloseBox();alert('提交成功');DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');", true);
}
else
{
ProOrdersDetailBLL.Delete(txtorderNum.Text.Trim());
ProOrdersBLL.Delete(txtorderNum.Text.Trim());
ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "alert('添加失败！')", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "BGYPSQLB", "alert('添加失败！')", true);
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "alert('添加失败！')", true);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "")
{
orderDetailId = Request.QueryString["id"].ToString();
orderDetail = ProOrdersDetailBLL.GetModel(Convert.ToInt32(orderDetailId));
if (orderDetail != null)
{
txtpiHao.Text = orderDetail.PiHao;
if (Convert.ToDateTime(orderDetail.PlanSendTime).ToString("yyyy-MM-dd") != "0001-01-01")
{
txtplanSendTime.Text = Convert.ToDateTime(orderDetail.PlanSendTime).ToString("yyyy-MM-dd");
}
txtproductAddress.Text = orderDetail.ProductAddress;
txtproNum.Text = orderDetail.proNum.ToString();
txtproType.Text = orderDetail.proType;
if (orderDetail.withWorkNo != "")
{
txtwithWorkNo.Text = orderDetail.withWorkNo;
}
else
{
txtwithWorkNo.Text = DateTime.Now.ToString("yyyyMMddhhmmss");
}
//加载订单基本信息
orderMod = ProOrdersBLL.GetModel(orderDetail.orderNum);
if (orderMod != null)
{
txtcustomManager.Text = orderMod.customManager;
txtcustomNum.Text = orderMod.customNum;
txtcustomOrderNum.Text = orderMod.customOrderNum;
txtcustomWLBH.Text = orderMod.customWLBH;
txtheTongNum.Text = orderMod.heTongNum;
txtorderNum.Text = orderMod.orderNum;
txtremark.Text = orderMod.remark;
}
}
}
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, EventArgs e)
{
try
{
int num = 0;
//修改订单基本信息
if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "")
{
string orderNum = Request.QueryString["id"].ToString();
//加载订单基本信息
orderMod = ProOrdersBLL.GetModel(orderNum);
orderMod.customManager = txtcustomManager.Text.Trim();
orderMod.customOrderNum = txtcustomOrderNum.Text.Trim();
orderMod.customWLBH = txtcustomWLBH.Text.Trim();
orderMod.heTongNum = txtheTongNum.Text.Trim();
orderMod.remark = txtremark.Text.Trim();
orderMod.UpdateTime = DateTime.Now;
orderMod.FaPiaoDanhao = txtFapiaoDanhao.Text.Trim();
orderMod.ChengShuiHao = txtChengduihao.Text.Trim();
orderMod.Remark1 = txtRemark1.Text.Trim();
if (txtYijiekuanMoney.Text.Trim() != "")
{
orderMod.YijiekuanMoney = Convert.ToDecimal(txtYijiekuanMoney.Text.Trim());
}
else
{
orderMod.YijiekuanMoney = 0;
}
if (txtYikaipiaoMoney.Text.Trim() != "")
{
orderMod.YikaipiaoMoney = Convert.ToDecimal(txtYikaipiaoMoney.Text.Trim());
}
else
{
orderMod.YikaipiaoMoney = 0;
}
num = ProOrdersBLL.Update(orderMod);
}
if (num > 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "DetailsPageControl.CloseBox();alert('提交成功！');DetailsPageControl.ReflushList('orderManage/OrderKaiPiaoManage.aspx');", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "alert('提交失败！')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "alert('提交失败，您输入的信息有误！')", true);
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, EventArgs e)
{
try
{
bool real = true;
//修改订单基本信息
if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "")
{
string orderNum = Request.QueryString["id"].ToString();
//加载订单基本信息
orderMod = ProOrdersBLL.GetModel(orderNum);
orderMod.customManager = txtcustomManager.Text.Trim();
orderMod.customOrderNum = txtcustomOrderNum.Text.Trim();
orderMod.customWLBH = "";// txtcustomWLBH.Text.Trim();
orderMod.heTongNum = txtheTongNum.Text.Trim();
orderMod.remark = txtremark.Text.Trim();
orderMod.UpdateTime = DateTime.Now;
orderMod.FaPiaoDanhao = "";
orderMod.ChengShuiHao = "";
orderMod.Remark1 = "";
orderMod.EditUser = UserInfo.UserId;
orderMod.IsTiXing = 0;
orderMod.ShuRuXianchang = "";// txtshuRuXianchang.Text.Trim();
orderMod.ShuChuXianchang = "";// txtshuChuXianchang.Text.Trim();
//if (txtYijiekuanMoney.Text.Trim() != "")
//{
// orderMod.YijiekuanMoney = Convert.ToDecimal(txtYijiekuanMoney.Text.Trim());
//}
//else
//{
// orderMod.YijiekuanMoney = 0;
//}
//if (txtYikaipiaoMoney.Text.Trim() != "")
//{
// orderMod.YikaipiaoMoney = Convert.ToDecimal(txtYikaipiaoMoney.Text.Trim());
//}
//else
//{
// orderMod.YikaipiaoMoney = 0;
//}
ProOrdersBLL.Update(orderMod);
}
//修改订单详情
string[] xinghao = Request.Params.GetValues("proType");
string[] shuliang = Request.Params.GetValues("proNum");
string[] danjia = Request.Params.GetValues("ProPrice");
string[] wuliaobian = Request.Params.GetValues("wuliaobian");
string xianyouyongpin = "";
string errmsg = "";
//原有产品的增加和修改
for (int i = 0; i < rptYongpin.Items.Count; i++)
{
Label lblProType = this.rptYongpin.Items[i].FindControl("lblProType") as Label;
TextBox txtProNum = this.rptYongpin.Items[i].FindControl("txtProNum") as TextBox;
Label lblProPrice = this.rptYongpin.Items[i].FindControl("lblProPrice") as Label;
Label lblWuliaobian = this.rptYongpin.Items[i].FindControl("lblWuliaobian") as Label;
HiddenField hdborderDetailId = this.rptYongpin.Items[i].FindControl("hdborderDetailId") as HiddenField;
xianyouyongpin += lblProType.Text.Trim() + ",";
if (txtProNum != null && txtProNum.Text.Trim() != "" && int.Parse(txtProNum.Text.Trim()) != 0)
{
//修改产品数量
int Updcount = ProOrdersDetailBLL.Update(Convert.ToInt32(hdborderDetailId.Value), Convert.ToInt32(txtProNum.Text));
if (!(Updcount > 0))
{
real = false;
}
}
else
{
//删除产品型号
ProOrdersDetailBLL.Delete(Convert.ToInt32(hdborderDetailId.Value));
}
}
//新增产品
if (xinghao != null && xinghao.Length > 0)
{
for (int i = 0; i < xinghao.Length; i++)
{
if (shuliang[i].ToString().Trim() != "" && int.Parse(shuliang[i].ToString().Trim()) != 0)
{
ProductParamMOD paramMod = ProductParamBLL.GetmodByid(txtcustomNum.Text.Trim(), xinghao[i].Trim());
if (paramMod != null)
{
string xinYongpin = xinghao[i].ToString().Trim();
int num = 0;
int osid = 0;
if (xianyouyongpin.Contains(xinYongpin)) //如果新增产品已经存在于原有的产品中，则数量合并
{
DataSet ds = ProOrdersDetailBLL.GetList(" and proType='" + xinghao[i].Trim() + "' and orderNum='" + txtorderNum.Text.Trim() + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
num = Convert.ToInt32(ds.Tables[0].Rows[0]["proNum"].ToString());
osid = Convert.ToInt32(ds.Tables[0].Rows[0]["orderDetailId"].ToString());
int newNUM = num + Convert.ToInt32(shuliang[i].Trim());
//修改产品数量
int Updcount = ProOrdersDetailBLL.Update(osid, newNUM);
if (!(Updcount > 0))
{
real = false;
}
}
else
{
orderDetail = new ProOrdersDetailMOD();
orderDetail.orderNum = txtorderNum.Text.Trim();
orderDetail.proNum = Convert.ToInt32(shuliang[i].Trim());
orderDetail.ProPrice = Convert.ToDecimal(danjia[i].Trim());
orderDetail.proType = xinghao[i].Trim();
int Addcounts = ProOrdersDetailBLL.Add(orderDetail);
if (!(Addcounts > 0))
{
real = false;
}
}
}
else //直接添加
{
orderDetail = new ProOrdersDetailMOD();
orderDetail.orderNum = txtorderNum.Text.Trim();
orderDetail.proNum = Convert.ToInt32(shuliang[i].Trim());
orderDetail.ProPrice = Convert.ToDecimal(danjia[i].Trim());
orderDetail.proType = xinghao[i].Trim();
//orderDetail.Wuliaobian = wuliaobian[i].Trim();
int Addcounts = ProOrdersDetailBLL.Add(orderDetail);
if (!(Addcounts > 0))
{
real = false;
}
}
}
else
{
errmsg += xinghao[i] + ",";
}
}
}
}
if (real)
{
if (errmsg == "")
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');", true);
// ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');print();DetailsPageControl.CloseBox();", true);
Response.Redirect("Contract.aspx?customerNo=" + txtcustomNum.Text.Trim() + "&orderNum=" + txtorderNum.Text.Trim());
}
else
{
// ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert(" + errmsg + "'没有维护单价提交失败，其余提交成功');", true);
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('" + errmsg + "没有维护产品参数提交失败，其余提交成功');DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');", true);
Response.Redirect("Contract.aspx?customerNo=" + txtcustomNum.Text.Trim() + "&orderNum=" + txtorderNum.Text.Trim());
}
// ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "DetailsPageControl.CloseBox();alert('提交成功！');DetailsPageControl.ReflushList('orderManage/OrderManage.aspx');", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "alert('提交失败！')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "BGYPSQLB", "alert('提交失败，您输入的信息有误！')", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "")
{
string orderNum = Request.QueryString["id"].ToString();
int id;
if (Int32.TryParse(Request.QueryString["id"], out id))
{
var db=new Web.Model.OrderPrintEntities();
orderNum = db.proOrders.Where(r => r.orderId == id).FirstOrDefault().orderNum;
}
//加载订单基本信息
orderMod = ProOrdersBLL.GetModel(orderNum);
if (orderMod != null)
{
txtcustomManager.Text = orderMod.customManager;
txtcustomNum.Text = orderMod.customNum;
txtcustomOrderNum.Text = orderMod.customOrderNum;
// txtcustomWLBH.Text = orderMod.customWLBH;
txtheTongNum.Text = orderMod.heTongNum;
txtorderNum.Text = orderMod.orderNum;
txtremark.Text = orderMod.remark;
//txtshuChuXianchang.Text = orderMod.ShuChuXianchang;
//txtshuRuXianchang.Text = orderMod.ShuRuXianchang;
//txtYijiekuanMoney.Text = orderMod.YijiekuanMoney.ToString();
//txtYikaipiaoMoney.Text = orderMod.YikaipiaoMoney.ToString();
var db = new Web.Model.OrderPrintEntities();
var intorderDetailId = id;
var gt_order = db.proOrders.FirstOrDefault(r => r.orderId == orderMod.orderId);
if (!string.IsNullOrEmpty(gt_order.发货状态))
{
rbl发货状态.SelectedValue = gt_order.发货状态;
}
}
//加载订单产品
string strWhere = " and orderNum='" + orderNum + "'";
DataSet ds = ProOrdersDetailBLL.GetList(strWhere);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
rptYongpin.DataSource = ds;
rptYongpin.DataBind();
txtTRLastIndex.Value = ds.Tables[0].Rows.Count.ToString();
}
else
{
txtTRLastIndex.Value = "0";
}
//查看客户是否客户提供合同范本，如客户提供，打印合同按钮隐藏
customer = CustomerManageBLL.GetcustomerByid(orderMod.customNum);
if (customer != null)
{
if (customer.IsFanben == 0)
{
tishi.InnerText = "本客户自己提供合同模板，请使用签订客户合同";
IBtn_Print.Visible = false;
}
else
{
IBtn_Print.Visible = true;
}
}
else
{
IBtn_Print.Visible = true;
}
//订单号、客户编号不允许修改
txtorderNum.Enabled = false;
txtcustomNum.Enabled = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//计划发货时间
if (Request.QueryString["planTime"] != null && Request.QueryString["planTime"].ToString() != "")
{
lblPlanTime.Text = Request.QueryString["planTime"].ToString();
}
//订单号
if (Request.QueryString["orderNum"] != null && Request.QueryString["orderNum"].ToString() != "")
{
orderNum = Request.QueryString["orderNum"].ToString();
lblOrderNUM.Text = orderNum;
//客户特殊要求
ordermod = ProOrdersBLL.GetModel(orderNum);
if (ordermod != null)
{
lblTeshuYaoqiu.Text = ordermod.remark;
}
}
//产品型号
if (Request.QueryString["proType"] != null && Request.QueryString["proType"].ToString() != "")
{
proType = Request.QueryString["proType"].ToString();
lblproType.Text = proType;
if (Request.QueryString["customNum"] != null && Request.QueryString["customNum"].ToString() != "")
{
//客户参数要求
string customNum = Request.QueryString["customNum"].ToString();
ProductParamMOD MOD = ProductParamBLL.GetmodByid(customNum, proType);
if (MOD != null)
{
lblCanshuYaoqiu.Text = MOD.ParamContent;
}
}
//绑定产品基本信息
ProductsMOD mod = ProductsBLL.GetModel(proType);
if (mod != null)
{
txtbaoHeDian.Text = mod.baoHeDian;
txtbianbi.Text = mod.bian;
txtbiaoShiAddress.Text = mod.biaoShiAddress;
txtbiaoShiNo.Text = mod.biaoShiNo;
// imgbiaoShiPicture.ImageUrl = mod.biaoShiPicture;
imgWaiXingTZ.ImageUrl = mod.waiXingTZ;
txtcaiLiao.Text = mod.caiLiao;
txtchajianNo.Text = mod.chajianNo;
txtchujRaoXianZD.Text = mod.chujRaoXianZD;
txtchujTongMD.Text = mod.chujTongMD;
txtchujXianJing.Text = mod.chujXianJing;
txtchujXianTouCD.Text = mod.chujXianTouCD;
txtchujXiantouCL.Text = mod.chujXiantouCL;
txtchujZaShu.Text = mod.chujZaShu;
txtchuLiMethod.Text = mod.chuLiMethod;
txtcijRaoXianZD.Text = mod.cijRaoXianZD;
txtcijTongMD.Text = mod.cijTongMD;
txtcijXianJing.Text = mod.cijXianJing;
txtcijXianTouCD.Text = mod.cijXianTouCD;
txtcijXianTouCL.Text = mod.cijXianTouCL;
txtcijZaShu.Text = mod.cijZaShu;
txtcpjccsEquip.Text = mod.cpjccsEquip;
txtcpjccsFuZai.Text = mod.cpjccsFuZai;
txtCpjccsJiaoChaBH.Text = mod.CpjccsJiaoChaBH;
txtcpjccsNaiYa.Text = mod.cpjccsNaiYa;
txtcpjccsShuChuState.Text = mod.cpjccsShuChuState;
txtcpjccsShuRuState.Text = mod.cpjccsShuRuState;
txtcpjccsTongMD.Text = mod.cpjccsTongMD;
txteDingJC.Text = mod.eDingJC;
txtguanJiaoZhenLX.Text = mod.guanJiaoZhenLX;
txtguanJiaoZhenLXTOW.Text = mod.guanJiaoZhenLXTOW;
txtguiGe.Text = mod.guiGe;
txtjingDu.Text = mod.jingDu;
txtpeiXianSC.Text = mod.peiXianSC;
txtpeiXianSR.Text = mod.peiXianSR;
txtremark.Text = mod.remark;
txtshuChu.Text = mod.shuChu;
txtshuRu.Text = mod.shuRu;
txtwaiKeNo.Text = mod.waiKeNo;
txtxianXingdu.Text = mod.xianXingdu;
txtxingNeng.Text = mod.xingNeng;
txtxqjcyqEquip.Text = mod.xqjcyqEquip;
txtxqjcyqFuZai.Text = mod.xqjcyqFuZai;
txtxqjcyqJiaoCha.Text = mod.xqjcyqJiaoCha;
txtxqjcyqShuChuState.Text = mod.xqjcyqShuChuState;
txtxqjcyqShuRuState.Text = mod.xqjcyqShuRuState;
txtyongJiaoCS.Text = mod.yongJiaoCS;
//如果在“客户特殊要求”填写的内容里边检索到“输入线长”，“输出线长”，需要将输入线长，输出线长单元格原有的内容清除
if (ordermod != null)
{
if (ordermod.remark.Contains("输入线长"))
{
txtshuRuXC.Text = "";
}
else
{
txtshuRuXC.Text = mod.shuRuXC;
}
if (ordermod.remark.Contains("输出线长"))
{
txtshuChuXC.Text = "";
}
else
{
txtshuChuXC.Text = mod.shuChuXC;
}
}
else
{
txtshuRuXC.Text = mod.shuRuXC;
txtshuChuXC.Text = mod.shuChuXC;
}
//数量不打印
//txttieXiCount.Text = mod.tieXiCount.ToString();
//txtxianQuanCount.Text = mod.xianQuanCount.ToString();
//txtwaiKeCount.Text = mod.waiKeCount.ToString();
//txtchajianCount.Text = mod.chajianCount.ToString();
//txtpeiXianSCCount.Text = mod.peiXianSCCount.ToString();
//txtpeiXianSRCount.Text = mod.peiXianSRCount.ToString();
//txtguanJiaoZhenLXTOWCount.Text = mod.guanJiaoZhenLXTOWCount.ToString();
//txtguanJIaoZhenLXCount.Text = mod.guanJIaoZhenLXCount.ToString();
}
}
//产品数量
if (Request.QueryString["proNum"] != null && Request.QueryString["proNum"].ToString() != "")
{
string proNum = Request.QueryString["proNum"].ToString();
lblProNUM.Text = proNum;
}
//批号
if (Request.QueryString["pihao"] != null && Request.QueryString["pihao"].ToString() != "")
{
string pihao = Request.QueryString["pihao"].ToString();
lblPihao.Text = pihao;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//这里是判断是否已经登陆 （先加一个测试一下）
var authCookie = Request.Cookies[ FormsAuthentication.FormsCookieName];
if (authCookie == null)
{ //Cookie中不存在，表示没有登陆，需要跳转到登陆页面
Response.Redirect("/Login.aspx");
return;
}
if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "")
{
orderDetailId = Request.QueryString["id"].ToString();
orderDetail = ProOrdersDetailBLL.GetModel(Convert.ToInt32(orderDetailId));
if (Request.QueryString["opr"] == "print")
{
//
// 点击了“打印”
//
//
txtproNum.Text = Request.QueryString["txtproNum"];
orderDetail.PiHao = Request.QueryString["txtpiHao"];
try
{
orderDetail.PlanSendTime = Convert.ToDateTime(Request.QueryString["txtplanSendTime"].Trim());
}
catch (Exception) { }
orderDetail.ProductAddress = Request.QueryString["txtproductAddress"];
}
if (orderDetail != null)
{
txtpiHao.Text = orderDetail.PiHao;
try
{
if (orderDetail.PlanSendTime != null && Convert.ToDateTime(orderDetail.PlanSendTime).ToString("yyyy-MM-dd") != "0001-01-01")
{
txtplanSendTime.Text = Convert.ToDateTime(orderDetail.PlanSendTime).ToString("yyyy-MM-dd");
}
}
catch (Exception) { }
txtproductAddress.Text = orderDetail.ProductAddress;
lblproNum.Text = orderDetail.proNum.ToString();
txtproType.Text = orderDetail.proType;
#region 生成随工单号
//随工单号
string date = DateTime.Now.ToString("yyyyMM");
string str = "";
if (SGDRecordBLL.GetSuigondanMax(date) != null)
{
str = SGDRecordBLL.GetSuigondanMax(date).ToString();
}
if (str == "")
{
txtwithWorkNo.Text = DateTime.Now.ToString("yyyyMMdd") + "-1-" + DateTime.Now.ToString("ffff");
}
else
{
try
{
txtwithWorkNo.Text = DateTime.Now.ToString("yyyyMMdd") + "-" + (Convert.ToInt32(str.Split('-')[1]) + 1) + "-" + DateTime.Now.ToString("ffff");
}
catch (Exception ex)
{
throw new Exception("错误的字串：" + str);
}
}
#endregion
//加载订单内容信息
orderMod = ProOrdersBLL.GetModel(orderDetail.orderNum);
if (orderMod != null)
{
txtcustomManager.Text = orderMod.customManager;
txtcustomNum.Text = orderMod.customNum;
txtcustomOrderNum.Text = orderMod.customOrderNum;
txtcustomWLBH.Text = orderMod.customWLBH;
txtheTongNum.Text = orderMod.heTongNum;
txtorderNum.Text = orderMod.orderNum;
txtremark.Text = orderMod.remark;
var db = new Web.Model.OrderPrintEntities();
var intorderDetailId = Int32.Parse(orderDetailId);
var gt_order = db.proOrders.FirstOrDefault(r => r.orderId == orderMod.orderId);
if (!string.IsNullOrEmpty(gt_order.发货状态))//发货状态显示判断
{
lbl发货状态.Text = gt_order.发货状态;
}
}
}
}
}
}