protected void DataList1_OnRenderCell(object sender, DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, EventArgs e)
{
if (column.ID.ToUpper() == "DEL")
{
cell.OutputHTML = List_Del(column.ID, rs["rowid"].ToString(), true);
}
if (column.ID.ToUpper() == "EDIT")
{
cell.OutputHTML = List_Edit(column.ID, rs["rowid"].ToString(), true);
}
if (column.ID == "en")
{
string kind = rs["category"].ToString();
string link = rs["en"].ToString();
if (kind == "sp_standard" || kind == "ts_standard")
{
link = string.Format("<a href='../Standard/Standard.aspx?standard_id={0}' >{1}</a>", rs["rowid"].ToString(), rs["en"].ToString());
}
cell.OutputHTML = link;
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
if (Utility.MIS_Manager(CurrentUser.LogonID))
{
cell.OutputHTML = List_Default(column.ID, rs["id"].ToString(), true);
}
else
{
bool isEdit = rs["create_user"].ToString().ToUpper() == CurrentUser.LogonID.ToUpper();
cell.OutputHTML = List_Default(column.ID, rs["id"].ToString(), isEdit);
}
if (column.ID.ToUpper() == "STATUS")
{
cell.Value = tranfer_status(rs["status"].ToString());
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
/*
* if (column.ID == "DataList1_popupflowview")
* {
* System.Web.UI.WebControls.Image ib = (System.Web.UI.WebControls.Image)this.DataList1.Columns.GetItem("DataList1_popupflowview").GetControl("IB_popupflowview");
* //ib.Attributes.Add("onclick", GetOnclickScript(ResolveUrl("~/"), "AAA"));
* ib.Style.Add("cursor", "hand");
* }
* */
if (column.ID == "DataList1_chk")
{
string keys = "ID" + cell.Rowno.ToString() + "=" + rs["ID"].ToString();
cell.ClientID = "DataList1_chk_" + cell.Rowno.ToString();
cell.OutputHTML = "<input type=hidden id=\"DataList1_key_" + cell.Rowno.ToString() + "\" name=\"DataList1_key_" + cell.Rowno.ToString() + "\" value=\"" + keys + "\">";
}
if (column.ID == "DataList1_edit")
{
if (rs["IsStatus"].ToString().Trim() == "Complete")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/Lock.jpg\" border=\"0\">";
}
else
{
cell.OutputHTML = "<a href=\"ForwarderEdit.aspx?ID=" + rs["ID"].ToString() + "\"><img src=\"/ManagePDF/images/Edit.gif\" border=\"0\" Alt=修改></a>";
}
}
if (column.ID == "DataList1_edit2")
{
if (rs["IsStatus"].ToString().Trim() == "Complete")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/Lock.jpg\" border=\"0\">";
}
else
{
cell.OutputHTML = "<a href=\"ForwarderEdit.aspx?ID=" + rs["ID"].ToString() + "\"><img src=\"/Shipping/images/Edit.gif\" border=\"0\" Alt=修改></a>";
}
}
if (column.ID == "DataList1_Send" || column.ID == "DataList1_Send2")
{
cell.OutputHTML = "<a href=\"SendXml.aspx?ID=" + rs["ID"].ToString() + "\" Onclick=\"return confirm('出貨單號：" + rs["ERP_Key"].ToString() + " \\n確定重新上傳給 Forwarder 嗎?');\" ><img src=\"/Shipping/images/Up.gif\" border=\"0\" Alt=重新上傳></a>";
}
/*
* if (column.ID == "DataList1_Cdate")
* {
* DateTime datetime = Convert.ToDateTime(rs["Cdate"].ToString());
* cell.OutputHTML = datetime.ToString("yyyy/MM/dd");
* }
*/
if (column.ID == "DataList1_view")
{
cell.LinkURL = "ForwarderView.aspx?ID=" + rs["ID"].ToString();
}
if (column.ID == "DataColumn_IsStatus")
{
if (rs["IsStatus"].ToString().Trim() == "waiting")
{
cell.OutputHTML = "未送審";
}
if (rs["IsStatus"].ToString().Trim() == "Complete")
{
cell.OutputHTML = "<font color=blue>完成審核</font><img src=\"/Shipping/images/icon-agree.gif\" border=\"0\">";
}
if (rs["IsStatus"].ToString().Trim() == "Terminate")
{
cell.OutputHTML = "<font color=red>完成審核</font><img src=\"/Shipping/images/icon-reject.gif\" border=\"0\">";
}
if (rs["IsStatus"].ToString().Trim() == "isSend")
{
cell.OutputHTML = "<font color=green>送審中</font><img src=\"/Shipping/images/icon-senddoc.gif\" border=\"0\">";
}
if (rs["IsStatus"].ToString().Trim() == "isStop")
{
cell.OutputHTML = "作廢<img src=\"/Shipping/images/delete.gif\" border=\"0\" Alt=作廢>";
}
}
if (column.ID == "DataList1_multiapproval")
{
bool EndbledMultiApproval = false;
string[] ResultTypes = new string[0];
string classname = "";
try
{
classname = SmoothEnterprise.Web.Page.InheritsClass(rs["reviewerurl"].ToString());
System.Type FlowViewType = SmoothEnterprise.Utility.Type.GetType(classname);
Object obj = FlowViewType.InvokeMember(null, System.Reflection.BindingFlags.CreateInstance, null, null, null);
ResultTypes = (string[])FlowViewType.InvokeMember("MultiApproval_ResultTypes", System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Default | System.Reflection.BindingFlags.GetProperty, null, obj, null);
EndbledMultiApproval = (ResultTypes.Length > 0);
}
catch
{
EndbledMultiApproval = false;
}
// Response.Write(classname + ResultTypes.Length.ToString());
//Response.Write(EndbledMultiApproval);
if (rs["reviewdate"] == DBNull.Value && EndbledMultiApproval)
{
if (Global.iVars.ToString() == "0")
{
cell.OutputHTML =
"<div id='div_" + rs["reviewerurl"].ToString() + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("?")) + "' style=\"white-space:nowrap\">" + Environment.NewLine +
" <table>" + Environment.NewLine +
" <tr>" + Environment.NewLine +
" <td width=\"1px\">" + Environment.NewLine +
" <input type='checkbox' id='chk_multiapproval' name='chk_multiapproval' checked = 'true' value='" + rs["dgflowid"].ToString() + "'>" + Environment.NewLine +
" </td>" + Environment.NewLine +
" <td>" + Environment.NewLine +
" <select id='resulttype_" + rs["dgflowid"].ToString() + "' name='resulttype_" + rs["dgflowid"].ToString() + "' style=\"font-size:11px;\">" + Environment.NewLine;
for (int i = 0; i < ResultTypes.Length; i++)
{
switch (ResultTypes[i])
{
case "Next":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Next.ToString() + "\">允許</option>" + Environment.NewLine;
break;
case "Back":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Back.ToString() + "\">退回上一關</option>" + Environment.NewLine;
break;
case "Complete":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Complete.ToString() + "\">完成</option>" + Environment.NewLine;
break;
case "None":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.None.ToString() + "\">沒意見</option>" + Environment.NewLine;
break;
case "Return":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Return.ToString() + "\">退回重送</option>" + Environment.NewLine;
break;
case "Terminate":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Terminate.ToString() + "\">退回提案人</option>" + Environment.NewLine;
break;
}
}
cell.OutputHTML +=
" </select>" + Environment.NewLine +
" <input type='hidden' id='url_" + rs["dgflowid"].ToString() + "' name='url_" + rs["dgflowid"].ToString() + "' value='" + rs["reviewerurl"].ToString() + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("?")) + "'>" + Environment.NewLine +
" </td>" + Environment.NewLine +
" </tr>" + Environment.NewLine +
" </table>" + Environment.NewLine +
"</div>" + Environment.NewLine;
}
else
{
cell.OutputHTML = "<div id='div_" + rs["reviewerurl"].ToString() + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("?")) + "'> 審核中... </div>";
}
}
else
{
cell.CellStyle += "\" align=\"center\"><none a=\"a";
cell.OutputHTML = "--";
}
}
}
catch (Exception ex)
{
Response.Write(ex);
Response.End();
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_edit")
{
//cell.LinkURL = "AXMT610Edit.aspx?id="+rs["id"].ToString();
if ((rs["STATUS"].ToString() == "完成審核") || (rs["STATUS"].ToString() == "V"))
{
cell.OutputHTML = " ";
}
else
{
cell.OutputHTML = "<a href=\"AXMT610Edit.aspx?id=" + rs["id"].ToString() + "\"><img src=\"/Lib/Img/icon-edit.gif\" border=\"0\"></a>";
}
}
if (column.ID == "DataList1_view")
{
cell.OutputHTML = "<a href=\"AXMT610View.aspx?id=" + rs["id"].ToString() + "\"><img src=\"/Lib/Img/icon-zoom.gif\" border=\"0\"></a>";
}
if (column.ID == "DataList1_status")
{
if (rs["status"].ToString() == "N")
{
cell.OutputHTML = "<font color=\"orange\">未送審</font>" + "<img src=\"/flowwork/img/icon-senddoc.gif\" border=\"0\">";
}
if (rs["status"].ToString() == "Y")
{
cell.OutputHTML = "<font color=\"green\">送審中</font>" + "<img src=\"/Lib/Img/icon-go.gif\" border=\"0\">";
}
if (rs["status"].ToString() == "V")
{
cell.OutputHTML = "作廢" + "<img src=\"/ManagePDF/images/delete.gif\" border=\"0\">";
}
if (rs["status"].ToString() == "完成審核")
{
cell.OutputHTML = "<font color=\"blue\">完成審核</font>" + "<img src=\"/ManagePDF/images/icon-agree.gif\" border=\"0\">";
}
if (rs["status"].ToString() == "退回")
{
cell.OutputHTML = "<font color=\"red\">退回</font>" + "<img src=\"/ManagePDF/images/icon-reject.gif\" border=\"0\">";
}
}
if (column.ID == "DataList1_pro")
{
//cell.OutputHTML = "<a href=AttachDownload.aspx?hid=" + rs["requesturl"].ToString() + "\"><img src=\"/Lib/Img/icon-image.gif\" border=\"0\"></a>";
//cell.OutputHTML = "<a target=\"_blank\" href=http://eip.minaik.com.tw/ERP_AXMT610/FileDownload.aspx?atnu=1&hid=" + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("=") + 1, 36) + "\"> aa </a>" + "<a target=\"_blank\" href=http://eip.minaik.com.tw/ERP_AXMT610/FileDownload.aspx?atnu=1&hid=" + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("=") + 1, 36) + "\"> aa </a>";
string output = "";
SmoothEnterprise.Database.DataSet rs2 = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rs2.Open("SELECT id,FileName FROM axmt610_File WHERE FileKey='" + rs["id"].ToString() + "'");
while (!rs2.EOF)
{
output = output + "<a target=\"_blank\" href=http://eip.minaik.com.tw/ERP_AXMT610/FileDownload.aspx?id=" + rs2["id"].ToString() + "\"> " + rs2["FileName"].ToString() + " </a>" + "<br><br>";
rs2.MoveNext();
}
rs2.Close();
if (output.ToString().Length == 0)
{
output = "---";
}
cell.OutputHTML = output.ToString();
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_edit")
{
if (this.CurrentUser.ID.ToString().Substring(1, 36) == rs["add_user2"].ToString().ToUpper() && rs["status"].ToString() != "V")
{
cell.OutputHTML = "<a href=\"EngineeringTestEdit.aspx?id=" + rs["id"].ToString() + "\"><img src=\"/Lib/Img/icon-edit.gif\" border=\"0\"></a>";
}
else
{
cell.OutputHTML = " ";
}
}
if (column.ID == "DataList1_makes_no")
{
cell.OutputHTML = "<a href=\"EngineeringTestReport.aspx?id=" + rs["id"].ToString() + "\">" + rs["makes_no"].ToString() + "</a>";
}
if (column.ID == "DataList1_view")
{
cell.LinkURL = "EngineeringTestView.aspx?id=" + rs["id"].ToString();
}
//列印小卡
if (column.ID == "DataList1_print")
{
//if (rs["status"].ToString() == "完成審核")
//{
cell.OutputHTML = "<a target='_new' href=\"http://rs.minaik.com.tw/MBCS_report/MBCS_report_page.aspx?id=" + rs["id"].ToString() + "\"><img src=\"/ManagePDF/images/File.gif\" border=\"0\"></a>";
//}
//cell.LinkURL = "EngineeringTestView.aspx?id=" + rs["id"].ToString();
}
if (column.ID == "DataList1_status")
{
if (rs["status"].ToString() == "N")
{
cell.OutputHTML = "<font color=\"orange\">未送審</font>" + "<img src=\"./Image/icon-senddoc.gif\" border=\"0\">";
}
if (rs["status"].ToString() == "Y")
{
cell.OutputHTML = "<font color=\"green\">送審中</font>" + "<img src=\"./Image/icon-go.gif\" border=\"0\">";
}
if (rs["status"].ToString() == "V")
{
cell.OutputHTML = "作廢" + "<img src=\"./Image/delete.gif\" border=\"0\">";
}
if (rs["status"].ToString() == "完成審核")
{
cell.OutputHTML = "<font color=\"blue\">完成審核</font>" + "<img src=\"./Image/icon-agree.gif\" border=\"0\">";
}
if (rs["status"].ToString() == "退回")
{
cell.OutputHTML = "<font color=\"red\">退回</font>" + "<img src=\"./Image/icon-reject.gif\" border=\"0\">";
}
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "edit")
{
string html = string.Format("<a href='StandardEdit.aspx?rowid={0}'><img src='/Lib/img/icon-edit.gif' border='0'></a>", rs["rowid"]);
cell.OutputHTML = html;
}
if (column.ID == "del")
{
cell.OutputHTML = "<input type=\"checkbox\" name=\"del_" + rs["rowid"].ToString() + "\" value=\"" + rs["rowid"].ToString() + "\" />";
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_edit")
{
cell.LinkURL = "ForwarderiniEdit.aspx?ID=" + rs["ID"].ToString();
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_edit")
{
cell.LinkURL = "APMI610Edit.aspx?rowid=" + rs["rowid"].ToString();
}
if (column.ID == "DataList1_view")
{
cell.LinkURL = "APMI610View.aspx?rowid=" + rs["rowid"].ToString();
}
if (column.ID == "DataColumn3")
{
if (rs["ERPCheck"].ToString() == "Y")
{
cell.OutputHTML = "<font color=\"red\">有</font>";
}
else
{
cell.OutputHTML = "<font color=\"Black\">無</font>";
}
}
if (column.ID == "DataColnmApp")
{
//審者人員
StringBuilder sb = new StringBuilder();
sb.Append(" SELECT u.name ");
sb.Append(" FROM eipa.[dbo].dgflowqueue f ");
sb.Append(" left join eipa.dbo.dguser u on f.revieweruid=u.id ");
sb.Append(" where revieweruid !='00000000-0000-0000-0000-000000000000' ");
sb.AppendFormat(" and requesturl like '%{0}' ", rs["rowid"]);
sb.Append(" and resulttype is null ");
//cell.OutputHTML = Utility.getSingle(sb.ToString());
}
if (column.ID == "TDataColumn1")
{
if (rs["pmca00"].ToString().Substring(0, 1).ToUpper() == "I")
{
switch (rs["RepReason"].ToString())
{
case "1":
cell.Value = "價格優勢";
break;
case "2":
cell.Value = "交期優勢";
break;
case "3":
cell.Value = "服務優勢";
break;
case "4":
cell.Value = "客戶指定";
break;
case "5":
cell.Value = "唯一供應商";
break;
case "X":
cell.Value = "其他";
break;
}
}
else
{
switch (rs["RepReason"].ToString())
{
case "1":
cell.Value = "銀行資料變更";
break;
case "2":
cell.Value = "付款條件變更";
break;
case "X":
cell.Value = "其他";
break;
}
}
}
if (column.ID == "DataList1_status")
{
if (rs["status"].ToString() == "N")
{
cell.OutputHTML = "<img src=\"/flowwork/img/icon-senddoc.gif\" border=\"0\">" + "<font color=\"orange\">未送審</font>";
}
if (rs["status"].ToString() == "Y")
{
cell.OutputHTML = "<img src=\"/Lib/Img/icon-go.gif\" border=\"0\">" + "<font color=\"green\">送審中</font>";
}
if (rs["status"].ToString() == "V")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/delete.gif\" border=\"0\">" + "作廢";
}
if (rs["status"].ToString() == "C")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/icon-agree.gif\" border=\"0\">" + "<font color=\"blue\">完成審核</font>";
}
if ((rs["status"].ToString() == "T") || (rs["status"].ToString() == "R"))
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/icon-reject.gif\" border=\"0\">" + "<font color=\"red\">退回</font>";
}
if (rs["status"].ToString() == "E")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/icon-reject.gif\" border=\"0\">" + "<font color=\"red\">退回至ERP</font>";
}
}
User_Info u = new User_Info();
u.GetdgUsererPid(rs["pmcauser"].ToString());
//DataList1_pmcauser
if (column.ID == "DataList1_pmcauser")
{
cell.Value = u.NAME;
}
if (column.ID == "DataList1_pmcagrup")
{
cell.Value = u.DEPT;
}
}
catch (Exception ex)
{
Utility.log(ex.Message, ex.StackTrace.ToString());
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataColumn21")
{
string paperstring = "";
SmoothEnterprise.Database.DataSet rss = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rss.Open(" SELECT lcaption paper from " + db1 + "Shipment_paper left join " + db1 + "NPI_Base_file on shipment_paper_id=lid " +
" where aid='" + rs["id"].ToString() + "' and item='" + rs["item"].ToString() + "' and tid='P' and lacti='Y' ");
while (!rss.EOF)
{
paperstring = paperstring + rss["paper"].ToString() + " , ";
rss.MoveNext();
}
rss.Close();
if (paperstring.ToString().Length > 0)
{
cell.OutputHTML = paperstring.Substring(0, paperstring.Length - 2);
}
else
{
cell.OutputHTML = " ";
}
}
if (column.ID == "DataColumn22")
{
string packingstring = "";
packingstring = rs["packing"].ToString().Replace("NW/GW:", "<BR>NW/GW:");
packingstring = packingstring.Replace("CARTON QTY:", "<BR>CARTON QTY:");
packingstring = packingstring.Replace("VIA:", "<BR>VIA:");
packingstring = packingstring.Replace("Attn to:", "<BR>Attn to:");
cell.OutputHTML = packingstring;
cell.Value = "";
}
if (column.ID == "DataColumn27")
{
if (rs["npiname"].ToString() == "")
{
cell.Value = rs["cname"].ToString();
}
}
if (column.ID == "Lab_NO")
{
string html = "NA";
if (!string.IsNullOrEmpty(rs["lab_no"].ToString()))
{
SmoothEnterprise.Database.DataSet rsb = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rsb.Open("select rowid,SamDescription from EIPA.dbo.Experiment_head_file WHERE no='" + rs["lab_no"].ToString() + "' ");
int i = 1;
while (!rsb.EOF)
{
string s = rsb["SamDescription"].ToString();
string x = rsb["SamDescription"].ToString();
if (s.Length > 10)
{
x = s.Substring(0, 10) + "...";
}
html += "<p>" + i.ToString() + ".<a href=\"http://eip.minaik.com.tw/experiment/StaExperimentShow.aspx?rowid=" + rsb["rowid"].ToString() + " \" target= '_BLANK'>" + rs["lab_no"].ToString() + "</a></p> ";
i++;
rsb.MoveNext();
}
}
cell.OutputHTML = html;
}
if (column.ID == "DataColumn32")
{
string testno = rs["EngineeringTest_no"].ToString();
cell.OutputHTML = "<a href=\"http://eip.minaik.com.tw/EngineeringTest/EngineeringTestView.aspx?id=" + rs["gid"].ToString() + " \" target= '_BLANK'>" + testno + "</a>";
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_approval")
{
cell.LinkURL = rs["reviewerurl"].ToString() + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("?"));
}
if (column.ID == "DataList1_view")
{
cell.LinkURL = "MyApprovalView.aspx?id=" + rs["id"].ToString();
}
if (column.ID == "DataList1_popupflowview")
{
System.Web.UI.WebControls.Image ib = (System.Web.UI.WebControls.Image) this.DataList1.Columns.GetItem("DataList1_popupflowview").GetControl("IB_popupflowview");
ib.Attributes.Add("onclick", GetOnclickScript(ResolveUrl("~/"), rs["RequestUrl"].ToString()));
ib.Style.Add("cursor", "hand");
}
if (column.ID == "DataColumn8")
{
cell.Value = rs["Reason_user"].ToString();
}
if (column.ID == "DataColumn9")
{
cell.Value = rs["Improve_user"].ToString();
}
if (column.ID == "DataColumn10")
{
cell.Value = rs["Reason_salse"].ToString();
}
if (column.ID == "DataColumn11")
{
cell.Value = rs["Improve_salse"].ToString();
}
if (column.ID == "DataList1_pro")
{
//cell.OutputHTML = "<a href=AttachDownload.aspx?hid=" + rs["requesturl"].ToString() + "\"><img src=\"/Lib/Img/icon-image.gif\" border=\"0\"></a>";
//cell.OutputHTML = "<a target=\"_blank\" href=http://eip.minaik.com.tw/ERP_AXMT610/FileDownload.aspx?atnu=1&hid=" + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("=") + 1, 36) + "\"> aa </a>" + "<a target=\"_blank\" href=http://eip.minaik.com.tw/ERP_AXMT610/FileDownload.aspx?atnu=1&hid=" + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("=") + 1, 36) + "\"> aa </a>";
string output = "";
SmoothEnterprise.Database.DataSet rs2 = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rs2.Open("SELECT id,FileName FROM axmt610_File WHERE FileKey='" + rs["eid"].ToString() + "'");
while (!rs2.EOF)
{
output = output + "<a target=\"_blank\" href=http://eip.minaik.com.tw/ERP_AXMT610/FileDownload.aspx?id=" + rs2["id"].ToString() + "\"> " + rs2["FileName"].ToString() + " </a>" + "<br><br>";
rs2.MoveNext();
}
rs2.Close();
if (output.ToString().Length == 0)
{
output = "---";
}
cell.OutputHTML = output.ToString();
}
if (column.ID == "DataList1_multiapproval")
{
bool EndbledMultiApproval = false;
string[] ResultTypes = new string[0];
string classname = "";
try
{
classname = SmoothEnterprise.Web.Page.InheritsClass(rs["reviewerurl"].ToString());
System.Type FlowViewType = SmoothEnterprise.Utility.Type.GetType(classname);
Object obj = FlowViewType.InvokeMember(null, System.Reflection.BindingFlags.CreateInstance, null, null, null);
ResultTypes = (string[])FlowViewType.InvokeMember("MultiApproval_ResultTypes", System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Default | System.Reflection.BindingFlags.GetProperty, null, obj, null);
EndbledMultiApproval = (ResultTypes.Length > 0);
}
catch
{
EndbledMultiApproval = false;
}
if (rs["reviewdate"] == DBNull.Value && EndbledMultiApproval)
{
if (Global.iVars.ToString() == "0")
{
cell.OutputHTML =
"<div id='div_" + rs["reviewerurl"].ToString() + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("?")) + "' style=\"white-space:nowrap\">" + Environment.NewLine +
" <table>" + Environment.NewLine +
" <tr>" + Environment.NewLine +
" <td width=\"1px\">" + Environment.NewLine +
" <input type='checkbox' id='chk_multiapproval' name='chk_multiapproval' checked = 'true' value='" + rs["id"].ToString() + "'>" + Environment.NewLine +
" </td>" + Environment.NewLine +
" <td>" + Environment.NewLine +
" <select id='resulttype_" + rs["id"].ToString() + "' name='resulttype_" + rs["id"].ToString() + "' style=\"font-size:11px;\">" + Environment.NewLine;
for (int i = 0; i < ResultTypes.Length; i++)
{
switch (ResultTypes[i])
{
case "Next":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Next.ToString() + "\">允許</option>" + Environment.NewLine;
break;
case "Back":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Back.ToString() + "\">退回上一關</option>" + Environment.NewLine;
break;
case "Complete":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Complete.ToString() + "\">完成</option>" + Environment.NewLine;
break;
case "None":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.None.ToString() + "\">沒意見</option>" + Environment.NewLine;
break;
case "Return":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Return.ToString() + "\">退回重送</option>" + Environment.NewLine;
break;
case "Terminate":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Terminate.ToString() + "\">退回提案人</option>" + Environment.NewLine;
break;
}
}
cell.OutputHTML +=
" </select>" + Environment.NewLine +
" <input type='hidden' id='url_" + rs["id"].ToString() + "' name='url_" + rs["id"].ToString() + "' value='" + rs["reviewerurl"].ToString() + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("?")) + "'>" + Environment.NewLine +
" </td>" + Environment.NewLine +
" </tr>" + Environment.NewLine +
" </table>" + Environment.NewLine +
"</div>" + Environment.NewLine;
}
else
{
cell.OutputHTML = "<div id='div_" + rs["reviewerurl"].ToString() + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("?")) + "'> 審核中... </div>";
}
}
else
{
cell.CellStyle += "\" align=\"center\"><none a=\"a";
cell.OutputHTML = "--";
}
}
}
catch (Exception ex)
{
this.AddError(this, "", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, EventArgs e)
{
bool isDisplay = getEditUser();
if (isDisplay == false)
{
isDisplay = IPQC_RaBase.isManage;
}
if (column.ID.Contains("edit"))
{
cell.OutputHTML = "<a href=\"" + getEdit + "?rowid=" + rs["rowid"] + "&lab_id=" + rs["lab_id"] + "\"><img src=\"/Lib/Img/icon-edit.gif\" border=\"0\"></a>";
}
if (column.ID.Contains("view"))
{
cell.OutputHTML = "<a href=Lab/LabView.aspx?rowid=" + rs["rowid"] + "&lab_id=" + rs["lab_id"] + "><img src=\"/lib/img/icon-zoom.gif\" border=\"0\"></a>";
}
if (column.ID == "status")
{
//tranfer_status("0"), tranfer_status("1"), tranfer_status("2"), tranfer_status("3"), tranfer_status("4"), getStr("no_inspection")
string Action = rs["status"].ToString();
string html = "";
if (!string.IsNullOrEmpty(Action))
{
html = tranfer_status(Action);
}
else
{
html = "<div style=\"color:red\" >" + getStr("no_inspection") + "</div>";
}
cell.OutputHTML = html;
}
if (column.ID == "result")
{
string show = "";
if (!string.IsNullOrEmpty(rs["result"].ToString()))
{
if (rs["status"].ToString() == "3") //¼f®Ö§¹²¦
{
bool isPass = (bool)rs["result"];
if (isPass)
{
show = "<font color=\"green\" >PASS</font>";
}
else
{
show = "<font color=\"red\" >FAIL</font>";
}
}
}
cell.OutputHTML = show;
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_edit")
{
cell.OutputHTML = "<a href=\"OptionEdit.aspx?rowid=" + rs["rowid"].ToString() + "\"><img src=\"/Lib/Img/icon-edit.gif\" border=\"0\"></a>";
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_edit")
{
if (rs["inituser"].ToString().ToUpper().Contains(this.CurrentUser.ID.ToUpper().Replace("{", "").Replace("}", "")) || ismanergement(this.CurrentUser.ID))
{
cell.OutputHTML = "<a href=\"IPQCEdit.aspx?ROWNO=" + rs["ROWNO"].ToString() + "\"><img src=\"/PManagement/images/Edit.gif\" border=\"0\" Alt=修改></a>";
}
if (Utility.MIS_Manager(CurrentUser.LogonID))
{
cell.OutputHTML = "<a href=\"IPQCEdit.aspx?ROWNO=" + rs["ROWNO"].ToString() + "\"><img src=\"/PManagement/images/Edit.gif\" border=\"0\" Alt=修改></a>";
}
}
if (column.ID == "DataList1_view")
{
cell.LinkURL = "IPQCView.aspx?ROWNO=" + rs["ROWNO"].ToString();
}
if (column.ID == "DataList1_isState")
{
//Start = 0, Run = 1, End = 2, Stop = 3, Origin = 4
try
{
int istatus = Convert.ToInt16(rs["isState"]);
cell.Value = Utility.chnageStatus(istatus.ToString(), CurrLang);
}
catch (Exception ex)
{
cell.Value = rs["isState"].ToString();
}
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "edit")
{
cell.LinkURL = "UserCompanyEdit.aspx?id=" + rs["id"].ToString();
}
if (column.ID == "DataList1_iconview")
{
cell.LinkURL = "UserProfile.aspx?id=" + rs["id"].ToString();
}
if (column.ID == "chk")
{
string str = "id" + cell.Rowno.ToString() + "=" + rs["id"].ToString();
cell.ClientID = this.DataList1.ID + "_chk_" + cell.Rowno.ToString();
cell.OutputHTML = "<input type=hidden id=\"" + this.DataList1.ID + "_key_" + cell.Rowno.ToString() + "\" name=\"" + this.DataList1.ID + "_key_" + cell.Rowno.ToString() + "\" value=\"" + str + "\">";
}
if (column.ID == "DataList1_icon")
{
System.Web.UI.WebControls.Image image = (System.Web.UI.WebControls.Image)cell.Controls[1];
image.BorderWidth = Unit.Pixel(1);
image.ImageUrl = "UserImage.aspx?id=" + rs["id"].ToString();
}
if (column.ID == "DataList1_ustatus")
{
//Response.Write("<br>"+rs["ustatus"].ToString() );
if (rs["ustatus"].ToString().ToUpper() == "9F3FAF7E-F503-42B3-9E3F-62237024A20A")
{
//Response.Write("icon-config");
cell.OutputHTML = "<center><img src='/lib/img/icon-lock.gif'></center> ";
}
else if (rs["ustatus"].ToString().ToUpper() == "57DADAB8-44CF-4BAA-A40C-324F9F4533A9")
{
//Response.Write("icon-lookmore.gif");
cell.OutputHTML = "<center><img src='/lib/img/icon-config.gif'></center> ";
}
else if (rs["ustatus"].ToString().ToUpper() == "76CBA823-E891-45D3-8B6C-4724E6C69D5B")
{
// Response.Write("icon-new.gif");
cell.OutputHTML = "<center><img src='/lib/img/icon-new.gif'></center> ";
}
else
{
cell.OutputHTML = " ";
}
// else if (rs["ustatus"].ToString() == UStatus.Disable.ToString())
// { cell.OutputHTML = "<center><img src='/lib/img/icon-config.gif'></center> ";
// cell.OutputHTML = "<center><img src='/lib/img/icon-lock.gif'></center> ";
//cell.OutputHTML = "<center><img src='/lib/img/icon-lookmore.gif'></center> ";
// }
}
if (column.ID == "DataList1_gender")
{
if (rs["gender"].ToString() == "M")
{
cell.OutputHTML = "<center><img src='" + base.ResolveUrl("~/security/img/icon-boy.gif") + "'></center> ";
}
else if (rs["gender"].ToString() == "F")
{
cell.OutputHTML = "<center><img src='" + base.ResolveUrl("~/security/img/icon-girl.gif") + "'></center> ";
}
}
}
catch (Exception exception)
{
base.AddError(this, "", "", exception.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, EventArgs e)
{
if (column.ID.Contains("edit"))
{
cell.OutputHTML = "<a href=\"" + getEdit + "?rowid=" + rs["rowid"] + "\"><img src=\"/Lib/Img/icon-edit.gif\" border=\"0\"></a>";
}
if (column.ID.Contains("view"))
{
cell.OutputHTML = "<a href=\"" + getView + "?rowid=" + rs["rowid"] + "\"><img src=\"/lib/img/icon-zoom.gif\" border=\"0\"></a>";
}
if (column.ID == "status")
{
//tranfer_status("0"), tranfer_status("1"), tranfer_status("2"), tranfer_status("3"), tranfer_status("4"), getStr("no_inspection")
string Action = rs["status"].ToString();
string html = "";
if (!string.IsNullOrEmpty(Action))
{
html = tranfer_status(Action);
}
else
{
html = "<div style=\"color:red\" >" + getStr("no_inspection") + "</div>";
}
cell.OutputHTML = html;
cell.Value = "";
}
if (column.ID == "status2")
{
//tranfer_status("0"), tranfer_status("1"), tranfer_status("2"), tranfer_status("3"), tranfer_status("4"), getStr("no_inspection")
string Action = rs["status2"].ToString();
string html = "";
if (!string.IsNullOrEmpty(Action))
{
string lab_id = rs["lab_id"].ToString();
if (!string.IsNullOrEmpty(lab_id))
{
html = @"<a href=../ipqc_ra/lab/labview.aspx?rowid=" + rs["rowid"] + "&lab_id=" + rs["lab_id"] + " title='" + getStr("view2") + "' \">" + tranfer_status(Action) + "</a>";
}
}
else
{
html = "<div style=\"color:red\" >" + getStr("no_inspection") + "</div>";
}
cell.OutputHTML = html;
}
if (column.ID == "result")
{
string show = "";
if (!string.IsNullOrEmpty(rs["result"].ToString()))
{
//if (rs["status2"].ToString() == "3") //審核完畢
//{
// bool isPass = (bool)rs["result"];
// if (isPass)
// {
// show = "<font color=\"green\" >PASS</font>";
// }
// else
// {
// show = "<font color=\"red\" >FAIL</font>";
// }
//}
if (rs["status"].ToString() == "3") //審核完畢
{
int situation = (int)rs["result"];
if (situation == 0)
{
show = "<font color=\"red\" >FAIL</font>";
}
else if (situation == 1)
{
show = "<font color=\"green\" >PASS</font>";
}
else
{
show = "<font color=\"#FF9F1C\" >OOC</font>";
}
}
}
cell.OutputHTML = show;
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
if (column.ID.ToUpper().Contains("EDIT"))
{
cell.OutputHTML = "<a href=\"" + getEdit + "?rowid=" + rs["rowid"] + "\"><img src=\"/Lib/Img/icon-edit.gif\" border=\"0\"></a>";
}
//if (column.ID == "up")
//{
// string color = "#000000";
// if (!string.IsNullOrEmpty(rs["upper"].ToString()))
// {
// color = rs["upper"].ToString();
// }
// cell.Value = "<font color=\"" + color + " \" >" + rs["up"] + "</font>";
//}
//if (column.ID == "down")
//{
// string color = "#000000";
// if (!string.IsNullOrEmpty(rs["lower"].ToString()))
// {
// color = rs["lower"].ToString();
// }
// cell.Value = "<font color=\"" + color + " \" >" + rs["down"] + "</font>";
//}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_chk")
{
string keys = "ROWNO" + cell.Rowno.ToString() + "=" + rs["ROWNO"].ToString();
cell.ClientID = "DataList1_chk_" + cell.Rowno.ToString();
cell.OutputHTML = "<input type=hidden id=\"DataList1_key_" + cell.Rowno.ToString() + "\" name=\"DataList1_key_" + cell.Rowno.ToString() + "\" value=\"" + keys + "\">";
}
if (column.ID == "DataList1_edit")
{
string owner = rs["USERID"].ToString().ToUpper();
if (CurrentUser.ID.ToUpper().Contains(owner))
{
//isStop
if (rs["IsState"].ToString().Trim() != "Complete" && rs["IsState"].ToString().Trim() != "isStop")
{
cell.OutputHTML = "<a href=\"ERP_AXMI25Edit.aspx?ROWNO=" + rs["ROWNO"].ToString() + "\"><img src=\"/ManagePDF/images/Edit.gif\" border=\"0\" Alt=修改></a>";
}
}
if (Utility.MIS_Manager(CurrentUser.LogonID))
{
cell.OutputHTML = "<a href=\"ERP_AXMI25Edit.aspx?ROWNO=" + rs["ROWNO"].ToString() + "\"><img src=\"/ManagePDF/images/Edit.gif\" border=\"0\" Alt=修改></a>";
}
//string userid = "{" + rs["USERID"].ToString().ToUpper() + "}";
//bool isuser=this.CurrentUser.ID.ToUpper().Contains(userid);
//if (this.CurrentUser.ID.ToUpper().Contains(userid) )
//{
// if (rs["IsState"].ToString().Trim() == "waiting" || rs["IsState"].ToString() == "Terminate" || rs["IsState"].ToString().Trim() == "isSend")
// cell.OutputHTML = "<a href=\"ERP_AXMI25Edit.aspx?ROWNO=" + rs["ROWNO"].ToString() + "\"><img src=\"/ManagePDF/images/Edit.gif\" border=\"0\" Alt=修改></a>";
//}
//if (Utility.MIS_Manager(CurrentUser.LogonID))
//{
// if (rs["IsState"].ToString().Trim() == "waiting" || rs["IsState"].ToString() == "Terminate" || rs["IsState"].ToString().Trim() == "isSend")
// cell.OutputHTML = "<a href=\"ERP_AXMI25Edit.aspx?ROWNO=" + rs["ROWNO"].ToString() + "\"><img src=\"/ManagePDF/images/Edit.gif\" border=\"0\" Alt=修改></a>";
//}
//// cell.LinkURL = "ERP_AXMI25Edit.aspx?ROWNO=" + rs["ROWNO"].ToString();
////else
// cell.Clear();
}
if (column.ID == "DataList1_view")
{
cell.LinkURL = "ERP_AXMI25View.aspx?ROWNO=" + rs["ROWNO"].ToString();
}
if (column.ID == "DataList1_IsStatus")
{
if (rs["IsState"].ToString().Trim() == "waiting")
{
cell.OutputHTML = "未送審";
}
if (rs["IsState"].ToString().Trim() == "Complete")
{
cell.OutputHTML = "<font color=blue>審核完成</font><img src=\"/ManagePDF/images/icon-agree.gif\" border=\"0\">";
}
if (rs["IsState"].ToString().Trim() == "Terminate")
{
cell.OutputHTML = "<font color=red>退回</font><img src=\"/ManagePDF/images/icon-reject.gif\" border=\"0\">";
}
if (rs["IsState"].ToString().Trim() == "isSend")
{
cell.OutputHTML = "<font color=green>送審中</font><img src=\"/ManagePDF/images/icon-senddoc.gif\" border=\"0\">";
}
if (rs["IsState"].ToString().Trim() == "isStop")
{
cell.OutputHTML = "<font color=red>退回ERP</font><img src=\"/ManagePDF/images/delete.gif\" border=\"0\" Alt=退回ERP>";
}
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_edit")
{
if ((rs["STATUS"].ToString() == "OK") || (rs["STATUS"].ToString() == "V"))
{
cell.OutputHTML = " ";
}
else
{
if (rs["add_user"].ToString().ToUpper() == this.CurrentUser.ID.ToString().Substring(1, 36) & rs["status"].ToString() != "V")
{
if (rs["class_no"].ToString().Trim() == "1")
{
cell.OutputHTML = "<a href=\"cimi100_NewEdit.aspx?id=" + rs["id"].ToString() + "\"><img src=\"/Lib/Img/icon-edit.gif\" border=\"0\"></a>";
}
else
{
cell.OutputHTML = "<a href=\"cimi100_turnEdit.aspx?id=" + rs["id"].ToString() + "&class_no=" + rs["class_no"].ToString() + "\"><img src=\"/Lib/Img/icon-edit.gif\" border=\"0\"></a>";
}
}
else
{
cell.OutputHTML = " ";
}
}
}
if (column.ID == "DataList1_view")
{
if (rs["class_no"].ToString().Trim() == "1")
{
cell.LinkURL = "cimi100_newView.aspx?id=" + rs["id"].ToString();
}
else
{
cell.LinkURL = "cimi100_turnView.aspx?id=" + rs["id"].ToString() + "&class_no=" + rs["class_no"].ToString();
}
}
if (column.ID == "DataList1_status")
{
if (rs["status"].ToString() == "N")
{
cell.OutputHTML = "<img src=\"/flowwork/img/icon-senddoc.gif\" border=\"0\">" + "<font color=\"orange\">未送審</font>";
}
if (rs["status"].ToString() == "Y")
{
cell.OutputHTML = "<img src=\"/Lib/Img/icon-go.gif\" border=\"0\">" + "<font color=\"green\">送審中</font>";
}
if (rs["status"].ToString() == "V")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/delete.gif\" border=\"0\">" + "作廢";
}
if (rs["status"].ToString() == "OK")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/icon-agree.gif\" border=\"0\">" + "<font color=\"blue\">完成審核</font>";
}
if (rs["status"].ToString() == "NO")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/icon-reject.gif\" border=\"0\">" + "<font color=\"red\">退回提案人</font>";
}
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_chk")
{
string keys = "ID" + cell.Rowno.ToString() + "=" + rs["ID"].ToString();
cell.ClientID = "DataList1_chk_" + cell.Rowno.ToString();
cell.OutputHTML = "<input type=hidden id=\"DataList1_key_" + cell.Rowno.ToString() + "\" name=\"DataList1_key_" + cell.Rowno.ToString() + "\" value=\"" + keys + "\">";
}
if (column.ID == "DataList1_edit")
{
if (rs["IsStatus"].ToString().Trim() == "Complete")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/Lock.jpg\" border=\"0\">";
}
else
{
cell.OutputHTML = "<a href=\"ForwarderEdit.aspx?ID=" + rs["ID"].ToString() + "\"><img src=\"/ManagePDF/images/Edit.gif\" border=\"0\" Alt=修改></a>";
}
}
if (column.ID == "DataList1_edit2")
{
if (rs["IsStatus"].ToString().Trim() == "Complete")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/Lock.jpg\" border=\"0\">";
}
else
{
cell.OutputHTML = "<a href=\"ForwarderEdit.aspx?ID=" + rs["ID"].ToString() + "\"><img src=\"/Shipping/images/Edit.gif\" border=\"0\" Alt=修改></a>";
}
}
if (column.ID == "DataList1_Send" || column.ID == "DataList1_Send2")
{
cell.OutputHTML = "<a href=\"SendXml.aspx?ID=" + rs["ID"].ToString() + "\" Onclick=\"return confirm('出貨單號：" + rs["ERP_Key"].ToString() + " \\n確定重新上傳給 Forwarder 嗎?');\" ><img src=\"/Shipping/images/Up.gif\" border=\"0\" Alt=重新上傳></a>";
}
if (column.ID == "DataList1_Xml")
{
cell.OutputHTML = "<img src=\"/Shipping/images/Xml.png\" border=\"0\" Alt=\"接收狀況\" width=\"20\" style=\"cursor:hand\" Onclick=\"window.showModalDialog('ShowTime.aspx?INV=" + rs["INV_Num"].ToString() + "',self,'scrollbars=yes,width=800,height=200,top=150,left=450');\">";
}
if (column.ID == "DataList1_view")
{
cell.LinkURL = "ForwarderView.aspx?ID=" + rs["ID"].ToString();
}
if (column.ID == "DataColumn_IsStatus")
{
if (rs["IsStatus"].ToString().Trim() == "waiting")
{
cell.OutputHTML = "未送審";
}
if (rs["IsStatus"].ToString().Trim() == "Complete")
{
cell.OutputHTML = "<font color=blue>完成審核</font><img src=\"/Shipping/images/icon-agree.gif\" border=\"0\">";
}
if (rs["IsStatus"].ToString().Trim() == "Terminate")
{
cell.OutputHTML = "<font color=red>完成審核</font><img src=\"/Shipping/images/icon-reject.gif\" border=\"0\">";
}
if (rs["IsStatus"].ToString().Trim() == "isSend")
{
cell.OutputHTML = "<font color=green>送審中</font><img src=\"/Shipping/images/icon-senddoc.gif\" border=\"0\">";
}
if (rs["IsStatus"].ToString().Trim() == "isStop")
{
cell.OutputHTML = "作廢<img src=\"/Shipping/images/delete.gif\" border=\"0\" Alt=作廢>";
}
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_edit")
{
if ((rs["STATUS"].ToString() == "OK") || (rs["STATUS"].ToString() == "V"))
{
cell.OutputHTML = " ";
}
else
{
if ((rs["add_user"].ToString().ToUpper() == this.CurrentUser.ID.ToString().Substring(1, 36) || rs["npiid"].ToString().ToUpper() == this.CurrentUser.ID.ToString().Substring(1, 36)) & rs["status"].ToString() != "V")
{
cell.OutputHTML = "<a href=\"ShipmentEdit.aspx?id=" + rs["id"].ToString() + "\"><img src=\"/Lib/Img/icon-edit.gif\" border=\"0\"></a>";
}
else
{
//代理人可修改使用者單據
SmoothEnterprise.Database.DataSet rs2 = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rs2.Open("SELECT b.id bid,b.name name,email FROM " +
" dguserdeputy a " +
" left join dguser b on a.deputyuid=b.id " +
" left join dgflow c on a.sid=c.id " +
" where a.uid='" + rs["add_user"].ToString().ToUpper() + "' " +
" and " +
" ((a.sid is null and sdate < GETDATE() and edate is null) or " +
" (c.typename = 'sharflow12_21' and sdate < GETDATE() and edate is null) or " +
" (c.typename = 'sharflow12_21' and sdate < GETDATE() and edate > GETDATE()) or " +
" a.sid is null and sdate < GETDATE() and edate > GETDATE()) group by b.name,email,b.id");
if (!rs2.EOF)
{
if (rs2["bid"].ToString().ToUpper() == this.CurrentUser.ID.ToString().Substring(1, 36))
{
cell.OutputHTML = "<a href=\"ShipmentEdit.aspx?id=" + rs["id"].ToString() + "\"><img src=\"/Lib/Img/icon-edit.gif\" border=\"0\"></a>";
}
else
{
cell.OutputHTML = " ";
}
}
else
{
cell.OutputHTML = " ";
}
}
}
}
if (column.ID == "DataList1_view")
{
cell.LinkURL = "ShipmentView.aspx?id=" + rs["id"].ToString();
}
if (column.ID == "DataList1_copy")
{
cell.OutputHTML = "<a href=\"ShipmentAdd.aspx?id=" + rs["id"].ToString() + "©a=2\" ><img src=\"/shipment/img/page_copy.png\" border=\"0\"></a>";
}
if (column.ID == "DataList1_Other")
{
//NPI工程師及助理維護
if ((rs["STATUS"].ToString() == "OK"))
{
//SmoothEnterprise.Database.DataSet rs2 = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
//rs2.Open("select * from " + db2 + "dgflowlog where requesturl like '%" + rs["id"].ToString() + "' " +
// "and text in ('NPI Engineer','NPI Assistant') and revieweruid='" + this.CurrentUser.ID.ToString() + "'");
//if (!rs2.EOF)
//{
SmoothEnterprise.Database.DataSet rss = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rss.Open(" SELECT no,MAX(ver) as ver from " + db1 + "Shipment_head where no='" + rs["NO"].ToString() + "' group by no ");
if (rss["ver"].ToString() == rs["ver"].ToString())
{
cell.OutputHTML = "<a href=\"ShipmentView.aspx?id=" + rs["id"].ToString() + "&other=1\" ><img src=\"/shipment/img/note_edit.png\" border=\"0\"></a>";
}
else
{
cell.OutputHTML = " ";
}
//}
//else
//{
// //if (this.CurrentUser.LogonID.ToString() == "ann.lin")
// //{
// // cell.OutputHTML = "<a href=\"ShipmentView.aspx?id=" + rs["id"].ToString() + "&other=1\" ><img src=\"/shipment/img/note_edit.png\" border=\"0\"></a>";
// //}
// //else
// //{
// // cell.OutputHTML = " ";
// //}
//}
}
else
{
cell.OutputHTML = " ";
}
}
if (column.ID == "DataList1_Change")
{
if ((rs["STATUS"].ToString() == "OK")) //必須要完成審核, 且ver為最新
{
SmoothEnterprise.Database.DataSet rss = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rss.Open(" SELECT no,MAX(ver) as ver from " + db1 + "Shipment_head where no='" + rs["NO"].ToString() + "' group by no ");
if (!rss.EOF)
{
if (rss["ver"].ToString() == rs["ver"].ToString())
{
cell.OutputHTML = "<a href=\"ShipmentAdd.aspx?ID=" + rs["id"].ToString() + "©a=1\"><img src=\"/shipment/img/page_refresh.png\" border=\"0\"></a>";
}
else
{
cell.OutputHTML = " ";
}
}
}
else
{
cell.OutputHTML = " ";
}
}
if (column.ID == "DataList1_print")
{
if ((rs["STATUS"].ToString() != "V"))
{
SmoothEnterprise.Database.DataSet rss = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rss.Open(" SELECT no,MAX(ver) as ver from " + db1 + "Shipment_head where no='" + rs["NO"].ToString() + "' group by no ");
if (!rss.EOF)
{
if (rss["ver"].ToString() == rs["ver"].ToString())
{
cell.OutputHTML = "<a href=\"Shipment_print.aspx?id=" + rs["id"].ToString() + "\" ><img src=\"/shipment/img/printer.png\" border=\"0\"></a>";
}
else
{
cell.OutputHTML = " ";
}
}
}
else
{
cell.OutputHTML = " ";
}
}
if (column.ID == "DataList1_Component")
{
string paperstring = "";
SmoothEnterprise.Database.DataSet rss = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rss.Open(" select Component from " + db1 + "shipment_body where no='" + rs["no"].ToString() + "' and ver='" + rs["ver"].ToString() + "' group by Component ");
while (!rss.EOF)
{
paperstring = paperstring + rss["Component"].ToString() + " , ";
rss.MoveNext();
}
rss.Close();
if (paperstring.ToString().Length > 0)
{
cell.OutputHTML = paperstring.Substring(0, paperstring.Length - 2);
}
else
{
cell.OutputHTML = " ";
}
// Response.Write(" select component from " + db1 + "shipment_body where no='" + rs["no"].ToString() + "' and ver='" + rs["ver"].ToString() + "' group by component ");
}
if (column.ID == "DataList1_status")
{
if (rs["status"].ToString() == "N")
{
cell.OutputHTML = "<img src=\"/flowwork/img/icon-senddoc.gif\" border=\"0\">" + "<font color=\"orange\">未送審</font>";
}
if (rs["status"].ToString() == "Y")
{
cell.OutputHTML = "<img src=\"/Lib/Img/icon-go.gif\" border=\"0\">" + "<font color=\"green\">送審中</font>";
}
if (rs["status"].ToString() == "V")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/delete.gif\" border=\"0\">" + "作廢";
}
if (rs["status"].ToString() == "OK")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/icon-agree.gif\" border=\"0\">" + "<font color=\"blue\">完成審核</font>";
}
if (rs["status"].ToString() == "NO")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/icon-reject.gif\" border=\"0\">" + "<font color=\"red\">退回提案人</font>";
}
//if (rs["status"].ToString() == "ERP")
//{
// cell.OutputHTML = "<img src=\"/ManagePDF/images/icon-reject.gif\" border=\"0\">"+"<font color=\"red\">退回ERP修改</font>" ;
//}
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_Status")
{
if (rs["status"].ToString() == "N")
{
cell.OutputHTML = "<img src=\"/flowwork/img/icon-senddoc.gif\" border=\"0\">" + "<font color=\"orange\">未送審</font>";
}
if (rs["status"].ToString() == "Y")
{
cell.OutputHTML = "<img src=\"/Lib/Img/icon-go.gif\" border=\"0\">" + "<font color=\"green\">送審中</font>";
}
if (rs["status"].ToString() == "V")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/delete.gif\" border=\"0\">" + "作廢";
}
if (rs["status"].ToString() == "C")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/icon-agree.gif\" border=\"0\">" + "<font color=\"blue\">完成審核</font>";
}
if (rs["status"].ToString() == "T")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/icon-reject.gif\" border=\"0\">" + "<font color=\"red\">退回</font>";
}
if (rs["status"].ToString() == "E")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/icon-reject.gif\" border=\"0\">" + "<font color=\"red\">退回至ERP</font>";
}
}
if (column.ID == "DataColnm")
{
if ((rs["status"].ToString().Trim() == "Y") || (rs["status"].ToString().Trim() == "R"))
{
cell.Value = rs["name"].ToString();
}
}
if (column.ID == "DataList1_edit")
{
//Response.Write(this.CurrentUser.Name + "--<br>");
if ((rs["status"].ToString() == "C") || (this.CurrentUser.Name != rs["gen02_1"].ToString().ToUpper()))
{
cell.OutputHTML = " ";
}
else
{
cell.OutputHTML = "<a href=\"CBGI014Edit.aspx?rowid=" + rs["rowid"].ToString() + "\"><img src=\"/Lib/Img/icon-edit.gif\" border=\"0\"></a>";
}
}
if (column.ID == "DataList1_view")
{
if (rs["tc_cba02"].ToString().Substring(0, 1) == "1")
{
cell.LinkURL = "CBGI014View.aspx?rowid=" + rs["rowid"].ToString();
}
else
{
cell.LinkURL = "CBGI014_ACCView.aspx?rowid=" + rs["rowid"].ToString();
}
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_chk")
{
string keys = "ROWNO" + cell.Rowno.ToString() + "=" + rs["ROWNO"].ToString();
cell.ClientID = "DataList1_chk_" + cell.Rowno.ToString();
cell.OutputHTML = "<input type=hidden id=\"DataList1_key_" + cell.Rowno.ToString() + "\" name=\"DataList1_key_" + cell.Rowno.ToString() + "\" value=\"" + keys + "\">";
}
/*
* if (column.ID == "DataList1_Cdate")
* {
* DateTime datetime = Convert.ToDateTime(rs["Cdate"].ToString());
* cell.OutputHTML = datetime.ToString("yyyy/MM/dd");
* }
*/
//if (column.ID == "DataList1_view")
//{
// cell.LinkURL = "ForwarderView.aspx?ID=" + rs["ID"].ToString();
//}
if (column.ID == "DataList1_IsStatus")
{
if (rs["IsState"].ToString().Trim() == "waiting")
{
cell.OutputHTML = "未送審";
}
if (rs["IsState"].ToString().Trim() == "Complete")
{
cell.OutputHTML = "<font color=blue>允許</font><img src=\"/ManagePDF/images/icon-agree.gif\" border=\"0\">";
}
if (rs["IsState"].ToString().Trim() == "Terminate")
{
cell.OutputHTML = "<font color=red>退回</font><img src=\"/ManagePDF/images/icon-reject.gif\" border=\"0\">";
}
if (rs["IsState"].ToString().Trim() == "isSend")
{
cell.OutputHTML = "<font color=green>待確認</font><img src=\"/ManagePDF/images/icon-senddoc.gif\" border=\"0\">";
}
if (rs["IsState"].ToString().Trim() == "isStop")
{
cell.OutputHTML = "<font color=red>退回ERP</font><img src=\"/ManagePDF/images/delete.gif\" border=\"0\" Alt=退回ERP>";
}
}
if (column.ID == "DataList1_approval")
{
cell.LinkURL = rs["reviewerurl"].ToString() + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("?"));
}
if (column.ID == "DataList1_multiapproval")
{
bool EndbledMultiApproval = false;
string[] ResultTypes = new string[] { "Next", "Back", "Terminate" };
string classname = "";
try
{
classname = SmoothEnterprise.Web.Page.InheritsClass(rs["reviewerurl"].ToString());
System.Type FlowViewType = SmoothEnterprise.Utility.Type.GetType(classname);
Object obj = FlowViewType.InvokeMember(null, System.Reflection.BindingFlags.CreateInstance, null, null, null);
//ResultTypes = (string[])FlowViewType.InvokeMember("MultiApproval_ResultTypes", System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Default | System.Reflection.BindingFlags.GetProperty, null, obj, null);
EndbledMultiApproval = (ResultTypes.Length > 0);
}
catch
{
EndbledMultiApproval = false;
}
// Response.Write(classname + ResultTypes.Length.ToString() + "--" + Global.iVars.ToString());
if (rs["reviewdate"] == DBNull.Value)
{
//if (Global.ustep.ToString()=="0")
//{
cell.OutputHTML =
"<div id='div_" + rs["reviewerurl"].ToString() + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("?")) + "' style=\"white-space:nowrap\">" + Environment.NewLine +
" <table>" + Environment.NewLine +
" <tr>" + Environment.NewLine +
" <td width=\"1px\">" + Environment.NewLine +
" <input type='checkbox' id='chk_multiapproval' name='chk_multiapproval' checked = 'true' value='" + rs["dgflowid"].ToString() + "'>" + Environment.NewLine +
" </td>" + Environment.NewLine +
" <td>" + Environment.NewLine +
" <select id='resulttype_" + rs["dgflowid"].ToString() + "' name='resulttype_" + rs["dgflowid"].ToString() + "' style=\"font-size:11px;\">" + Environment.NewLine;
for (int i = 0; i < ResultTypes.Length; i++)
{
switch (ResultTypes[i])
{
case "Next":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Next.ToString() + "\">允許</option>" + Environment.NewLine;
break;
case "Back":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Back.ToString() + "\">退回上一關</option>" + Environment.NewLine;
break;
case "Complete":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Complete.ToString() + "\">完成</option>" + Environment.NewLine;
break;
case "None":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.None.ToString() + "\">沒意見</option>" + Environment.NewLine;
break;
case "Return":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Return.ToString() + "\">退回重送</option>" + Environment.NewLine;
break;
case "Terminate":
cell.OutputHTML += " <option value=\"" + SmoothEnterprise.Flowwork.Control.ReviewResultType.Terminate.ToString() + "\">退回提案人</option>" + Environment.NewLine;
break;
}
}
cell.OutputHTML +=
" </select>" + Environment.NewLine +
" <input type='hidden' id='url_" + rs["dgflowid"].ToString() + "' name='url_" + rs["dgflowid"].ToString() + "' value='" + rs["reviewerurl"].ToString() + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("?")) + "'>" + Environment.NewLine +
" </td>" + Environment.NewLine +
" </tr>" + Environment.NewLine +
" </table>" + Environment.NewLine +
"</div>" + Environment.NewLine;
//}
//else
// cell.OutputHTML = "<div id='div_" + rs["reviewerurl"].ToString() + rs["requesturl"].ToString().Substring(rs["requesturl"].ToString().IndexOf("?")) + "'> 審核中........ </div>";
}
else
{
cell.CellStyle += "\" align=\"center\"><none a=\"a";
cell.OutputHTML = "--";
}
}
}
catch (Exception ex)
{
Response.Write(ex);
Response.End();
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
protected void DataList1_OnRenderCell(object sender, System.Data.DataRowView rs, SmoothEnterprise.Web.UI.WebControl.DataColumn column, SmoothEnterprise.Web.UI.WebControl.DataCell cell, System.EventArgs e)
{
try
{
if (column.ID == "DataList1_edit")
{
if ((rs["STATUS"].ToString() == "OK") || (rs["STATUS"].ToString() == "V") || (rs["STATUS"].ToString() == "NO"))
{
cell.OutputHTML = " ";
}
else
{
cell.OutputHTML = "<a href=\"ERP_APMI255Edit.aspx?id=" + rs["id"].ToString() + "\"><img src=\"/Lib/Img/icon-edit.gif\" border=\"0\"></a>";
}
}
if (column.ID == "DataList1_view")
{
cell.LinkURL = "ERP_APMI255View.aspx?id=" + rs["id"].ToString();
}
if (column.ID == "DataList1_status")
{
if (rs["status"].ToString() == "N")
{
cell.OutputHTML = "<img src=\"/flowwork/img/icon-senddoc.gif\" border=\"0\">" + "<font color=\"orange\">未送審</font>";
}
if (rs["status"].ToString() == "Y")
{
cell.OutputHTML = "<img src=\"/Lib/Img/icon-go.gif\" border=\"0\">" + "<font color=\"green\">送審中</font>";
}
if (rs["status"].ToString() == "V")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/delete.gif\" border=\"0\">" + "作廢";
}
if (rs["status"].ToString() == "OK")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/icon-agree.gif\" border=\"0\">" + "<font color=\"blue\">完成審核</font>";
}
if (rs["status"].ToString() == "NO")
{
cell.OutputHTML = "<img src=\"/ManagePDF/images/icon-reject.gif\" border=\"0\">" + "<font color=\"red\">退回至ERP</font>";
}
//if (rs["status"].ToString() == "ERP")
//{
// cell.OutputHTML = "<img src=\"/ManagePDF/images/icon-reject.gif\" border=\"0\">"+"<font color=\"red\">退回ERP修改</font>" ;
//}
}
}
catch (Exception ex)
{
this.AddError(this, "DataList1_OnRenderCell()", "", ex.Message);
}
}
