xinyilu/tijian_tieying
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
main
tijian_tieying/web/Web/DocFile/JiXiaoModify.aspx.cs

181 lines
9.2 KiB
C#
Raw Permalink Normal View History

v1
2025-02-20 12:14:39 +08:00
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class DocFile_JiXiaoModify : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPJiXiao Model = new ZWL.BLL.ERPJiXiao();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.txtJXName.Text=Model.JXName.ToString();
this.txtJianJie.Text=Model.JianJie.ToString();
this.txtUserName.Text=Model.UserName.ToString();
this.txtTimeStr.Text=Model.TimeStr.ToString();
DataBindToGridview();
}
}
public void DataBindToGridview()
{
//<2F><>ȡ<EFBFBD><C8A1>̬<EFBFBD><CCAC><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
DataSet CanShuDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select ItemName,ID from ERPJiXiaoCanShu order by BackInfo");
//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݵ<EFBFBD><DDB5>б<EFBFBD><D0B1><EFBFBD>
DataSet UserDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select UserName from ERPUser order by UserName asc");
//<2F>ϼ<EFBFBD><CFBC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
string HeJiStr = "<tr><td align=center height=30px style=\"background-color: #ffffff\"><3E>ϼ<EFBFBD></td><td align=center style=\"background-color: #ffffff\"></td>";
//<2F><><EFBFBD>ɱ<EFBFBD><C9B1><EFBFBD>ͷ<EFBFBD><CDB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
Label1.Text = "<table width=100% bgcolor=\"#999999\" border=\"0\" cellpadding=\"2\" cellspacing=\"1\" ><tr><td align=center height=30px style=\"background-color: #ffffff\"><3E><><EFBFBD><EFBFBD></td><td align=center style=\"background-color: #ffffff\"><3E>û<EFBFBD><C3BB><EFBFBD></td>";
for (int i = 0; i < CanShuDT.Tables[0].Rows.Count; i++)
{
Label1.Text = Label1.Text + "<td align=center style=\"background-color: #ffffff\">" + CanShuDT.Tables[0].Rows[i]["ItemName"].ToString() + "</td>";
HeJiStr = HeJiStr + "<td align=center style=\"background-color: #ffffff\">" + GetFenXiangHeJi(i.ToString(), UserDT, CanShuDT) + "</td>";
}
Label1.Text = Label1.Text + "<td align=center style=\"background-color: #ffffff\">С<><D0A1></td></tr>";
HeJiStr = HeJiStr + "<td align=center style=\"background-color: #ffffff\">" + GetZongTiHeJi(UserDT, CanShuDT) + "</td></tr>";
//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
for (int j = 0; j < UserDT.Tables[0].Rows.Count; j++)
{
Label1.Text = Label1.Text + "<tr><td align=center height=30px style=\"background-color: #ffffff\">" + (j + 1).ToString() + "</td>";
Label1.Text = Label1.Text + "<td align=center height=30px style=\"background-color: #ffffff\">" + UserDT.Tables[0].Rows[j]["UserName"].ToString() + "</td>";
for (int K = 0; K < CanShuDT.Tables[0].Rows.Count; K++)
{
Label1.Text = Label1.Text + "<td align=center style=\"background-color: #ffffff\"><INPUT value=\"" + ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 NumStr from ERPJXDetails where JXID=" + Request.QueryString["ID"].ToString() + " and ItemsID=" + CanShuDT.Tables[0].Rows[K]["ID"].ToString() + " and UserName='" + UserDT.Tables[0].Rows[j]["UserName"].ToString() + "'") + "\" id=InP-" + j.ToString() + "-" + K.ToString() + " name=InP-" + UserDT.Tables[0].Rows[j]["UserName"].ToString() + "-" + CanShuDT.Tables[0].Rows[K]["ID"].ToString() + " SIZE=10></td>";
}
Label1.Text = Label1.Text + "<td align=center style=\"background-color: #ffffff\">" + GetUserXiaoJi(j.ToString(), UserDT, CanShuDT) + "</td>";
}
Label1.Text = Label1.Text + "</tr>";
Label1.Text = Label1.Text + HeJiStr + "</table>";
}
/// <summary>
/// <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ĺϼ<C4BA><CFBC><EFBFBD><EFBFBD><EFBFBD>
/// </summary>
/// <returns></returns>
public string GetZongTiHeJi(DataSet UserData, DataSet CanShuData)
{
string ReturnStr = "<INPUT readOnly style=\"border:0px\" id=\"ZongJiTongJi\" name=\"ZongJiTongJi\" SIZE=10>";
string DingYiBianLiang = "";//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ӡ<EFBFBD>
string ShuZhiAdd = "0";//<2F><><EFBFBD>ӵ<EFBFBD><D3B5><EFBFBD>ֵ
for (int j = 0; j < CanShuData.Tables[0].Rows.Count; j++)
{
DingYiBianLiang = DingYiBianLiang + "var Item" + j.ToString() + "=0;Item" + j.ToString() + "=document.getElementById(\"FenXiang" + j.ToString() + "\").value/1;";
ShuZhiAdd = ShuZhiAdd + "+Item" + j.ToString() + "";
}
//<2F><><EFBFBD><EFBFBD>js<6A><73><EFBFBD><EFBFBD>
ReturnStr = ReturnStr + "<script>function Load_ZongJi(){setTimeout(\"Load_ZongJi()\",5000);" + DingYiBianLiang + "document.getElementById(\"ZongJiTongJi\").value=" + ShuZhiAdd + ";}</script><script>Load_ZongJi();</script>";
return ReturnStr;
}
/// <summary>
/// <20><><EFBFBD>ط<EFBFBD><D8B7><EFBFBD><EFBFBD>ĺϼ<C4BA><CFBC><EFBFBD><EFBFBD><EFBFBD>
/// </summary>
/// <param name="FenXiangNum"><3E><><EFBFBD><EFBFBD><EFBFBD>ڲ<EFBFBD><DAB2><EFBFBD><EFBFBD>ж<EFBFBD>Ӧ<EFBFBD><D3A6>˳<EFBFBD><CBB3><EFBFBD><EFBFBD></param>
/// <returns></returns>
public string GetFenXiangHeJi(string FenXiangNum, DataSet UserData, DataSet CanShuData)
{
string ReturnStr = "<INPUT readOnly style=\"border:0px\" id=FenXiang" + FenXiangNum + " name=FenXiang" + FenXiangNum + " SIZE=10>";
string DingYiBianLiang = "";//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ӡ<EFBFBD>
string ShuZhiAdd = "0";//<2F><><EFBFBD>ӵ<EFBFBD><D3B5><EFBFBD>ֵ
for (int j = 0; j < UserData.Tables[0].Rows.Count; j++)
{
//InP-" + j.ToString() + "-" + K.ToString() + "
DingYiBianLiang = DingYiBianLiang + "var Item" + j.ToString() + "=0;Item" + j.ToString() + "=document.getElementById(\"InP-" + j.ToString() + "-" + FenXiangNum + "\").value/1;";
ShuZhiAdd = ShuZhiAdd + "+Item" + j.ToString() + "";
}
//<2F><><EFBFBD><EFBFBD>js<6A><73><EFBFBD><EFBFBD>
ReturnStr = ReturnStr + "<script>function Load_DoFenXiang" + FenXiangNum + "(){setTimeout(\"Load_DoFenXiang" + FenXiangNum + "()\",5000);" + DingYiBianLiang + "document.getElementById(\"FenXiang" + FenXiangNum + "\").value=" + ShuZhiAdd + ";}</script><script>Load_DoFenXiang" + FenXiangNum + "();</script>";
return ReturnStr;
}
/// <summary>
/// <20><><EFBFBD><EFBFBD>һ<EFBFBD>е<EFBFBD>С<EFBFBD><D0A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
/// </summary>
/// <param name="UserNum"><3E>û<EFBFBD><C3BB><EFBFBD>Data<74>ж<EFBFBD>Ӧ<EFBFBD><D3A6>˳<EFBFBD><CBB3><EFBFBD><EFBFBD></param>
/// <returns></returns>
public string GetUserXiaoJi(string UserNum, DataSet UserData, DataSet CanShuData)
{
string ReturnStr = "<INPUT readOnly style=\"border:0px\" id=XiaoJi" + UserNum + " name=XiaoJi" + UserNum + " SIZE=10>";
string DingYiBianLiang = "";//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ӡ<EFBFBD>
string ShuZhiAdd = "0";//<2F><><EFBFBD>ӵ<EFBFBD><D3B5><EFBFBD>ֵ
for (int j = 0; j < CanShuData.Tables[0].Rows.Count; j++)
{
//InP-" + j.ToString() + "-" + K.ToString() + "
DingYiBianLiang = DingYiBianLiang + "var Item" + j.ToString() + "=0;Item" + j.ToString() + "=document.getElementById(\"InP-" + UserNum.ToString() + "-" + j.ToString() + "\").value/1;";
ShuZhiAdd = ShuZhiAdd + "+Item" + j.ToString() + "";
}
//<2F><><EFBFBD><EFBFBD>js<6A><73><EFBFBD><EFBFBD>
ReturnStr = ReturnStr + "<script>function Load_DoXiaoJi" + UserNum + "(){setTimeout(\"Load_DoXiaoJi" + UserNum + "()\",5000);" + DingYiBianLiang + "document.getElementById(\"XiaoJi" + UserNum + "\").value=" + ShuZhiAdd + ";}</script><script>Load_DoXiaoJi" + UserNum + "();</script>";
return ReturnStr;
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPJiXiao Model = new ZWL.BLL.ERPJiXiao();
Model.ID = int.Parse(Request.QueryString["ID"].ToString());
Model.JXName=this.txtJXName.Text.ToString();
Model.JianJie=this.txtJianJie.Text.ToString();
Model.UserName=this.txtUserName.Text.ToString();
Model.TimeStr=DateTime.Parse(this.txtTimeStr.Text);
Model.Update();
//д<>뿼<EFBFBD><EBBFBC><EFBFBD><EFBFBD>ϸ<EFBFBD><CFB8>¼<EFBFBD><C2BC><EFBFBD>У<EFBFBD><D0A3><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
//<2F><>ȡ<EFBFBD><C8A1>̬<EFBFBD><CCAC><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
DataSet CanShuDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select ItemName,ID from ERPJiXiaoCanShu order by BackInfo");
//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݵ<EFBFBD><DDB5>б<EFBFBD><D0B1><EFBFBD>
DataSet UserDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select UserName from ERPUser order by UserName asc");
//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>һ<EFBFBD>ε<EFBFBD><CEB5><EFBFBD>ϸ<EFBFBD><CFB8>¼<EFBFBD><C2BC>Ȼ<EFBFBD><C8BB><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ӡ<EFBFBD>
ZWL.DBUtility.DbHelperSQL.ExecuteSQL("delete from ERPJXDetails where JXID=" + Request.QueryString["ID"].ToString());
//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݵ<EFBFBD><DDB5><EFBFBD><EFBFBD>ݱ<EFBFBD>
for (int j = 0; j < UserDT.Tables[0].Rows.Count; j++)
{
for (int K = 0; K < CanShuDT.Tables[0].Rows.Count; K++)
{
//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>µĿ<C2B5><C4BF><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
ZWL.BLL.ERPJXDetails MyModel = new ZWL.BLL.ERPJXDetails();
MyModel.JXID = int.Parse(Request.QueryString["ID"].ToString());
MyModel.ItemsID = int.Parse(CanShuDT.Tables[0].Rows[K]["ID"].ToString());
MyModel.UserName = UserDT.Tables[0].Rows[j]["UserName"].ToString();
MyModel.NumStr = Request.Form["InP-" + UserDT.Tables[0].Rows[j]["UserName"].ToString() + "-" + CanShuDT.Tables[0].Rows[K]["ID"].ToString()].ToString();
MyModel.Add();
}
}
//дϵͳ<CFB5><CDB3>־
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "<22>û<EFBFBD><C3BB>޸ļ<DEB8>Ч<EFBFBD><D0A7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ(" + this.txtJXName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "<22><>Ч<EFBFBD><D0A7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ<EFBFBD>޸ijɹ<C4B3><C9B9><EFBFBD>", "JiXiao.aspx");
}
}
Reference in New Issue Copy Permalink