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

500 lines
26 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_TiKuKaoShiAdd : System.Web.UI.Page
{
public int MaxTime = 90000000;//<2F><><EFBFBD>忼<EFBFBD>Ե<EFBFBD><D4B5><EFBFBD>ʱ<EFBFBD><CAB1><EFBFBD>룩
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
//<2F><><EFBFBD><EFBFBD><EFBFBD>ϴ<EFBFBD><CFB4>ĸ<EFBFBD><C4B8><EFBFBD>Ϊ<EFBFBD><CEAA>
ZWL.Common.PublicMethod.SetSessionValue("WenJianList", "");
//<2F><><EFBFBD>Ծ<EFBFBD><D4BE><EFBFBD><EFBFBD>ص<EFBFBD><D8B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>У<EFBFBD><D0A3><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
ZWL.DBUtility.DbHelperSQL.BindDropDownList("select * from ERPTiKuShiJuan order by ID desc", this.DropDownList1, "ShiJuanTitle", "ID");
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ZWL.BLL.ERPTiKuKaoShi Model0 = new ZWL.BLL.ERPTiKuKaoShi();
Model0.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model0.TimeStr = DateTime.Now;
Model0.ShiJuanName = this.DropDownList1.SelectedItem.Text;
Model0.ShiJuanID = int.Parse(this.DropDownList1.SelectedValue);
int MaxID=Model0.Add();
this.Panel1.Visible = false;
//<2F><>ȡ<EFBFBD>Ծ<EFBFBD><D4BE><EFBFBD>Ϣ
ZWL.BLL.ERPTiKuShiJuan Model = new ZWL.BLL.ERPTiKuShiJuan();
Model.GetModel(int.Parse(this.DropDownList1.SelectedItem.Value.ToString()));
MaxTime = int.Parse(Model.KaoShiXianShi.ToString()) * 60;//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ
string[] FenLeiSunXu = Model.FenLeiShunXu.Split('|');
for (int j = 0; j < FenLeiSunXu.Length; j++)
{
//<2F>󶨵<EFBFBD>ǰ<EFBFBD><C7B0>Ŀ<EFBFBD><C4BF><EFBFBD>е<EFBFBD><D0B5><EFBFBD>Ŀ
string TiMuIDList = "0";
if (FenLeiSunXu[j].ToString() == "<22>ж<EFBFBD><D0B6><EFBFBD>")
{
TiMuIDList = this.Lab1.Text;
DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
{
ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();
Model1.KaoShiID = MaxID;
Model1.TiMuID =int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
Model1.DaAn = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();
string UserDaAnStr = "";
try
{
UserDaAnStr= Request.Form["rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString()].ToString();
}
catch { }
Model1.UserDaAn = UserDaAnStr;
if (UserDaAnStr == MYDT.Tables[0].Rows[i]["AnswerStr"].ToString())
{
Model1.DeFen = Model.PanDuanFenShu;
}
else
{
Model1.DeFen = 0;
}
Model1.Add();
}
}
else if (FenLeiSunXu[j].ToString() == "<22><><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD>")
{
TiMuIDList = this.Lab2.Text;
DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
{
ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();
Model1.KaoShiID = MaxID;
Model1.TiMuID = int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
Model1.DaAn = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();
string UserDaAnStr = "";
try
{
UserDaAnStr = Request.Form["rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString()].ToString();
}
catch { }
Model1.UserDaAn = UserDaAnStr;
if (UserDaAnStr == MYDT.Tables[0].Rows[i]["AnswerStr"].ToString())
{
Model1.DeFen = Model.DanXuanFenShu;
}
else
{
Model1.DeFen = 0;
}
Model1.Add();
}
}
else if (FenLeiSunXu[j].ToString() == "<22><><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD>")
{
TiMuIDList = this.Lab3.Text;
DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
{
ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();
Model1.KaoShiID = MaxID;
Model1.TiMuID = int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
Model1.DaAn = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();
string DangQianDaAnStr = "";
try
{
DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-A"].ToString();
}
catch { }
try
{
DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-B"].ToString();
}
catch { }
try
{
DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-C"].ToString();
}
catch { }
try
{
DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-D"].ToString();
}
catch { }
try
{
DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-E"].ToString();
}
catch { }
try
{
DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-F"].ToString();
}
catch { }
try
{
DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-G"].ToString();
}
catch { }
try
{
DangQianDaAnStr = DangQianDaAnStr + Request.Form["CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-H"].ToString();
}
catch { }
Model1.UserDaAn = DangQianDaAnStr;
if (DangQianDaAnStr == MYDT.Tables[0].Rows[i]["AnswerStr"].ToString())
{
Model1.DeFen = Model.DuoXuanFenShu;
}
else
{
Model1.DeFen = 0;
}
Model1.Add();
}
}
else if (FenLeiSunXu[j].ToString() == "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>")
{
TiMuIDList = this.Lab4.Text;
DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
{
ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();
Model1.KaoShiID = MaxID;
Model1.TiMuID = int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
Model1.DaAn = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();
string UserDaAnStr = "";
try
{
UserDaAnStr = Request.Form["text-" + MYDT.Tables[0].Rows[i]["ID"].ToString()].ToString();
}
catch { }
Model1.UserDaAn = UserDaAnStr;
if (UserDaAnStr == MYDT.Tables[0].Rows[i]["AnswerStr"].ToString())
{
Model1.DeFen = Model.TianKongFenShu;
}
else
{
Model1.DeFen = 0;
}
Model1.Add();
}
}
else if (FenLeiSunXu[j].ToString() == "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>")
{
TiMuIDList = this.Lab5.Text;
DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
{
ZWL.BLL.ERPTiKuKaoShiJieGuo Model1 = new ZWL.BLL.ERPTiKuKaoShiJieGuo();
Model1.KaoShiID = MaxID;
Model1.TiMuID = int.Parse(MYDT.Tables[0].Rows[i]["ID"].ToString());
Model1.DaAn = MYDT.Tables[0].Rows[i]["AnswerStr"].ToString();
string UserDaAnStr = "";
try
{
UserDaAnStr = Request.Form["textarea-" + MYDT.Tables[0].Rows[i]["ID"].ToString()].ToString();
}
catch { }
Model1.UserDaAn = UserDaAnStr;
Model1.DeFen =null;
Model1.Add();
}
}
}
//дϵͳ<CFB5><CDB3>־
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "<22>û<EFBFBD><C3BB><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>߿<EFBFBD><DFBF><EFBFBD><EFBFBD><EFBFBD>Ϣ(" + this.DropDownList1.SelectedItem.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "<22><><EFBFBD>߿<EFBFBD><DFBF><EFBFBD><EFBFBD><EFBFBD>Ϣ<EFBFBD><CFA2><EFBFBD>ӳɹ<D3B3><C9B9><EFBFBD><EFBFBD><EFBFBD>ǰ<EFBFBD><C7B0><EFBFBD><EFBFBD><EFBFBD>ľ<EFBFBD><C4BE>÷֣<C3B7>" + ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select sum(DeFen) from ERPTiKuKaoShiJieGuo where KaoShiID=" + MaxID.ToString()) + "<22><><EFBFBD>˷<EFBFBD><CBB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˹<EFBFBD><CBB9>ľ<EFBFBD><C4BE><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>", "TiKuKaoShi.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
this.DropDownList1.Enabled = false;
this.Button1.Enabled = false;
this.Panel1.Visible = true;
//<2F><>ȡ<EFBFBD>Ծ<EFBFBD><D4BE><EFBFBD>Ϣ
ZWL.BLL.ERPTiKuShiJuan Model = new ZWL.BLL.ERPTiKuShiJuan();
Model.GetModel(int.Parse(this.DropDownList1.SelectedItem.Value.ToString()));
MaxTime =int.Parse(Model.KaoShiXianShi.ToString()) * 60;//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ
string[] FenLeiSunXu=Model.FenLeiShunXu.Split('|');
for (int j = 0; j < FenLeiSunXu.Length; j++)
{
string DaBiaoTi = "һ";
if (j == 0)
{
DaBiaoTi = "һ";
}
else if (j == 1)
{
DaBiaoTi = "<22><>";
}
else if (j == 2)
{
DaBiaoTi = "<22><>";
}
else if (j == 3)
{
DaBiaoTi = "<22><>";
}
else if (j == 4)
{
DaBiaoTi = "<22><>";
}
//<2F>󶨵<EFBFBD>ǰ<EFBFBD><C7B0>Ŀ<EFBFBD><C4BF><EFBFBD>е<EFBFBD><D0B5><EFBFBD>Ŀ
string TiMuIDList = "0";
if (FenLeiSunXu[j].ToString() == "<22>ж<EFBFBD><D0B6><EFBFBD>")
{
TiMuIDList = DongTaiOrJingTai(Model.PanDuanTiList, Model.IFSuiJiChuTi, "<22>ж<EFBFBD><D0B6><EFBFBD>");
if (TiMuIDList.Trim().Length > 0 && TiMuIDList.Trim()!="0")
{
//һ<><D2BB> <09>ж<EFBFBD><D0B6>⣨ÿ<E2A3A8><C3BF>1<EFBFBD>֣<EFBFBD><D6A3><EFBFBD>20<32>֣<EFBFBD>
this.Label1.Text = this.Label1.Text + DaBiaoTi + "<22><>" + FenLeiSunXu[j].ToString() + "<22><>ÿ<EFBFBD><C3BF>" + Model.PanDuanFenShu.ToString() + "<22>֣<EFBFBD><D6A3><EFBFBD>" + TiMuIDList.Split(',').Length.ToString() + "<22>⣬<EFBFBD>ϼ<EFBFBD>" + (Model.PanDuanFenShu * TiMuIDList.Split(',').Length).ToString() + "<22>֣<EFBFBD><hr>";
DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
{
int TempNum = i + 1;
this.Label1.Text = this.Label1.Text + TempNum.ToString() + "<22><>" + MYDT.Tables[0].Rows[i]["TitleStr"].ToString() + "<br>";
if (MYDT.Tables[0].Rows[i]["ItemsA"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"radio\" name=\"rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "\" value=\"A\"> A<><41>" + MYDT.Tables[0].Rows[i]["ItemsA"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsB"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"radio\" name=\"rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "\" value=\"B\"> B<><42>" + MYDT.Tables[0].Rows[i]["ItemsB"].ToString() + "<br>";
}
this.Label1.Text = this.Label1.Text + "<P>";
}
}
}
else if (FenLeiSunXu[j].ToString() == "<22><><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD>")
{
TiMuIDList = DongTaiOrJingTai(Model.DanXuanTiList, Model.IFSuiJiChuTi, "<22><><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD>");
if (TiMuIDList.Trim().Length > 0 && TiMuIDList.Trim() != "0")
{
this.Label1.Text = this.Label1.Text + DaBiaoTi + "<22><>" + FenLeiSunXu[j].ToString() + "<22><>ÿ<EFBFBD><C3BF>" + Model.DanXuanFenShu.ToString() + "<22>֣<EFBFBD><D6A3><EFBFBD>" + TiMuIDList.Split(',').Length.ToString() + "<22>⣬<EFBFBD>ϼ<EFBFBD>" + (Model.DanXuanFenShu * TiMuIDList.Split(',').Length).ToString() + "<22>֣<EFBFBD><hr>";
DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
{
int TempNum = i + 1;
this.Label1.Text = this.Label1.Text + TempNum.ToString() + "<22><>" + MYDT.Tables[0].Rows[i]["TitleStr"].ToString() + "<br>";
if (MYDT.Tables[0].Rows[i]["ItemsA"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"radio\" name=\"rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "\" value=\"A\"> A<><41>" + MYDT.Tables[0].Rows[i]["ItemsA"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsB"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"radio\" name=\"rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "\" value=\"B\"> B<><42>" + MYDT.Tables[0].Rows[i]["ItemsB"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsC"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"radio\" name=\"rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "\" value=\"C\"> C<><43>" + MYDT.Tables[0].Rows[i]["ItemsC"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsD"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"radio\" name=\"rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "\" value=\"D\"> D<><44>" + MYDT.Tables[0].Rows[i]["ItemsD"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsE"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"radio\" name=\"rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "\" value=\"E\"> E<><45>" + MYDT.Tables[0].Rows[i]["ItemsE"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsF"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"radio\" name=\"rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "\" value=\"F\"> F<><46>" + MYDT.Tables[0].Rows[i]["ItemsF"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsG"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"radio\" name=\"rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "\" value=\"G\"> G<><47>" + MYDT.Tables[0].Rows[i]["ItemsG"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsH"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"radio\" name=\"rad-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "\" value=\"H\"> H<><48>" + MYDT.Tables[0].Rows[i]["ItemsH"].ToString() + "<br>";
}
this.Label1.Text = this.Label1.Text + "<P>";
}
}
}
else if (FenLeiSunXu[j].ToString() == "<22><><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD>")
{
TiMuIDList = DongTaiOrJingTai(Model.DuoXuanTiList, Model.IFSuiJiChuTi, "<22><><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD>");
if (TiMuIDList.Trim().Length > 0 && TiMuIDList.Trim() != "0")
{
this.Label1.Text = this.Label1.Text + DaBiaoTi + "<22><>" + FenLeiSunXu[j].ToString() + "<22><>ÿ<EFBFBD><C3BF>" + Model.DuoXuanFenShu.ToString() + "<22>֣<EFBFBD><D6A3><EFBFBD>" + TiMuIDList.Split(',').Length.ToString() + "<22>⣬<EFBFBD>ϼ<EFBFBD>" + (Model.DuoXuanFenShu * TiMuIDList.Split(',').Length).ToString() + "<22>֣<EFBFBD><hr>";
DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
{
int TempNum = i + 1;
this.Label1.Text = this.Label1.Text + TempNum.ToString() + "<22><>" + MYDT.Tables[0].Rows[i]["TitleStr"].ToString() + "<br>";
if (MYDT.Tables[0].Rows[i]["ItemsA"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"checkbox\" name=\"CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-A\" value=\"A\"> A<><41>" + MYDT.Tables[0].Rows[i]["ItemsA"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsB"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"checkbox\" name=\"CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-B\" value=\"B\"> B<><42>" + MYDT.Tables[0].Rows[i]["ItemsB"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsC"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"checkbox\" name=\"CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-C\" value=\"C\"> C<><43>" + MYDT.Tables[0].Rows[i]["ItemsC"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsD"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"checkbox\" name=\"CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-D\" value=\"D\"> D<><44>" + MYDT.Tables[0].Rows[i]["ItemsD"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsE"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"checkbox\" name=\"CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-E\" value=\"E\"> E<><45>" + MYDT.Tables[0].Rows[i]["ItemsE"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsF"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"checkbox\" name=\"CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-F\" value=\"F\"> F<><46>" + MYDT.Tables[0].Rows[i]["ItemsF"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsG"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"checkbox\" name=\"CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-G\" value=\"G\"> G<><47>" + MYDT.Tables[0].Rows[i]["ItemsG"].ToString() + "<br>";
}
if (MYDT.Tables[0].Rows[i]["ItemsH"].ToString().Trim().Length > 0)
{
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<input type=\"checkbox\" name=\"CHK-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "-H\" value=\"H\"> H<><48>" + MYDT.Tables[0].Rows[i]["ItemsH"].ToString() + "<br>";
}
this.Label1.Text = this.Label1.Text + "<P>";
}
}
}
else if (FenLeiSunXu[j].ToString() == "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>")
{
TiMuIDList = DongTaiOrJingTai(Model.TianKongTiList,Model.IFSuiJiChuTi,"<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>");
if (TiMuIDList.Trim().Length > 0 && TiMuIDList.Trim() != "0")
{
this.Label1.Text = this.Label1.Text + DaBiaoTi + "<22><>" + FenLeiSunXu[j].ToString() + "<22><>ÿ<EFBFBD><C3BF>" + Model.TianKongFenShu.ToString() + "<22>֣<EFBFBD><D6A3><EFBFBD>" + TiMuIDList.Split(',').Length.ToString() + "<22>⣬<EFBFBD>ϼ<EFBFBD>" + (Model.TianKongFenShu * TiMuIDList.Split(',').Length).ToString() + "<22>֣<EFBFBD><hr>";
DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
{
int TempNum = i + 1;
this.Label1.Text = this.Label1.Text + TempNum.ToString() + "<22><>" + MYDT.Tables[0].Rows[i]["TitleStr"].ToString() + "<br>";
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<3B>𰸣<EFBFBD><input type=\"text\" name=\"text-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "\" ><br>";
this.Label1.Text = this.Label1.Text + "<P>";
}
}
}
else if (FenLeiSunXu[j].ToString() == "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>")
{
TiMuIDList = DongTaiOrJingTai(Model.JianDaTiList,Model.IFSuiJiChuTi,"<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>");
if (TiMuIDList.Trim().Length > 0 && TiMuIDList.Trim() != "0")
{
this.Label1.Text = this.Label1.Text + DaBiaoTi + "<22><>" + FenLeiSunXu[j].ToString() + "<22><>ÿ<EFBFBD><C3BF>" + Model.JianDaFenShu.ToString() + "<22>֣<EFBFBD><D6A3><EFBFBD>" + TiMuIDList.Split(',').Length.ToString() + "<22>⣬<EFBFBD>ϼ<EFBFBD>" + (Model.JianDaFenShu * TiMuIDList.Split(',').Length).ToString() + "<22>֣<EFBFBD><hr>";
DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')");
for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++)
{
int TempNum = i + 1;
this.Label1.Text = this.Label1.Text + TempNum.ToString() + "<22><>" + MYDT.Tables[0].Rows[i]["TitleStr"].ToString() + "<br>";
this.Label1.Text = this.Label1.Text + "&nbsp;&nbsp;<3B>𰸣<EFBFBD><textarea cols=\"50\" rows=\"10\" name=\"textarea-" + MYDT.Tables[0].Rows[i]["ID"].ToString() + "\"></textarea><br>";
this.Label1.Text = this.Label1.Text + "<P>";
}
}
}
}
}
public string DongTaiOrJingTai(string MoRenList,string IFSuiJi,string FenLeiStr)
{
string ReturnStr = "";
if(IFSuiJi=="<22><>")
{
ReturnStr=MoRenList;
}
else
{
//<2F><>̬<EFBFBD><CCAC>ȡ<EFBFBD><C8A1>Ŀ<EFBFBD><C4BF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
string LieName = "DanXuanNum";
if (FenLeiStr == "<22><><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD>")
{
LieName = "DanXuanNum";
}
else if (FenLeiStr == "<22><><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD>")
{
LieName = "DuoXuanNum";
}
else if (FenLeiStr == "<22>ж<EFBFBD><D0B6><EFBFBD>")
{
LieName = "PanDuanNum";
}
else if (FenLeiStr == "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>")
{
LieName = "TianKongNum";
}
else if (FenLeiStr == "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>")
{
LieName = "JianDaNum";
}
string TiMuShu = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 " + LieName + " from ERPTiKuShiJuanSet where ShiJuanID="+this.DropDownList1.SelectedValue.ToString());//<2F><>Ŀ<EFBFBD><C4BF><EFBFBD><EFBFBD>
string TiKuID = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 TiKuTypeID from ERPTiKuShiJuanSet where ShiJuanID=" + this.DropDownList1.SelectedValue.ToString());//<2F><><EFBFBD><EFBFBD>TypeID
string IDList = ZWL.DBUtility.DbHelperSQL.GetStringList("select top " + TiMuShu + " ID from ERPTiKu where TiKuID=" + TiKuID + " and FenLeiStr='" + FenLeiStr + "' order by newid()").Replace('|', ',');
ReturnStr=IDList;
}
if (FenLeiStr == "<22>ж<EFBFBD><D0B6><EFBFBD>")
{
Lab1.Text = ReturnStr;
}
else if (FenLeiStr == "<22><><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD>")
{
Lab2.Text = ReturnStr;
}
else if (FenLeiStr == "<22><><EFBFBD><EFBFBD>ѡ<EFBFBD><D1A1><EFBFBD><EFBFBD>")
{
Lab3.Text = ReturnStr;
}
else if (FenLeiStr == "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>")
{
Lab4.Text = ReturnStr;
}
else if (FenLeiStr == "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>")
{
Lab5.Text = ReturnStr;
}
return ReturnStr;
}
}
Reference in New Issue Copy Permalink