229 lines
11 KiB
C#
229 lines
11 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 : 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));
|
||
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);
|
||
int scdid = Convert.ToInt32(id.Value);
|
||
//加载印前信息表头
|
||
updateyqxx(scdid);
|
||
//加载印刷信息表头
|
||
updateysxx(scdid);
|
||
|
||
|
||
}
|
||
}
|
||
#region 获取真正数据值
|
||
private void initdata(string did)
|
||
{
|
||
int idz = Convert.ToInt32(did);
|
||
//scd = scdbll.GetModel(idz);
|
||
//bh.Text = scd.bh;
|
||
//gdh.Text = scd.gdh;
|
||
//ddbh.Text = ddbll.GetModel(scd.ddid).bh;
|
||
//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();
|
||
//ddbz.Text = scd.ddbz;
|
||
}
|
||
#endregion
|
||
#region 用来加载印前信息
|
||
private void updateyqxx(int scdid)
|
||
{
|
||
scd = scdbll.GetModel(scdid);
|
||
//修改页面时，首先吧项目明细的表头加载出来
|
||
string biao = "<table width='100%' id='ddxm' border='1' class='buledy' > <tr id='0' >"
|
||
+ "<td class='head3' width='70'>项目</td><td class='head3' width='100'>物料名称</td>"
|
||
+ "<td class='head3' width='50'>规格</td>"
|
||
+ "<td class='head3' width='50'>物料品牌</td><td class='head3' width='60'>库房</td>"
|
||
+ "<td class='head3' width='60'>大张数</td><td class='head3' width='60'>小张数</td>"
|
||
+ "<td class='head3' width='60'>套数</td><td class='head3' width='60'>裁纸尺寸</td>"
|
||
+ "<td class='head3' width='60'>印刷方式</td><td class='head3' width='60'>版数</td></tr>";
|
||
//查询数据视图，获取当前订单下的所有明细
|
||
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='head4'>" + r["xiangmu"].ToString() + "</td>"
|
||
+ " <td class='head4'>" + r["mingcheng"].ToString() + "</td>"
|
||
+ " <td class='head4'>" + r["guige"].ToString()
|
||
+ "</td><td class='head4'>" + r["pinpai"].ToString() + "</td><td class='head4'>" + r["kufang"].ToString() + "</td> "
|
||
+ " <td class='head4'>" + (Convert.ToDouble(r["dzs"]) <= 0 ? "" : Convert.ToDouble(r["dzs"]).ToString()) + "</td>"
|
||
+ " <td class='head4'>" + (Convert.ToDouble(r["xzs"]) <= 0 ? "" : Convert.ToDouble(r["xzs"]).ToString()) + "</td>"
|
||
+ "<td class='head4'>" + (Convert.ToDouble(r["taoshu"]) <= 0 ? "" : Convert.ToDouble(r["taoshu"]).ToString()) + "</td> "
|
||
+ " <td class='head4'>" + r["czcc"].ToString() + "</td>"
|
||
+ " <td class='head4'>" + r["ysfs"].ToString() + "</td>"
|
||
+ "<td class='head4'>" + (Convert.ToDouble(r["banshu"]) <= 0 ? "" : Convert.ToDouble(r["banshu"]).ToString()) + "</td></tr>";
|
||
|
||
}
|
||
}
|
||
//biao += "<tr><td class='head4'>产品说明</td><td class='head4' colspan='11' style='text-align: left'>";
|
||
//biao += scd.cpsm;
|
||
//biao += "</td></tr>";
|
||
//biao += "<tr><td class='head4'>客户提供</td><td colspan='11' class='head4' style='text-align: left'>";
|
||
//biao += scd.khtg;
|
||
//biao += "</td></tr>";
|
||
biao += "<tr><td class='head4'>晒版要求</td><td colspan='10' class='head4' style='text-align: left'>";
|
||
//biao += scd.pbyq;
|
||
biao += "</td></tr>";
|
||
biao += "<tr><td class='head4'>印刷工艺要求</td><td colspan='10' class='head4' style='text-align: left'>";
|
||
//biao += scd.ysyq;
|
||
biao += "</td></tr>";
|
||
biao += "<tr><td class='head4'>印后工艺要求</td><td colspan='10' class='head4' style='text-align: left'>";
|
||
//biao += scd.yhyq;
|
||
biao += "</td></tr>";
|
||
yqxx.InnerHtml = biao + "</table>";
|
||
}
|
||
#endregion
|
||
#region 用来加载印刷信息
|
||
private void updateysxx(int scdid)
|
||
{
|
||
//修改页面时，首先吧项目明细的表头加载出来
|
||
string biao = "<table width='100%' id='ddxm' border='1' class='buledy' > <tr id='0' >"
|
||
+ "<td class='head3' width='70'><font>项目</font></td>"
|
||
+ "<td class='head3' width='50'>正色</td><td class='head3' width='50'>反色</td>"
|
||
+ "<td class='head3' width='70px'>印刷方式</td><td class='head3' width='50' >拼数</td><td class='head3' width='50'>小张数</td><td class='head3' width='60'>印刷加放</td>"
|
||
+ "<td class='head3' width='60'>装订加放</td><td class='head3' width='60'>合计小张</td><td class='head3' width='60'>印刷机台</td>"
|
||
+ "<td class='head3' width='70'>备注</td></tr>";
|
||
|
||
//查询数据视图，获取当前订单下的所有明细
|
||
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='head4'>" + r["xiangmu"].ToString() + "</td>"
|
||
+ " <td class='head4'>" + r["zhengse"].ToString() + "</td>"
|
||
+ " <td class='head4'>" + r["fanse"].ToString() + "</td>"
|
||
+ " <td class='head4'>" + r["ysfs"].ToString() + "</td>"
|
||
+ "<td class='head4'>" + (Convert.ToDouble(r["pinshu"]) <= 0 ? "" : Convert.ToDouble(r["pinshu"]).ToString()) + "</td> "
|
||
+ " <td class='head4'>" + (Convert.ToDouble(r["xzs"]) <= 0 ? "" : Convert.ToDouble(r["xzs"]).ToString()) + "</td>"
|
||
+ "<td class='head4'>" + (Convert.ToDouble(r["ysjf"]) <= 0 ? "" : Convert.ToDouble(r["ysjf"]).ToString()) + "</td> "
|
||
+ " <td class='head4'>" + (Convert.ToDouble(r["zdjf"]) <= 0 ? "" : Convert.ToDouble(r["zdjf"]).ToString()) + "</td>"
|
||
+ "<td class='head4'>" + (Convert.ToDouble(r["hjxz"]) <= 0 ? "" : Convert.ToDouble(r["hjxz"]).ToString()) + "</td> "
|
||
+ " <td class='head4'>" + r["ysjt"].ToString() + "</td>"
|
||
+ " <td class='head4'>" + r["bz"].ToString() + "</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='head4'>工艺信息</td><td colspan='10' class='head4' style='text-align: left'>";
|
||
biao += gxcode;
|
||
biao += "</td></tr>";
|
||
}
|
||
ysxx.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
|
||
} |