183 lines
9.0 KiB
C#
183 lines
9.0 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Linq;
|
||
using System.Web;
|
||
using System.Web.UI;
|
||
using System.Web.UI.WebControls;
|
||
using System.Data;
|
||
using Ajax;
|
||
|
||
public partial class Common_scd_dy_hx : System.Web.UI.Page
|
||
{
|
||
|
||
//创建一个共用的生产单bll层
|
||
Maticsoft.BLL.nr_z_scd scdbll = new Maticsoft.BLL.nr_z_scd();
|
||
//创建一个共用的生产单模板
|
||
Maticsoft.Model.nr_z_scd scd = new Maticsoft.Model.nr_z_scd();
|
||
//创建一个共用的订单bll层
|
||
Maticsoft.BLL.nr_z_dd ddbll = new Maticsoft.BLL.nr_z_dd();
|
||
|
||
//创建一个共用的客户bll层
|
||
Maticsoft.BLL.nr_z_kehu kehubll = new Maticsoft.BLL.nr_z_kehu();
|
||
//创建一个操作记录模板
|
||
Maticsoft.Model.nr_sys_rizhi rizhi = new Maticsoft.Model.nr_sys_rizhi();
|
||
//创建一个操作记录bll
|
||
Maticsoft.BLL.nr_sys_rizhi rizhibll = new Maticsoft.BLL.nr_sys_rizhi();
|
||
public string userinfo = "";
|
||
|
||
protected void Page_Load(object sender, EventArgs e)
|
||
{
|
||
Utility.RegisterTypeForAjax(typeof(Common_scd_dy_hx));
|
||
if (!IsPostBack)
|
||
{
|
||
DataTable dtuserinfo = DBHlper.Execute("select mingcheng,logourl from nr_sysuserinfo").Tables[0];
|
||
if (dtuserinfo.Rows.Count > 0)
|
||
{
|
||
userinfo = dtuserinfo.Rows[0]["mingcheng"].ToString();
|
||
img_logo.Src = "../UseFile/" + dtuserinfo.Rows[0]["logourl"].ToString();
|
||
}
|
||
else
|
||
{
|
||
img_logo.Visible = false;
|
||
}
|
||
if (Session["user"] == null)
|
||
{
|
||
Response.Redirect("../index.aspx");
|
||
}
|
||
Maticsoft.Model.nr_z_yhzh user = (Maticsoft.Model.nr_z_yhzh)(Session["user"]);
|
||
|
||
if (Request.QueryString["uid"] != null && Request.QueryString["uid"] != "")
|
||
{
|
||
id.Value = Request.QueryString["uid"].ToString();
|
||
}
|
||
else
|
||
{
|
||
Response.Redirect("../Common/error.aspx");
|
||
}
|
||
initdata(id.Value);
|
||
|
||
updatewlxx(Convert.ToInt32(id.Value));
|
||
////开始时拼接添加导航
|
||
//div_daohang.InnerHtml = "当前位置：<a href='../Main/xsgn.aspx'>销售管理</a>><a href='lgscdmodel_list.aspx'>订单主页</a>>订单详细";
|
||
}
|
||
}
|
||
|
||
|
||
#region 获取真正数据值
|
||
private void initdata(string did)
|
||
{
|
||
int idz = Convert.ToInt32(did);
|
||
scd = scdbll.GetModel(idz);
|
||
bh.Text = scd.bh;
|
||
//gdh.Text = scd.gdh;
|
||
|
||
//yplx.Text = DBHlper.getfirstcolmn("select mingcheng from nr_sys_bianma where id=" + scd.ypzl);
|
||
//khmc.Text = kehubll.GetList("bianhao='" + scd.kh_bh + "'").Tables[0].Rows[0]["mingcheng"].ToString();
|
||
//ywy.Text = scd.ywy;
|
||
//xdrq.Text = DateTime.Parse(scd.xdrq.ToString()).ToString("yyyy-MM-dd HH:mm");
|
||
//jhrq.Text = DateTime.Parse(scd.jhrq.ToString()).ToString("yyyy-MM-dd");
|
||
//cpmc.Text = scd.cpmc;
|
||
//cpcc.Text = scd.cpcc;
|
||
//dhsl.Text = scd.dhsl.ToString();
|
||
//dw.Text = DBHlper.getfirstcolmn("select mingcheng from nr_sys_bianma where id=" + scd.dw);
|
||
//cpsm.Text = scd.cpsm;
|
||
////khtg.Text = scd.khtg;
|
||
//shyq.Text = scd.shyq;
|
||
//wfyq.Text = scd.wfyq;
|
||
////smbz.Text = scd.smbz;
|
||
//zdr.Text = scd.zdr;
|
||
//shr.Text = scd.shr;
|
||
////scdzt.Text = scd.scdzt;
|
||
////kgsj.Text = scd.kgsj.ToString();
|
||
////wgsj.Text = scd.wgsj.ToString();
|
||
//pbyq.Text = scd.pbyq;
|
||
//ysyq.Text = scd.ysyq;
|
||
//yhgy.Text = scd.yhyq;
|
||
//ddbz.Text = scd.ddbz;
|
||
}
|
||
#endregion
|
||
|
||
|
||
#region 用来加载项目
|
||
private void updatewlxx(int scdid)
|
||
{
|
||
//修改页面时，首先吧项目明细的表头加载出来
|
||
string biao = "<table width='100%' id='ddxm' border='1' style='border:1px solid #000000;margin-top:-1px; ' > <tr id='0' >"
|
||
+ "<td class='head7' width='145'>项目</td> <td class='head7' width='100'>库房</td> "
|
||
+ "<td class='head7' width='100'>物料名称</td><td class='head7' width='130'>规格</td><td class='head7' width='40'>品牌</td> "
|
||
+ "<td class='head7' width='80'>裁纸开数</td><td class='head7' width='150'>裁纸尺寸</td>"
|
||
+ "<td class='head7' width='40' >拼数</td><td class='head7' width='40'>正色</td><td class='head7' width='40'>反色</td><td class='head7' width='40'>套数</td>"
|
||
+ "<td class='head7' width='80'>印刷</br>方式</td><td class='head7' width='40'>版数</td><td class='head7' width='100'>印张</br>正数</td><td class='head7' width='70'>印刷加放</td>"
|
||
+ " <td class='head7' width='100'>大张数</td><td class='head7' width='120'>印刷</br>机台</td> </tr>";
|
||
//<td class='head7' width='70'>装订</br>加放</td>
|
||
//查询数据视图，获取当前订单下的所有明细
|
||
string gxcode = "";
|
||
DataSet ds = DBHlper.Execute("select * from view_nr_z_scd_mx where scd_id='" + scdid + "' order by id ");
|
||
DataTable dtgx = new DataTable();
|
||
if (ds != null && ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
//如果当前订单下存在明细就加载成tr行
|
||
foreach (DataRow r in ds.Tables[0].Rows)
|
||
{
|
||
//为保证唯一性，获取id拼接，保证稳定性
|
||
string hcount = r["id"].ToString();
|
||
biao += "<tr id='" + hcount + "' name='" + hcount + "'>"
|
||
+ " <td class='head6' width='145' ><font>" + r["xiangmu"].ToString() + "</font></td> "
|
||
+ "<td class='head6' width='100' ><font>" + r["kufang"].ToString() + "</font> "
|
||
+ " </td><td class='head6' width='190' ><font>" + r["mingcheng"].ToString() + "</font></td>"
|
||
+ " <td class='head6' width='130'><font>" + r["guige"].ToString() + "</font> </td><td class='head6' width='40'><font>" + r["pinpai"].ToString() + "</font></td> "
|
||
+ " <td class='head6' width='80'><font>" + r["czks"].ToString() + "</font></td> "
|
||
+ " <td class='head6' width='150'><font>" + r["czcc"].ToString() + "</font></td><td class='head6' width='40'><font>" + (Convert.ToDouble(r["pinshu"]) <= 0 ? "" : Convert.ToDouble(r["pinshu"]).ToString()) + "</font></td> "
|
||
+ " <td class='head6' width='40'><font>" + r["zhengse"].ToString() + "</font> </td><td class='head6' width='40'><font>" + r["fanse"].ToString() + "</font> </td><td class='head6' width='40'><font>" + (Convert.ToDouble(r["taoshu"]) <= 0 ? "" : Convert.ToDouble(r["taoshu"]).ToString()) + "</font> </td> "
|
||
+ " <td class='head6' width='80'><font>" + r["ysfs"].ToString() + "</font></td><td class='head6' width='40'><font>" + (Convert.ToDouble(r["banshu"]) <= 0 ? "" : Convert.ToDouble(r["banshu"]).ToString()) + "</font> </td> "
|
||
+ " <td class='head6' width='100'><font>" + (Convert.ToDouble(r["xzs"]) <= 0 ? "" : Convert.ToDouble(r["xzs"]).ToString()) + "</font></td><td class='head6' width='50'><font>" + (Convert.ToDouble(r["ysjf"]) <= 0 ? "" : Convert.ToDouble(r["ysjf"]).ToString()) + "</font> </td> "
|
||
//+ " <td class='head6' width='50'><font>" + (Convert.ToDouble(r["zdjf"]) <= 0 ? "" : Convert.ToDouble(r["zdjf"]).ToString()) + "</font> </td> "
|
||
+ " <td class='head6' width='100'><font>" + (Convert.ToDouble(r["dzs"]) <= 0 ? "" : Convert.ToDouble(r["dzs"]).ToString()) + "</font> </td>"
|
||
+ "<td class='head6' width='100'><font>" + r["ysjt"].ToString() + "</font></td> </tr>";
|
||
dtgx = DBHlper.Execute("select id,gongxu from nr_z_scdgxdetail where scdid=" + id.Value + " and xmid=" + r["id"]).Tables[0];
|
||
if (dtgx.Rows.Count > 0)
|
||
{
|
||
gxcode += "<span style='font-weight: 600'>" + r["xiangmu"] + "</span>" + ":";
|
||
foreach (DataRow dr in dtgx.Rows)
|
||
{
|
||
gxcode += dr["gongxu"] + ",";
|
||
}
|
||
gxcode = gxcode.TrimEnd(',');
|
||
gxcode += "；  ";
|
||
}
|
||
}
|
||
}
|
||
if (gxcode != "")
|
||
{
|
||
biao += "<tr><td class='head6'>工艺信息</td><td colspan='16' class='head6' style='text-align: left'>";
|
||
biao += gxcode;
|
||
biao += "</td></tr>";
|
||
}
|
||
scxx.InnerHtml = biao + "</table>";
|
||
}
|
||
#endregion
|
||
#region 加载联数
|
||
[Ajax.AjaxMethod]
|
||
public string getls()
|
||
{
|
||
string ls = "";
|
||
DataTable dt = DBHlper.Execute("select ls from nr_z_ls where mokuan='生产单'").Tables[0];
|
||
if (dt.Rows.Count == 0)
|
||
{
|
||
DBHlper.excutecmd("insert into nr_z_ls(mokuan,ls) values('生产单','')");
|
||
}
|
||
else
|
||
{
|
||
ls = dt.Rows[0]["ls"].ToString();
|
||
}
|
||
return ls;
|
||
}
|
||
#endregion
|
||
#region 保存联数
|
||
[Ajax.AjaxMethod]
|
||
public void savels(string ls)
|
||
{
|
||
DBHlper.excutecmd("update nr_z_ls set ls='" + ls + "' where mokuan='生产单'");
|
||
}
|
||
#endregion
|
||
} |