private string createList()
{
System.Text.StringBuilder sb = new System.Text.StringBuilder("");
sb.Append("<table class=\"table table-border table-bordered table-hover table-bg\" id=\"tablelist\">");
sb.Append("<thead>");
sb.Append("<tr class=\"text-c\">");
sb.Append("<th width=\"10%\">序号</th>");
sb.Append("<th width='30%'>预警类型</th>");
sb.Append("<th width='45%'>预警时长(分钟)</th>");
sb.Append("<th width='15%'>操作</th>");
sb.Append("</tr>");
sb.Append("</thead>");
int r = 1;
sb.Append("<tbody>");
Business.Base.BusinessWarningTime bc = new Business.Base.BusinessWarningTime();
foreach (Entity.Base.EntityWarningTime it in bc.GetWarningTimeListQuery(user.Entity.AccID))
{
sb.Append("<tr class=\"text-c\" id=\"" + it.InnerEntityOID + "\">");
sb.Append("<td align='center'>" + r.ToString() + "</td>");
sb.Append("<td>" + it.ParaName + "</td>");
sb.Append("<td><input type=\"text\" class=\"input-text size-S\" style=\"width:200px\" placeholder=\"\" id=\"Time" + it.InnerEntityOID + "\" onblur=\"validInt(this.id)\" value=\"" + it.Time.ToString() + "\"></td>");
sb.Append("<td><a href=\"javascript:;\" onclick=\"save('" + it.InnerEntityOID + "')\" class=\"btn btn-primary radius\"><i class=\"Hui-iconfont\"></i> 保存</a></td>");
sb.Append("</tr>");
r++;
}
sb.Append("</tbody>");
sb.Append("</table>");
return(sb.ToString());
}
private string createList(string OrderType, string CustNo, string OrderNo, string UserNo, string MinOrderDate, string MaxOrderDate)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder("");
sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort\" id=\"tablelist\">");
sb.Append("<thead>");
sb.Append("<tr class=\"text-c\">");
sb.Append("<th width=\"5%\">序号</th>");
sb.Append("<th width='10%'>工单内容</th>");
sb.Append("<th width='10%'>工单类型</th>");
sb.Append("<th width='10%'>工单日期</th>");
sb.Append("<th width='10%'>处理人</th>");
sb.Append("<th width='10%'>状态</th>");
sb.Append("<th width='9%'>响应</th>");
sb.Append("<th width='9%'>预约</th>");
sb.Append("<th width='9%'>签到</th>");
sb.Append("<th width='9%'>完成</th>");
sb.Append("<th width='9%'>消单</th>");
sb.Append("</tr>");
sb.Append("</thead>");
string AlloUser = "******";
//非管理员登录，只能看到当前用户为部门负责人的单
if (user.Entity.UserType.ToUpper() != "ADMIN" && (user.Entity.UserType.ToUpper() == "03" ||
user.Entity.UserType.ToUpper() == "07" || user.Entity.UserType.ToUpper() == "08"))
{
AlloUser = user.Entity.UserNo;
}
SqlConnection con = null;
SqlCommand cmd = null;
DataSet ds = new DataSet();
try
{
con = Data.Conn();
cmd = new SqlCommand("GetEarlyWarning", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@AccID", SqlDbType.NVarChar, 20),
new SqlParameter("@OrderType", SqlDbType.NVarChar, 30),
new SqlParameter("@CustNo", SqlDbType.NVarChar, 30),
new SqlParameter("@OrderNo", SqlDbType.NVarChar, 30),
new SqlParameter("@UserNo", SqlDbType.NVarChar, 30),
new SqlParameter("@AlloUser", SqlDbType.NVarChar, 30),
new SqlParameter("@MinOrderDate", SqlDbType.NVarChar, 10),
new SqlParameter("@MaxOrderDate", SqlDbType.NVarChar, 10)
};
if (OrderType == "")
{
OrderType = "%";
}
if (CustNo == "")
{
CustNo = "%";
}
if (OrderNo == "")
{
OrderNo = "%";
}
if (UserNo == "")
{
UserNo = "%";
}
parameter[0].Value = user.Entity.AccID;
parameter[1].Value = OrderType;
parameter[2].Value = CustNo;
parameter[3].Value = OrderNo;
parameter[4].Value = UserNo;
parameter[5].Value = AlloUser;
parameter[6].Value = MinOrderDate;
parameter[7].Value = MaxOrderDate;
cmd.Parameters.AddRange(parameter);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
DataTable dt = ds.Tables[0];
int ResponseTime = 0;
int AppoIntTime = 0;
int SignTime = 0;
int FinishTime = 0;
int CloseTime = 0;
Business.Base.BusinessWarningTime wt = new Business.Base.BusinessWarningTime();
wt.loadParaNo("ResponseTime", user.Entity.AccID);
ResponseTime = wt.Entity.Time;
wt.loadParaNo("AppoIntTime", user.Entity.AccID);
AppoIntTime = wt.Entity.Time;
wt.loadParaNo("SignTime", user.Entity.AccID);
SignTime = wt.Entity.Time;
wt.loadParaNo("FinishTime", user.Entity.AccID);
FinishTime = wt.Entity.Time;
wt.loadParaNo("CloseTime", user.Entity.AccID);
CloseTime = wt.Entity.Time;
int r = 1;
sb.Append("<tbody>");
foreach (DataRow it in dt.Rows)
{
sb.Append("<tr class=\"text-c\" id=\"" + it["OrderNo"] + "\">");
sb.Append("<td align='center'>" + r.ToString() + "</td>");
sb.Append("<td>" + it["OrderName"].ToString() + "</td>");
sb.Append("<td>" + it["OrderTypeName"].ToString() + "</td>");
sb.Append("<td>" + ParseDateForString(it["OrderDate"].ToString()).ToString("yyyy-MM-dd HH:mm") + "</td>");
sb.Append("<td>" + it["TeateUser"].ToString() + "</td>");
sb.Append("<td>" + it["StatusName"].ToString() + "</td>");
if (it["ResponseMM"].ToString() != "")
{
if (ParseIntForString(it["ResponseMM"].ToString()) > ResponseTime)
{
sb.Append("<td style=\"background-color:red;\">" + (ParseIntForString(it["ResponseMM"].ToString()) - ResponseTime).ToString() + "</td>");
}
else
{
sb.Append("<td>" + (ParseIntForString(it["ResponseMM"].ToString()) - ResponseTime).ToString() + "</td>");
}
}
else
{
sb.Append("<td></td>");
}
if (it["AppoIntMM"].ToString() != "")
{
if (ParseIntForString(it["AppoIntMM"].ToString()) > AppoIntTime)
{
sb.Append("<td style=\"background-color:red;\">" + (ParseIntForString(it["AppoIntMM"].ToString()) - AppoIntTime).ToString() + "</td>");
}
else
{
sb.Append("<td>" + (ParseIntForString(it["AppoIntMM"].ToString()) - AppoIntTime).ToString() + "</td>");
}
}
else
{
sb.Append("<td></td>");
}
if (it["SignMM"].ToString() != "")
{
if (ParseIntForString(it["SignMM"].ToString()) > SignTime)
{
sb.Append("<td style=\"background-color:red;\">" + (ParseIntForString(it["SignMM"].ToString()) - SignTime).ToString() + "</td>");
}
else
{
sb.Append("<td>" + (ParseIntForString(it["SignMM"].ToString()) - SignTime).ToString() + "</td>");
}
}
else
{
sb.Append("<td></td>");
}
if (it["FinishMM"].ToString() != "")
{
if (ParseIntForString(it["FinishMM"].ToString()) > FinishTime)
{
sb.Append("<td style=\"background-color:red;\">" + (ParseIntForString(it["FinishMM"].ToString()) - FinishTime).ToString() + "</td>");
}
else
{
sb.Append("<td>" + (ParseIntForString(it["FinishMM"].ToString()) - FinishTime).ToString() + "</td>");
}
}
else
{
sb.Append("<td></td>");
}
if (it["CloseMM"].ToString() != "")
{
if (ParseIntForString(it["CloseMM"].ToString()) > CloseTime)
{
sb.Append("<td style=\"background-color:red;\">" + (ParseIntForString(it["CloseMM"].ToString()) - CloseTime).ToString() + "</td>");
}
else
{
sb.Append("<td>" + (ParseIntForString(it["CloseMM"].ToString()) - CloseTime).ToString() + "</td>");
}
}
else
{
sb.Append("<td></td>");
}
sb.Append("</tr>");
r++;
}
sb.Append("</tbody>");
}
catch { }
finally
{
if (cmd != null)
{
cmd.Dispose();
}
if (con != null)
{
con.Dispose();
}
}
sb.Append("</table>");
return(sb.ToString());
}
