// 舉報列表
public ActionResult Violmes(int Maincurrent = 1, int Contcurrent = 1, int msid = 0)
{
if (Session["Authority"] == null || Session["Authority"].ToString().Contains("C") != true)
{
ViewBag.error = "您無此權限";
}
//被舉報內容
var Maintotal = db.Mes.Where(m => m.MsRpt == true).Count();
int MainpageSize = 5;
int Mainskipcount = (Maincurrent - 1) * MainpageSize;
ViewBag.total1 = Maintotal;
ViewBag.pageSize1 = MainpageSize;
ViewBag.current1 = Maincurrent;
//舉報原因
var Conttotal = db.MesR.Where(m => m.MsId == msid).Count();
int ContpageSize = 10;
int Contskipcount = (Contcurrent - 1) * ContpageSize;
ViewBag.total2 = Conttotal;
ViewBag.pageSize2 = ContpageSize;
ViewBag.current2 = Contcurrent;
ViewBag.msid = msid;
MesRpt vme = new MesRpt()
{
Mes = db.Mes.Where(m => m.MsRpt == true).OrderBy(m => m.UsId).Skip(Mainskipcount).Take(MainpageSize),
MesR = db.MesR.Where(m => m.MsId == msid && m.MsCheck == false).OrderBy(m => m.UsId).Skip(Contskipcount).Take(ContpageSize)
};
return(View(vme));
}
protected void gvBody_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataTable dtTitle = MESComment.MesOutSourcePriceSql.GetMarkerCSBreakdownTitle(txtMoNo.Text.Trim());
switch (e.Row.RowType)
{
case DataControlRowType.Header:
TableCellCollection tcHeader = e.Row.Cells;
tcHeader.Clear();
tcHeader.Add(new TableHeaderCell());
tcHeader[0].Text = "Color/Pattern";
tcHeader[0].Attributes.Add("bgcolor", "#efefe7");
for (int i = 0; i < dtTitle.Rows.Count; i++)
{
tcHeader.Add(new TableHeaderCell());
tcHeader[i + 1].Text = dtTitle.Rows[i]["MARKER_ID"].ToString();
}
tcHeader.Add(new TableHeaderCell());
tcHeader[dtTitle.Rows.Count + 1].Text = "Totals";
tcHeader[dtTitle.Rows.Count + 1].Attributes.Add("bgcolor", "#efefe7");
break;
case DataControlRowType.DataRow:
sumValue = 0;
for (int i = 0; i < dtTitle.Rows.Count; i++)
{
sumValue += MesRpt.ParseInt(e.Row.Cells[i + 1].Text.Trim()) * MesRpt.ParseInt(dtTitle.Rows[i]["TOTAL_RATION"].ToString());
}
e.Row.Cells[dtTitle.Rows.Count + 1].Text = sumValue.ToString();
for (int i = 0; i <= dtTitle.Rows.Count; i++)
{
value[i] += MesRpt.ParseInt(e.Row.Cells[i + 1].Text.ToString());
}
break;
case DataControlRowType.Footer:
e.Row.Cells[0].Text = "Totals(Plies)";
for (int i = 0; i <= dtTitle.Rows.Count; i++)
{
e.Row.Cells[i + 1].Text = value[i].ToString();
}
break;
}
}
protected void btnQuery_Click(object sender, EventArgs e)
{
string sizeRow = "1";
bool flag;
DataTable Header = MESComment.MesOutSourcePriceSql.GetMarkerCSBreakdownHeader(txtMoNo.Text.Trim());
MO_NO = Header.Rows[0]["MO_NO"].ToString();
JO_NO = Header.Rows[0]["JO_NO"].ToString();
sizeRow = Header.Rows[0]["SIZE_ROWSPAN"].ToString();
divFirst.InnerHtml = "";
divFirst.InnerHtml += "<table border='1' cellspacing='0' cellpadding='0' style='font-size:12px;border-collapse:collapse'><tr><td class='tr2style' bgcolor='#efefe7' width='100' >Markers</td>";
DataTable Title = MESComment.MesOutSourcePriceSql.GetMarkerCSBreakdownTitle(txtMoNo.Text.Trim());
foreach (DataRow row in Title.Rows)
{
divFirst.InnerHtml += "<td>" + row["MARKER_ID"] + "</td>";
}
divFirst.InnerHtml += "</tr><tr><td class='tr2style' bgcolor='#efefe7' > Length<p/>Yard/Inch</td>";
foreach (DataRow row in Title.Rows)
{
divFirst.InnerHtml += "<td>" + row["MARKER_LEN_YDS"] + "/" + row["MARKER_LEN_INCH"] + "</td>";
}
divFirst.InnerHtml += "</tr><tr><td class='tr2style' bgcolor='#efefe7' rowspan='" + sizeRow + "'>Sizes</td>";
DataTable Size = MESComment.MesOutSourcePriceSql.GetMarkerCSBreakdownSizeDetail(txtMoNo.Text.Trim());
ArrayList count = new ArrayList();
for (int i = 0; i < Size.Rows.Count; i++)
{
count.Add(0);
}
for (int k = 0; k < MesRpt.ParseInt(sizeRow.Trim()); k++)
{
int m = 0;
for (int i = m; i < Title.Rows.Count; i++)
{
flag = false;
for (int j = 0; j < Size.Rows.Count; j++)
{
if (Size.Rows[j]["MARKER_ID"].ToString() == Title.Rows[i]["MARKER_ID"].ToString())
{
divFirst.InnerHtml += "<td>" + Size.Rows[j]["SIZE_CD"] + "</td>";
m++;
flag = true;
if (MesRpt.ParseInt(Size.Rows[j]["RATION"].ToString()) == MesRpt.ParseInt(count[j].ToString()) + 1)
{
Size.Rows.RemoveAt(j);
count.RemoveAt(j);
}
else
{
count[j] = MesRpt.ParseInt(count[j].ToString()) + 1;
}
break;
}
}
if (!flag)
{
divFirst.InnerHtml += "<td></td>";
}
}
divFirst.InnerHtml += "</tr>";
}
divFirst.InnerHtml += "<tr><td class='tr2style' bgcolor='#efefe7'> Number Of Sizes</td>";
foreach (DataRow row in Title.Rows)
{
divFirst.InnerHtml += "<td>" + row["TOTAL_RATION"] + "</td>";
}
divFirst.InnerHtml += "</tr></table>";
//gvBody
string COLOR_CD = "";
DataTable dtDetail = new DataTable();
dtDetail.Columns.Add("COLOR_CD");
foreach (DataRow row in Title.Rows)
{
dtDetail.Columns.Add(row["MARKER_ID"].ToString());
}
DataTable colorDetail = MESComment.MesOutSourcePriceSql.GetMarkerCSBreakdownColorDetail(txtMoNo.Text.Trim());
int index = -1;
for (int i = 0; i < colorDetail.Rows.Count; i++)
{
if (COLOR_CD != colorDetail.Rows[i]["COLOR_CD"].ToString())
{
index++;
DataRow row = dtDetail.NewRow();
row["COLOR_CD"] = colorDetail.Rows[i]["COLOR_CD"].ToString();
dtDetail.Rows.Add(row);
}
dtDetail.Rows[index][colorDetail.Rows[i]["MARKER_ID"].ToString()] = colorDetail.Rows[i]["PLYS"];
COLOR_CD = colorDetail.Rows[i]["COLOR_CD"].ToString();
}
gvBody.AutoGenerateColumns = false;
gvBody.Columns.Clear();
BoundField col = new BoundField();
col.DataField = "COLOR_CD";
col.Visible = true;
gvBody.Columns.Add(col);
foreach (DataRow row in Title.Rows)
{
BoundField col1 = new BoundField();
col1.DataField = row["MARKER_ID"].ToString();
gvBody.Columns.Add(col1);
}
BoundField col2 = new BoundField();
gvBody.Columns.Add(col2);
col.Visible = true;
gvBody.DataBind();
gvBody.DataSource = dtDetail;
gvBody.DataBind();
}
