private void InitOrderSub(int uID)
{
DataSet ids = OrderSubManage.GetUnAuditOrderIDByUserID(uID);
DataSet subs = OrderSubManage.GetUnAuditByUserID(uID);
foreach (DataRow id in ids.Tables[0].Rows)
{
string orderID = id["ORDER_ID"] as string;
DataRow[] user_subs = subs.Tables[0].Select("ORDER_ID='" + orderID + "'");
TreeNode tr = new TreeNode(orderID);
tr.SelectAction = TreeNodeSelectAction.None;
tr.ShowCheckBox = true;
tr.Value = orderID;
foreach (DataRow dr in user_subs)
{
string name = dr["NAME"] as string;
string shortName = dr["SHORTNAME"] as string;
TreeNode t = new TreeNode();
t.SelectAction = TreeNodeSelectAction.None;
t.Text = shortName + "-" + name;
tr.ChildNodes.Add(t);
}
TreeViewOrderSub.Nodes.Add(tr);
}
}
protected void LinkButtonInfo_Click(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
string code = lb.CommandArgument;
DataSet ds = OrderSubManage.GetOrderSubByCode(code);
TreeViewOrderSub.CollapseAll();
foreach (TreeNode n1 in TreeViewOrderSub.Nodes)
{
foreach (TreeNode n2 in n1.ChildNodes)
{
n2.Checked = false;
foreach (TreeNode n3 in n2.ChildNodes)
{
string[] args = n3.Value.Split(',');
string sql = string.Format("ITEM_CODE='{0}' AND ITEM_TYPE='{1}' AND ORDER_ITEM_CODE='{2}'", args[0], args[1], args[2]);
DataRow[] result = ds.Tables[0].Select(sql);
if (result.Count() > 0)
{
n3.Checked = true;
//n3.Parent.Expand();
n3.Parent.Checked = true;
n1.Expand();
}
else
{
n3.Checked = false;
}
}
}
}
}
protected void ButtonAudit_Click(object sender, EventArgs e)
{
TreeNodeCollection subs = TreeViewOrderSub.CheckedNodes;
foreach (TreeNode tn in subs)
{
string orderID = tn.Value;
int res = OrderSubManage.UpdateAuditFlg(_userID, orderID);
}
Response.Redirect("ItemResultInput.aspx");
}
private List <string> GetAddSql(string orderID)
{
List <string> sqls = new List <string>();
foreach (TreeNode n3 in TreeViewOrderSub.CheckedNodes)
{
if (string.IsNullOrEmpty(n3.ToolTip))
{
string[] args = n3.Value.Split(',');
sqls.Add(OrderSubManage.GetAddSql(orderID, args[0], args[1], args[2], args[3], args[4]));
}
}
return(sqls);
}
protected void ButtonBind_Click(object sender, EventArgs e)
{
RepeaterItemCollection ric = RepeaterInfo.Items;
List <string> sqls = new List <string>();
foreach (RepeaterItem ri in ric)
{
HtmlInputCheckBox chb = (HtmlInputCheckBox)ri.FindControl("CheckCode");
if (chb.Checked)
{
string id = chb.Value;
sqls.Add(OrderSubManage.GetDelSql(id));
sqls.AddRange(GetAddSql(id));
}
}
DbHelperSQL.ExecuteSqlTran(sqls);
LTP.Common.MessageBox.Show(this, "项目绑定成功！");
}
private void InitData()
{
StringBuilder sb = new StringBuilder();
DataSet ds = TestGroupManage.GetTestGroupByType("1");
DataRow[] group = ds.Tables[0].Select("GROUP_ID <> '010'");
int colSpan = _col + 1;
foreach (DataRow dr in group)
{
string groupID = dr["GROUP_ID"] as string;
string name = dr["NAME"] as string;
DataSet subs = OrderSubManage.GetUnTestByGroupID(groupID);
if (subs.Tables[0].Rows.Count > 0)
{
sb.AppendLine("<div class='split'>");
sb.AppendLine("<table border='0' width='600px' align='center'>");
sb.AppendLine("<thead style='font-weight:bold'>");
sb.AppendLine("<tr><td colspan='" + colSpan + "' align='center' style='font-weight:bold;'>" + name + "</td></tr></thead>");
sb.AppendLine("<tbody style='text-align:left'>");
DataSet orderIDs = OrderSubManage.GetUnTestOrderIDByGroupID(groupID);
foreach (DataRow orderID in orderIDs.Tables[0].Rows)
{
int i = 1;
string id = orderID["ORDER_ID"] as string;
//string seriesName = orderID["SERIES_NAME"] as string;
//string showName = string.Format("{0}{1}", id, seriesName == null ? "" : seriesName);
DataRow[] rs = subs.Tables[0].Select("ORDER_ID='" + id + "'");
int end = rs.Length;
int span = Convert.ToInt16(Math.Ceiling(end / (_col * 1.0)));
sb.AppendLine("<tr><td width='20%' rowspan='" + span + "' style='word-wrap:break-word;word-break:break-all;'>" + id + "</td>");
foreach (DataRow r in rs)
{
if ((i % _col) == 1 && i != 1)
{
sb.AppendLine("<tr>");
}
sb.AppendLine("<td>" + r["SHORTNAME"] + "</td>");
if (i % _col == 0)
{
sb.AppendLine("</tr>");
}
i++;
}
sb.Append("</tr>");
sb.Append("<tr><td colspan='" + colSpan + "' style='color:black'><hr/></td></tr>");
}
sb.AppendLine("</tbody>");
sb.AppendLine("</table>");
sb.AppendLine("</div>");
}
}
_html = sb.ToString();
}
