protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.Params["SerialNum"] != null)
HyperLinkDetail.NavigateUrl = "../GameServer/ServerOperationHistory.aspx?SerialNum=" + Request.Params["SerialNum"].ToString();
TableHeaderRow header = new TableHeaderRow();
TableHeaderCell[] head = new TableHeaderCell[2];
for (int i = 0; i <= 1; i++) head[i] = new TableHeaderCell();
head[0].Width = new Unit(10f, UnitType.Percentage);
head[0].Text = StringDef.Name;
head[1].Width = new Unit(30f, UnitType.Percentage);
head[1].Text = StringDef.Message;
header.Cells.AddRange(head);
ResultList.Rows.Add(header);
if (Session["ActionResultList"] == null)
{
TableRow row = new TableRow();
TableCell[] cell = new TableCell[2];
for (int i = 0; i <= 1; i++) cell[i] = new TableCell(); ;
cell[0].Text = "";
cell[1].Text = "Çë²é¿´ÈÕÖ¾";
row.Cells.AddRange(cell);
ResultList.Rows.Add(row);
}
else
{
ShowRunResult(Session["ActionResultList"] as IList);
}
}
}
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
try
{
if (e.Row.RowType == DataControlRowType.Header)
{
GridView gv3 = sender as GridView;
GridViewRow row3 = new GridViewRow(0, -1, DataControlRowType.Header, DataControlRowState.Normal);
Table t3 = (Table)gv3.Controls[0];
TableCell FileDateb1 = new TableHeaderCell();
FileDateb1.Text = "<b>Center Name:</b> " + DropDownList4.SelectedItem.Text + " | <b>Course:</b> " + DropDownList2.SelectedItem.Text + " | <b> Period:</b> " + Convert.ToDateTime(TextBox1.Text).ToString("dd MMM, yyyy") + " to " + Convert.ToDateTime(TextBox2.Text).ToString("dd MMM, yyyy");
FileDateb1.ColumnSpan = GridView1.Columns.Count;
FileDateb1.Height = 50;
FileDateb1.Font.Size = 15;
FileDateb1.Font.Bold = true;
row3.Cells.Add(FileDateb1);
t3.Rows.AddAt(0, row3);
}
}
catch
{
}
}
protected void GridView1_DataBound(object sender, EventArgs e)
{
if (GridView1.Rows.Count > 0)
{
Table tbl = (Table)GridView1.Controls[0];
GridViewRow row = new GridViewRow(1, -1, DataControlRowType.Header, DataControlRowState.Normal);
string msg = " ";
if (rsQty == limitQty)
msg = "Warning: Your search result has reached the limit of the number of " + limitQty.ToString();
TableCell th = new TableHeaderCell();
th.ColumnSpan = 6;
th.Text = msg;
row.Cells.Add(th);
TableCell thQty = new TableHeaderCell();
thQty.Text = "Total Qty<br/>" + totalQty.ToString();
thQty.ForeColor = System.Drawing.Color.Red;
thQty.HorizontalAlign = HorizontalAlign.Right;
row.Cells.Add(thQty);
TableCell thAmt = new TableHeaderCell();
thAmt.Text = "Total Amount<br/>" + totalAmt.ToString();
row.Cells.Add(thAmt);
thAmt.ForeColor = System.Drawing.Color.Red;
thAmt.HorizontalAlign = HorizontalAlign.Right;
TableCell th2 = new TableHeaderCell();
th2.ColumnSpan = 8;
th2.Text = " ";
row.Cells.Add(th2);
tbl.Rows.AddAt(1, row);
}
}
protected void DropDownListSuppliers_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownListSuppliers.SelectedIndex == 0) return;
List<List<string>> lProd = NorthwindAccess.GetProducts(DropDownListSuppliers.SelectedValue);
TableHeaderRow thr = new TableHeaderRow();
for (int i = 0; i < lProd[0].Count; i++)
{
TableHeaderCell thc = new TableHeaderCell();
thc.Text = lProd[0][i];
thr.Cells.Add(thc);
}
tableProducts.Rows.Add(thr);
for (int i = 1; i < lProd.Count; i++)
{
TableRow tr = new TableRow();
for (int ii = 0; ii < lProd[i].Count; ii++)
{
TableCell tc = new TableCell();
tc.Text = lProd[i][ii];
tr.Cells.Add(tc);
}
tableProducts.Rows.Add(tr);
}
}
protected void Page_Load(object sender, EventArgs e)
{
v1txtName.Focus();
//count is used to populate the number of rows in the view2 table
//it is based on the number entered in the v1txtFields TextBox
int count;
try
{
if (v1txtFields.Text.Trim().Length > 0)//if a value is present at all
{
count = int.Parse(v1txtFields.Text.Trim());//get the number from v1txtFields TextBox
//set the table columns and headers
TableHeaderRow thr = new TableHeaderRow();
TableHeaderCell thFieldName = new TableHeaderCell();
TableHeaderCell thDataType = new TableHeaderCell();
TableHeaderCell thRequired = new TableHeaderCell();
thFieldName.Text = "Field Name";
thDataType.Text = "Data Type";
thRequired.Text = "Required";
thr.Cells.Add(thFieldName);
thr.Cells.Add(thDataType);
thr.Cells.Add(thRequired);
v2table.Rows.Add(thr);
//populate the table with new text boxes, drop lists, and validators
for (int i = 0; i < count; i++)
{
TableRow tr = new TableRow();
TableCell c1 = new TableCell();//text box
TableCell c2 = new TableCell();//droplist
TableCell c3 = new TableCell();//checkbox
DropDownList ddl = SetDataTypeList();
TextBox t = new TextBox();
t.TabIndex = (short)(i + 1);
t.ID = "box" + i.ToString(); // can't validate without an ID
c1.Controls.Add(t);
c2.Controls.Add(ddl);
c3.Controls.Add(new CheckBox());
tr.Cells.Add(c1);
tr.Cells.Add(c2);
tr.Cells.Add(c3);
tr.Cells.Add(new TableCell()); //add a blank cell for the validator later
v2table.Rows.Add(tr);
}
}
else //nothing is in the view 1 textbox at page load
{
count = 0;
}
}
catch (Exception)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
Alert.Visible = false;
LoadAllStandardOperatingProcedures();
if (standardOperatingProcedures == null)
{
Alert.Visible = true;
Alert.InnerHtml = "There are no SOPs in the database!";
}
else
{
var headerRow = new TableHeaderRow();
var titleHeaderCell = new TableHeaderCell();
titleHeaderCell.Text = "Title";
var departmentHeaderCell = new TableHeaderCell();
departmentHeaderCell.Text = "Department";
TableHeaderCell[] headerCells = { titleHeaderCell, departmentHeaderCell };
headerRow.Cells.AddRange(headerCells);
StandardOperatingProcedures.Rows.Add(headerRow);
foreach (var sop in standardOperatingProcedures)
{
var row = new TableRow();
var titleCell = new TableCell();
titleCell.Text = sop.Title;
var departmentCell = new TableCell();
departmentCell.Text = sop.Department;
//var previewCell = new TableCell();
//previewCell.Text = "<a href='"
var viewCell = new TableCell();
var viewButton = new Button();
viewButton.Text = "View";
viewButton.CommandArgument = sop.Title;
viewButton.Command += new CommandEventHandler(ViewClick);
viewCell.Controls.Add(viewButton);
var downloadCell = new TableCell();
Button downloadButton = new Button();
downloadButton.Text = "Download";
downloadButton.CommandArgument = sop.Title;
downloadButton.Command += new CommandEventHandler(DownloadClick);
downloadCell.Controls.Add(downloadButton);
var editCell = new TableCell();
Button editButton = new Button();
editButton.Text = "Edit";
editButton.CommandArgument = sop.XmlPath.Substring(sop.XmlPath.LastIndexOf('\\'));
editButton.Command += new CommandEventHandler(EditClick);
editCell.Controls.Add(editButton);
TableCell[] cells = { titleCell, departmentCell, viewCell, /*previewCell,*/ downloadCell, editCell };
row.Cells.AddRange(cells);
StandardOperatingProcedures.Rows.Add(row);
}
}
}
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
GridView gv = sender as GridView;
GridViewRow row = new GridViewRow(0, -1, DataControlRowType.Header, DataControlRowState.Normal);
Table t = (Table)gv.Controls[0];
TableCell cell1 = new TableHeaderCell();
cell1.Text = "S. No";
row.Cells.Add(cell1);
TableCell cell2 = new TableHeaderCell();
cell2.Text = "S. No. of Auction List";
row.Cells.Add(cell2);
TableCell cell3 = new TableHeaderCell();
cell3.Text = "Bid Paper No.";
row.Cells.Add(cell3);
TableCell cell4 = new TableHeaderCell();
cell4.Text = "Name of Purchaser";
row.Cells.Add(cell4);
TableCell cell5 = new TableHeaderCell();
cell5.Text = "Lot No. Purchased";
row.Cells.Add(cell5);
TableCell cell6 = new TableHeaderCell();
cell6.Text = "Stack No. Purchased";
row.Cells.Add(cell6);
TableCell cell7 = new TableHeaderCell();
cell7.Text = "Species";
row.Cells.Add(cell7);
TableCell cell8 = new TableHeaderCell();
cell8.Text = "Sizes";
row.Cells.Add(cell8);
TableCell cell9 = new TableHeaderCell();
cell9.Text = "No.";
row.Cells.Add(cell9);
t.Rows.AddAt(0, row);
Table t8 = (Table)gv.Controls[0];
}
}
/// <summary>
/// Event triggered to perform the matchmaking algorithm
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnFindParticipants_Click(object sender, EventArgs e)
{
int studyID = Convert.ToInt32(Request.QueryString["study_id"]);
Matchmaker matchmaker = new Matchmaker(new Study(studyID));
Table tblResults = new Table();
TableHeaderRow header = new TableHeaderRow();
TableHeaderCell headerName = new TableHeaderCell();
TableHeaderCell headerEmail = new TableHeaderCell();
TableHeaderCell headerScore = new TableHeaderCell();
headerName.Text = "Name";
headerEmail.Text = "Email";
headerScore.Text = "Score";
header.Cells.Add(headerName);
header.Cells.Add(headerEmail);
header.Cells.Add(headerScore);
tblResults.Rows.Add(header);
tblResults.CellSpacing = 3;
tblResults.CellPadding = 5;
foreach (KeyValuePair<Participant, int> result in matchmaker.Results) {
TableRow row = new TableRow();
TableCell cellID = new TableCell();
TableCell cellName = new TableCell();
TableCell cellEmail = new TableCell();
TableCell cellScore = new TableCell();
cellID.Text = result.Key.UserID.ToString();
cellID.Visible = false;
HyperLink link = new HyperLink();
link.ToolTip = "Click the link to view more information about this user";
link.Text = result.Key.FirstName + " " + result.Key.LastName;
link.NavigateUrl="ParticipantInfo.aspx?participant_id=" + cellID.Text + "&study_id=" + studyID;
cellName.Controls.Add(link);
cellEmail.Text = result.Key.Email;
cellScore.Text = result.Value.ToString();
row.Cells.Add(cellID);
row.Cells.Add(cellName);
row.Cells.Add(cellEmail);
row.Cells.Add(cellScore);
tblResults.Rows.AddAt(getIndexToAdd(tblResults, row), row);
pnlmatchmakingResults.Controls.Add(tblResults);
}
if (matchmaker.Results.Count == 0) {
lblNoResults.Visible = true;
}
pnlmatchmakingResults.Visible = true;
btnEmailParticipant.Visible = true;
}
private void ShowState(AccountState state)
{
TableRow row = new TableRow();
TableHeaderCell cell = new TableHeaderCell();
cell.Width = new Unit(30, UnitType.Percentage);
cell.Text = StringDef.AccountState;
row.Cells.Add(cell);
TableCell cell1 = new TableCell();
cell1.Text = state.ToString();
row.Cells.Add(cell1);
TableResult.Rows.Add(row);
}
public void fillTable(string sql, ref Table table)
{
DataTable dataTable = selectQuery(sql);
TableHeaderRow th = new TableHeaderRow();
for (int i = 0; i < dataTable.Columns.Count; i++)
{
TableHeaderCell cell = new TableHeaderCell();
cell.Text = dataTable.Columns[i].ColumnName;
th.Cells.Add(cell);
}
table.Rows.Add(th);
foreach (DataRow row in dataTable.Rows)
{
TableRow trow = new TableRow();
for (int i = 0; i < dataTable.Columns.Count; i++)
{
TableCell cell = new TableCell();
cell.Text = row[i].ToString();
trow.Cells.Add(cell);
}
if (table.ID == "TableEquip")
{
TableCell cell = new TableCell();
LinkButton edit = new LinkButton();
edit.PostBackUrl = "~/PersonnelEditEquip.aspx?equip=";
edit.PostBackUrl += row[0].ToString();
edit.Text = "ویرایش";
cell.Controls.Add(edit);
trow.Cells.Add(cell);
}
table.Rows.Add(trow);
}
}
private void ShowGatewayList(IList<GatewayInfo> list)
{
if (list == null || list.Count == 0)
{
return;
}
TableHeaderRow rowHead = new TableHeaderRow();
TableHeaderCell cellHead = new TableHeaderCell();
cellHead.Text = StringDef.GatewayName;
rowHead.Cells.Add(cellHead);
cellHead = new TableHeaderCell();
cellHead.Text = StringDef.ZoneName;
rowHead.Cells.Add(cellHead);
cellHead = new TableHeaderCell();
cellHead.Text = StringDef.IPAddress;
rowHead.Cells.Add(cellHead);
TableGatewayInfo.Rows.Add(rowHead);
foreach (GatewayInfo info in list)
{
TableRow row = new TableRow();
TableCell cell = new TableCell();
cell.Text = info.GatewayName;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = info.ZoneName;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = info.IPAddress;
row.Cells.Add(cell);
TableGatewayInfo.Rows.Add(row);
}
LabelResult.Text = StringDef.GatewayList;
}
public static void CreateHeader(string strheader, Table table, int[] widths)
{
string[] Headers = strheader.Split(',');
TableHeaderRow thr = new TableHeaderRow();
int i = 0;
if (Headers.Length != widths.Length)
{
i = -1;
}
foreach (string s in Headers)
{
TableHeaderCell tc = new TableHeaderCell();
tc.Text = s;
if (i > -1)
{
tc.Width = widths[i];
i++;
}
thr.Cells.Add(tc);
}
table.Rows.Add(thr);
}
public Table[] vratiTabelaNarackiKorisnik(OracleDataReader drO)
{
int i = 1;
int j = 0;
int pat = 1;
Table[] nova = new Table[100];
TableHeaderCell head;
TableCell cel;
TableRow row = new TableRow();
TableFooterRow foot;
nova[j] = new Table();
while (drO.Read())
{
if (pat == 1)
{
//nova[j] = new Table();
head = new TableHeaderCell();
head.Text = "Бр";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Производ_ID";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Attributes.Add("class", "hide");
head.Text = "Комитент_ID";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Маркет";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Адреса";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Град";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Датум";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Вкупно";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Платено";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Затворена";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Измени";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Прикажи";
row.Controls.Add(head);
nova[j].Controls.Add(row);
pat = 2;
}
if (i > 10)
{
i = 1;
j++;
row = new TableRow();
nova[j] = new Table();
head = new TableHeaderCell();
head.Text = "Бр";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Производ_ID";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Attributes.Add("class", "hide");
head.Text = "Комитент_ID";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Маркет";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Адреса";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Град";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Датум";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Вкупно";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Платена";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Затворена";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Измени";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Прегледај";
row.Controls.Add(head);
nova[j].Controls.Add(row);
}
row = new TableRow();
cel = new TableCell();
cel.Text = i.ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["IDP"].ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["IDK"].ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["МАРКЕТ"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["АДРЕСА"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["ГРАД"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["ДАТУМ"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["ВКУПНО"].ToString() +",00ден";
cel.Attributes.Add("class", "textCellLevo");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["ПЛАТЕНА"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["ЗАТВОРЕНА"].ToString().Trim();
row.Controls.Add(cel);
cel = new TableCell();
if (drO["ЗАТВОРЕНА"].ToString().Trim() !="D")
{
Button izmeniBtn = new Button();
izmeniBtn.Text = "Измени";
izmeniBtn.ID = "izmeniBtn." + j.ToString() + "." + i.ToString();
izmeniBtn.Click += new EventHandler(izmeniBtn_Click);
cel.Controls.Add(izmeniBtn);
}
row.Controls.Add(cel);
cel = new TableCell();
Button izvestajBtn = new Button();
izvestajBtn.Text = "Прикажи";
izvestajBtn.ID = "izvestajBtn." + j.ToString() + "." + i.ToString();
izvestajBtn.Click += new EventHandler(izvestajBtn_Click);
cel.Controls.Add(izvestajBtn);
row.Controls.Add(cel);
nova[j].Controls.Add(row);
i++;
}
Table[] kraj = new Table[j + 1];
//for (int w = 0; w <= j; w++)
//{
// foot = new TableFooterRow();
// cel = new TableCell();
// cel.ColumnSpan = 5;
// for (int q = 1; q <= j + 1; q++)
// {
// Button kopce = new Button();
// kopce.ID =q.ToString();
// kopce.Click += new EventHandler(kopceListaNaracki_Click);
// kopce.Text = q.ToString();
// cel.Controls.Add(kopce);
// }
// foot.Controls.Add(cel);
// if (nova[w] != null)
// nova[w].Rows.Add(foot);
// kraj[w] = nova[w];
//}
if (nova[0].Rows.Count > 0)
{
for (int w = 0; w <= j; w++)
{
foot = new TableFooterRow();
cel = new TableCell();
cel.ColumnSpan = 5;
for (int q = 1; q <= j + 1; q++)
{
Button kopce = new Button();
kopce.ID =q.ToString();
kopce.Click += new EventHandler(kopceListaNaracki_Click);
kopce.Text = q.ToString();
cel.Controls.Add(kopce);
}
foot.Controls.Add(cel);
if (nova[w] != null)
nova[w].Rows.Add(foot);
kraj[w] = nova[w];
}
}
else
{
foot = new TableFooterRow();
cel = new TableCell();
cel.Text = " Нема податоци - нарачки ";
cel.BorderColor = System.Drawing.Color.White;
cel.BorderWidth = Unit.Pixel(2);
cel.BorderStyle = BorderStyle.Solid;
foot.Controls.Add(cel);
nova[0].Rows.Add(foot);
kraj[0] = nova[0];
}
return kraj;
}
protected void Page_Load(object sender, EventArgs e)
{
config_data = new SystemConfig().getConfig();
academic_year = config_data.AcademicYear;
semester = config_data.Semester;
Student student_data = new Student();
row1 = Request.QueryString["show_row"];
if (Session["showRegCourse" + row1] == null)
{
Response.Redirect("List_StudentRegis_SecAdvisor.aspx");
}
else
{
student_data = (Student)Session["showRegCourse" + row1];
lblStudentName.Text = student_data.Student_ID + " " + student_data.First_ThaiName + " " + student_data.Family_ThaiName;
if (!Page.IsPostBack)
{
Session.Remove("ApproveRegis");
}
try
{
string Lecturer_ID = (string)Session["Lecturer_ID"];
GradAdvisorData advisor_data = new GradAdvisorData();
advisor_data = new Student().getAdvisorCoAdvisor(student_data.Student_ID);
if (advisor_data.Advisor_ID == null)
{
lblAlertAdvisor.Text = "";
if (Session["ApproveRegis"] != null)
{
btnApprove.Enabled = true;
}
else
{
btnApprove.Enabled = false;
}
}
else if (advisor_data.Advisor_ID == "0")
{
lblAlertAdvisor.Text = "";
if (Session["ApproveRegis"] != null)
{
btnApprove.Enabled = true;
}
else
{
btnApprove.Enabled = false;
}
}
else
{
if (Lecturer_ID == advisor_data.Advisor_ID)
{
lblAlertAdvisor.Text = "";
if (Session["ApproveRegis"] != null)
{
btnApprove.Enabled = true;
}
else
{
btnApprove.Enabled = false;
}
}
else
{
lblAlertAdvisor.Text = "นักศึกษาได้แต่งตั้งอาจารย์ที่ปรึกษาแล้ว";
btnApprove.Enabled = false;
}
}
LectuereInformationData lecturer_data = new LectuereInformationData();
lecturer_data = new Lecturer().getLecturer(student_data.Advisor_ID);
degree_char = student_data.Degree_Char;
studentRegisData = new Student_Registration().getRegistration(academic_year, semester, student_data.Student_ID, degree_char);
int numrow = 1;
CheckBox[] chk = new CheckBox[studentRegisData.Count];
txtCredit = new TextBox[studentRegisData.Count];
int i = 0;
// Head Table
//string[] ar = { "ตอนที่", "รหัสวิชา", "ชื่อวิชา", "ผู้สอน", "ห้องเรียน", "เวลาเรียน", "สอบกลางภาค", "สอบปลายภาค", "อนุมัติ" };
string[] ar = { "ตอนที่", "รหัสวิชา", "ชื่อวิชา", "ผู้สอน", "ห้องเรียน", "เวลาเรียน", "ประเภทการลงทะเบียน", "สถานะการลงทะเบียน", "สถานะการชำระเงิน", "จำนวนหน่วยกิต", "อนุมัติ" };
Table tb1 = new Table();
tb1.Attributes.Add("class", "table table-bordered table-hover table-striped");
tb1.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead = new TableHeaderRow();
tRowHead.TableSection = TableRowSection.TableHeader;
for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++)
{
// Create a new cell and add it to the row.
TableHeaderCell cellHead = new TableHeaderCell();
cellHead.Text = ar[cellCtr - 1];
cellHead.Attributes.Add("class", "text-align-center");
tRowHead.Cells.Add(cellHead);
}
tb1.Rows.Add(tRowHead);
List <RegistrationData> ApproveRegisData = new List <RegistrationData>();
if (Session["ApproveRegis"] != null)
{
ApproveRegisData = (List <RegistrationData>)Session["ApproveRegis"];
}
foreach (RegistrationData data in studentRegisData)
{
teachingData = new TeachingTable().getSubTeachingTable(academic_year, semester, data.Course_Code, data.Sec_No, data.SubSec_No, degree_char);
lec_table = degree_char;
// กรณีวิชาที่เพิ่มโดยอาจารย์ผู้สอน เป็นวิชาที่อยู่คนละระดับการศึกษา
if (teachingData.Count <= 0)
{
if (degree_char == "U" || degree_char == "B")
{
teachingData = new TeachingTable().getSubTeachingTable(academic_year, semester, data.Course_Code, data.Sec_No, data.SubSec_No, "M");
lec_table = "M";
}
else
{
teachingData = new TeachingTable().getSubTeachingTable(academic_year, semester, data.Course_Code, data.Sec_No, data.SubSec_No, "B");
lec_table = "B";
}
}
//=======================
CourseData course_reg = new CourseData();
course_reg = new Course().getCourse(data.Course_Code);
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
string course_type = "";
if (data.Course_Type == "1")
{
course_type = "S.";
}
else if (data.Course_Type == "2")
{
course_type = "L.";
}
else if (data.Course_Type == "4")
{
course_type = "T.";
}
else if (data.Course_Type == "5")
{
course_type = "M.";
}
else if (data.Course_Type == "6")
{
course_type = "SP.";
}
else if (data.Course_Type == "7")
{
course_type = "D.";
}
if (data.SubSec_No != 0)
{
course_type += data.SubSec_No;
}
else
{
course_type += data.Sec_No;
}
TableCell cellSec = new TableCell();
cellSec.Text = course_type;
cellSec.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellSec);
TableCell cellCourseCode = new TableCell();
cellCourseCode.Text = course_reg.Course_Code;
cellCourseCode.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellCourseCode);
TableCell cellCourse = new TableCell();
cellCourse.Text = course_reg.Course_Thainame;
tRowBody.Cells.Add(cellCourse);
TableCell cellLecturer = new TableCell();
string lec_name = "";
foreach (TeachingTableData teach in teachingData)
{
lecturerData = new LecturerTable().getLecturerTable(teach, lec_table);
foreach (LecturerTableData lec in lecturerData)
{
lec_name += new Lecturer().getLecturer(lec.Lecturer).Lecturer_ShortName + ",";
}
lec_name = lec_name.Substring(0, lec_name.Length - 1);
lec_name += "<br>";
}
cellLecturer.Text = lec_name;
tRowBody.Cells.Add(cellLecturer);
TableCell cellRoom = new TableCell();
foreach (TeachingTableData teach in teachingData)
{
cellRoom.Text += teach.Building_Code + "-" + teach.Room_Code;
if (teach.Campus_Code == "2")
{
cellRoom.Text += "*";
}
else if (teach.Campus_Code == "3")
{
cellRoom.Text += "**";
}
cellRoom.Text += "<br/>";
}
cellRoom.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellRoom);
TableCell cellTeaching = new TableCell();
foreach (TeachingTableData teach in teachingData)
{
string day = "";
if (teach.Teaching_Day == "1")
{
day = "Mon";
}
else if (teach.Teaching_Day == "2")
{
day = "Tue";
}
if (teach.Teaching_Day == "3")
{
day = "Wed";
}
if (teach.Teaching_Day == "4")
{
day = "Thu";
}
if (teach.Teaching_Day == "5")
{
day = "Fri";
}
if (teach.Teaching_Day == "6")
{
day = "Sat";
}
if (teach.Teaching_Day == "7")
{
day = "Sun";
}
cellTeaching.Text += day + " " + teach.Teaching_Start_Time + " - " + teach.Teaching_End_Time + "<br>";
cellTeaching.Attributes.Add("class", "text-align-center");
}
tRowBody.Cells.Add(cellTeaching);
//TableCell cellMid = new TableCell();
//cellMid.Text = new utility().getThaiBirthDay(exam_data.ExamMid_Day) + " เวลา:" + exam_data.ExamMid_StartTime + "-" + exam_data.ExamMid_EndTime;
//tRowBody.Cells.Add(cellMid);
//TableCell cellFinal = new TableCell();
//cellFinal.Text = new utility().getThaiBirthDay(exam_data.ExamFinal_Day) + " เวลา:" + exam_data.ExamFinal_StartTime + "-" + exam_data.ExamFinal_EndTime;
//tRowBody.Cells.Add(cellFinal);
TableCell cellRegType = new TableCell();
cellRegType.Text = data.Reg_Type;
cellRegType.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellRegType);
TableCell cellRegStatus = new TableCell();
cellRegStatus.Text = statusObj.getStatus(data.Status).Status_Thai;
cellRegStatus.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellRegStatus);
TableCell cellPaymentStatus = new TableCell();
cellPaymentStatus.Text = statusObj.getStatus(new Student_Payment().getPaymentStatus(data.Payment_ID, degree_char)).Status_Thai;
cellPaymentStatus.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellPaymentStatus);
TableCell cellCredit = new TableCell();
cellCredit.Attributes.Add("class", "text-align-center");
if ((data.Course_Type == "4") || (data.Course_Type == "5") || (data.Course_Type == "7"))
{
txtCredit[i] = new TextBox();
txtCredit[i].ID = "credit" + numrow.ToString();
txtCredit[i].MaxLength = 2;
txtCredit[i].Width = 30;
txtCredit[i].Attributes.Add("class", "text-center");
txtCredit[i].Text = data.Credit.ToString();
if (data.Approve_Status == "y")
{
txtCredit[i].ReadOnly = true;
txtCredit[i].BackColor = System.Drawing.ColorTranslator.FromHtml("#CCCCCC");
}
else
{
txtCredit[i].ReadOnly = false;
txtCredit[i].AutoPostBack = true;
txtCredit[i].TextChanged += new EventHandler(txtCredit_TextChanged);
}
cellCredit.Controls.Add(txtCredit[i]);
}
else
{
cellCredit.Text = data.Credit.ToString();
}
tRowBody.Cells.Add(cellCredit);
TableCell cellchkApprove = new TableCell();
if (data.Approve_Status == "n")
{
chk[i] = new CheckBox();
chk[i].AutoPostBack = true;
chk[i].ID = "approve" + numrow.ToString();
foreach (RegistrationData chkdata in ApproveRegisData)
{
if (data.Academic_Year == chkdata.Academic_Year && data.Semester == chkdata.Semester && data.Course_Code == chkdata.Course_Code && data.Sec_No == chkdata.Sec_No && data.SubSec_No == chkdata.SubSec_No)
{
chk[i].Checked = true;
}
}
chk[i].CheckedChanged += new EventHandler(chkApprove_CheckedChanged);
cellchkApprove.Controls.Add(chk[i]);
cellchkApprove.Attributes.Add("class", "text-align-center");
}
else
{
if (data.Approve_Status == "y")
{
cellchkApprove.Text = "อนุมัติ";
cellchkApprove.Attributes.Add("class", "txt-green-bold text-align-center");
}
}
tRowBody.Cells.Add(cellchkApprove);
numrow++;
i++;
tb1.Rows.Add(tRowBody);
}
TableRow row = new TableRow();
TableCell cell = new TableCell();
cell.Controls.Add(tb1);
row.Cells.Add(cell);
tblStudentAdvisor.Rows.Add(row);
}
catch (Exception err)
{
HttpContext.Current.Session["response"] = "ไม่สามารถดำเนินการได้" + err.ToString();
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
/// <summary>
/// Compare DataSets.
/// </summary>
/// <param name="ds">Original DataSet</param>
/// <param name="compareDs">DataSet to compare</param>
private void CompareDataSets(DataSet ds, DataSet compareDs)
{
Table = new Table();
SetTable(Table);
Table.CssClass += " NoSideBorders";
// Ensure same tables in DataSets
EnsureSameTables(ds, compareDs);
EnsureSameTables(compareDs, ds);
// Prepare list of tables
SortedDictionary <string, string> tables = new SortedDictionary <string, string>();
foreach (DataTable dt in ds.Tables)
{
string excludedTableNames = (ExcludedTableNames != null) ? ";" + ExcludedTableNames.Trim(';').ToLowerCSafe() + ";" : "";
string tableName = dt.TableName;
if (!DataHelper.DataSourceIsEmpty(ds.Tables[tableName]) || !DataHelper.DataSourceIsEmpty(CompareDataSet.Tables[tableName]))
{
if (!excludedTableNames.Contains(";" + tableName.ToLowerCSafe() + ";"))
{
tables.Add(GetString("ObjectType." + tableName), tableName);
}
}
}
// Generate the tables
foreach (string tableName in tables.Values)
{
DataTable dt = ds.Tables[tableName].Copy();
DataTable dtCompare = CompareDataSet.Tables[tableName].Copy();
if (dt.PrimaryKey.Length <= 0)
{
continue;
}
// Add table heading
if ((tables.Count > 1) || (ds.Tables.Count > 1))
{
AddTableHeaderRow(Table, GetTableHeaderText(dt), null);
}
while (dt.Rows.Count > 0 || dtCompare.Rows.Count > 0)
{
// Add table header row
TableCell labelCell = new TableHeaderCell();
labelCell.Text = GetString("General.FieldName");
TableCell valueCell = new TableHeaderCell();
valueCell.Text = GetString("General.Value");
TableCell valueCompare = new TableHeaderCell();
valueCompare.Text = GetString("General.Value");
AddRow(Table, labelCell, valueCell, valueCompare, "unigrid-head", true);
DataRow srcDr;
DataRow dstDr;
if ((tables.Count == 1) && (dt.Rows.Count == 1) && (dtCompare.Rows.Count == 1))
{
srcDr = dt.Rows[0];
dstDr = dtCompare.Rows[0];
}
else
{
if (!DataHelper.DataSourceIsEmpty(dt))
{
srcDr = dt.Rows[0];
dstDr = dtCompare.Rows.Find(GetPrimaryColumnsValue(dt, srcDr));
}
else
{
dstDr = dtCompare.Rows[0];
srcDr = dt.Rows.Find(GetPrimaryColumnsValue(dtCompare, dstDr));
}
// If match not find, try to find in guid column
if ((srcDr == null) || (dstDr == null))
{
DataTable dtToSearch;
DataRow drTocheck;
if (srcDr == null)
{
dtToSearch = dt;
drTocheck = dstDr;
}
else
{
dtToSearch = dtCompare;
drTocheck = srcDr;
}
GeneralizedInfo infoObj = ModuleManager.GetObject(drTocheck, dt.TableName.Replace("_", "."));
if ((infoObj != null) && ((infoObj.CodeNameColumn != ObjectTypeInfo.COLUMN_NAME_UNKNOWN) || (infoObj.TypeInfo.GUIDColumn != ObjectTypeInfo.COLUMN_NAME_UNKNOWN)))
{
DataRow[] rows = dtToSearch.Select(infoObj.CodeNameColumn + "='" + drTocheck[infoObj.CodeNameColumn] + "'");
if (rows.Length > 0)
{
if (srcDr == null)
{
srcDr = rows[0];
}
else
{
dstDr = rows[0];
}
}
else
{
rows = dtToSearch.Select(infoObj.TypeInfo.GUIDColumn + "='" + drTocheck[infoObj.TypeInfo.GUIDColumn] + "'");
if (rows.Length > 0)
{
if (srcDr == null)
{
srcDr = rows[0];
}
else
{
dstDr = rows[0];
}
}
}
}
}
}
// Add values
foreach (DataColumn dc in dt.Columns)
{
// Get content values
string fieldContent = GetRowColumnContent(srcDr, dc, true);
string fieldCompareContent = GetRowColumnContent(dstDr, dc, true);
if (ShowAllFields || !String.IsNullOrEmpty(fieldContent) || !String.IsNullOrEmpty(fieldCompareContent))
{
// Initialize comparators
TextComparison comparefirst = new TextComparison();
comparefirst.SynchronizedScrolling = false;
comparefirst.ComparisonMode = TextComparisonModeEnum.PlainTextWithoutFormating;
comparefirst.EnsureHTMLLineEndings = true;
TextComparison comparesecond = new TextComparison();
comparesecond.SynchronizedScrolling = false;
comparesecond.RenderingMode = TextComparisonTypeEnum.DestinationText;
comparesecond.EnsureHTMLLineEndings = true;
comparefirst.PairedControl = comparesecond;
// Set comparator content
comparefirst.SourceText = fieldContent;
comparefirst.DestinationText = fieldCompareContent;
// Create set of cells
labelCell = new TableCell();
labelCell.Text = "<strong>" + dc.ColumnName + "</strong>";
valueCell = new TableCell();
valueCell.Controls.Add(comparefirst);
valueCompare = new TableCell();
valueCompare.Controls.Add(comparesecond);
// Add comparison row
AddRow(Table, labelCell, valueCell, valueCompare);
}
}
// Remove rows from tables
if (srcDr != null)
{
dt.Rows.Remove(srcDr);
}
if (dstDr != null)
{
dtCompare.Rows.Remove(dstDr);
}
if (dt.Rows.Count > 0 || dtCompare.Rows.Count > 0)
{
TableCell emptyCell = new TableCell();
emptyCell.Text = " ";
AddRow(Table, emptyCell, null, null, "TableSeparator");
}
}
}
plcContent.Controls.Add(Table);
}
/* This method gets triggered when invoke button is clicked on */
protected void invokeButton_Click(object sender, EventArgs e)
{
if (invokeTypeButtonList.SelectedItem == null)
{
errorMessageLabel.Text = "You need to select an invocation type to proceed.";
return;
}
if (invokeTypeButtonList.SelectedItem.Value == "SingleInvoke")
{
groupInvokeParametersLabel.Text = "";
groupInvokeParametersInstructionLabel.Text = "";
groupInvokeParametersInputLabel.Text = "";
groupInvokeParametersOutputLabel.Text = "";
groupInvokeParametersHintLabel.Text = "";
groupInvokeList.DataSource = null;
groupInvokeList.DataBind();
groupInvokeResultsLabel.Text = "";
groupInvokeResultsPanel.Controls.Clear();
List <string> parameters = new List <string>();
/* Traverse through all the parameterValues and add them to a list */
foreach (DataListItem item in parameterValueDataList.Items)
{
string parameterValue = ((TextBox)item.FindControl("parameterValue")).Text;
/* If you find that the parameter value is empty, return */
if (parameterValue == "")
{
errorMessageLabel.Text = "You need to enter all the input parameters to invoke an operation";
return;
}
parameters.Add(parameterValue);
}
string url = serviceUrlTextBox.Text;
wsdlUtilsService.WSDLServiceClient wsdlUtilsClient =
new wsdlUtilsService.WSDLServiceClient();
try
{
/* Invoke the web service method */
wsdlUtilsService.ReturnData returnData =
wsdlUtilsClient.InvokeWebServiceMethod(url, parametersLabel.Text,
parameters.ToArray());
/* If return data is null, return */
if (returnData == null)
{
errorMessageLabel.Text = "The invocation didn't yield any result.";
return;
}
/* Display the result */
TextBox resultXmlTextBox = new TextBox();
resultXmlTextBox.Text = returnData.objectXML;
resultXmlTextBox.Rows = 15;
resultXmlTextBox.Columns = 70;
resultXmlTextBox.TextMode = TextBoxMode.MultiLine;
resultsLabel.Text = "Results";
resultsPanel.Controls.Add(resultXmlTextBox);
}
catch (Exception ec)
{
errorMessageLabel.Text = "Invocation didn't succeed. Try again later.";
}
}
else
{
parametersLabel.Text = "";
parameterValueDataList.DataSource = null;
parameterValueDataList.DataBind();
resultsLabel.Text = "";
resultsPanel.Controls.Clear();
List <string> inputParameters = new List <string>();
List <string> outputParameters = new List <string>();
foreach (DataListItem item in groupInvokeList.Items)
{
DataList inputParameterDataList = (DataList)item.FindControl("groupInvokeInputParameterList");
DataList outputParameterDataList = (DataList)item.FindControl("groupInvokeOutputParameterList");
/* Traverse through all the parameterValues and add them to a list */
foreach (DataListItem inputItem in inputParameterDataList.Items)
{
TextBox textBox = (TextBox)inputItem.FindControl("groupInvokeInputParameterValue");
string inputParameterValue = ((TextBox)inputItem.FindControl("groupInvokeInputParameterValue")).Text;
/* If you find that the parameter value is empty, return */
if (inputParameterValue == "")
{
errorMessageLabel.Text = "You need to enter all the input parameters to invoke an operation";
return;
}
inputParameters.Add(inputParameterValue);
}
/* Traverse through all the parameterValues and add them to a list */
foreach (DataListItem outputItem in outputParameterDataList.Items)
{
TextBox textBox = (TextBox)outputItem.FindControl("groupInvokeOutputParameterValue");
string outputParameterValue = ((TextBox)outputItem.FindControl("groupInvokeOutputParameterValue")).Text;
/* If you find that the parameter value is empty, return */
if (outputParameterValue == "")
{
errorMessageLabel.Text = "You need to enter all the output parameters to invoke an operation";
return;
}
outputParameters.Add(outputParameterValue);
}
}
string url = serviceUrlTextBox.Text;
wsdlUtilsService.WSDLServiceClient wsdlUtilsClient =
new wsdlUtilsService.WSDLServiceClient();
try
{
/* Invoke the web service method */
wsdlUtilsService.InvokeResult invokeResult =
wsdlUtilsClient.InvokeWebServiceOperationsGroup(url, inputParameters.ToArray(),
outputParameters.ToArray());
/* If return data is null, return */
if (invokeResult == null)
{
errorMessageLabel.Text = "The invocation didn't yield any result.";
return;
}
Table resultsTable = new Table();
TableHeaderRow resultsHeader = new TableHeaderRow();
TableHeaderCell methodHeader = new TableHeaderCell();
methodHeader.Text = "Method Name";
TableHeaderCell statusHeader = new TableHeaderCell();
statusHeader.Text = "Invoke Status";
resultsHeader.Cells.Add(methodHeader);
resultsHeader.Cells.Add(statusHeader);
resultsTable.Rows.Add(resultsHeader);
for (int i = 0; i < invokeResult.MethodName.Length; i++)
{
TableRow row = new TableRow();
TableCell methodCell = new TableCell();
TableCell statusCell = new TableCell();
methodCell.Text = invokeResult.MethodName[i];
if (invokeResult.InvokeStatus[i] == true)
{
statusCell.Text = "Success";
}
else
{
statusCell.Text = "Failure";
}
row.Cells.Add(methodCell);
row.Cells.Add(statusCell);
resultsTable.Rows.Add(row);
}
groupInvokeResultsPanel.Controls.Add(resultsTable);
groupInvokeResultsLabel.Text = "Results";
}
catch (Exception ec)
{
errorMessageLabel.Text = "Invocation didn't succeed. Try again later.";
}
}
}
private void CarregaTableAvaliar(int codGrupo, DataSet dsCriteriosPesos)
{
string[] codAlunos = Grupo_Aluno_DB.SelectAllMatriculaByGrupo(codGrupo);
string[] nomeAlunos = Funcoes.NomeAlunosByMatricula(codAlunos);
Session["matriculasAlunos"] = codAlunos;
DataTable dt = new DataTable();
DataRow dr = dt.NewRow();
dt.Columns.Add(" ", typeof(string)); //ADICIONA UMA COLUNA DO CABEÇALHO VAZIA
//ADICIONA AS COLUNAS DO CABEÇALHO COM OS "IDs" DE ACORDO COM O NOME DO ALUNO
for (int i = 0; i < nomeAlunos.Length; i++)
{
dt.Columns.Add(Funcoes.SplitNomes((i + 1) + nomeAlunos[i].ToString()), typeof(string));
}
string pesos = "";
for (int j = 0; j < dsCriteriosPesos.Tables[0].Rows.Count; j++)
{
dr = dt.NewRow();
for (int i = 0; i < nomeAlunos.Length + 1; i++)
{
if (i == 0) //COLUNA FOR IGUAL A 0
{
pesos += dsCriteriosPesos.Tables[0].Rows[j]["cpi_peso"].ToString() + "|";
dr[" "] = dsCriteriosPesos.Tables[0].Rows[j]["cge_nome"].ToString() + " (" + dsCriteriosPesos.Tables[0].Rows[j]["cpi_peso"].ToString() + ")";
}
}
dt.Rows.Add(dr);
}
valorPeso.Value = pesos.ToString(); //VARIAVEL USADO PARA CALCULAR MÉDIA NO SCRIPT
Table table = new Table();
TextBox txbNotas;
Label lblCriterios;
table.ID = "tableAvaliar";
table.ClientIDMode = System.Web.UI.ClientIDMode.Static;
table.CssClass = "gridViewAvaliar";
panelAvaliar.Controls.Add(table);
int rowsCount = dt.Rows.Count;
int colsCount = dt.Columns.Count;
Session["rowsCount"] = rowsCount;
Session["colsCount"] = colsCount;
TableHeaderRow thr = new TableHeaderRow();
TableHeaderCell th = new TableHeaderCell();
Label lblCabecalho = new Label();
th.Text = " ";
th.Style.Add("background-color", "#FFF");
th.Style.Add("border", "transparent");
thr.Cells.Add(th);
for (int i = 0; i < nomeAlunos.Length; i++)
{
th = new TableHeaderCell();
lblCabecalho = new Label();
lblCabecalho.Text = Funcoes.SplitNomes(nomeAlunos[i].ToString());
lblCabecalho.ToolTip = nomeAlunos[i].ToString();
lblCabecalho.Attributes["data-toggle"] = "tooltip";
th.Style.Add("text-align", "center");
th.Controls.Add(lblCabecalho);
thr.Cells.Add(th);
}
table.Rows.Add(thr);
for (int rowIndex = 0; rowIndex < rowsCount; rowIndex++)
{
TableRow row = new TableRow();
row.ID = rowIndex.ToString(); //PARA O ZEBRADO
for (int colIndex = 0; colIndex < colsCount; colIndex++)
{
TableCell cell = new TableCell();
if (colIndex == 0)
{
lblCriterios = new Label();
lblCriterios.ID = "lblCriteriosRow_" + rowIndex + "_Col_" + colIndex;
lblCriterios.ClientIDMode = System.Web.UI.ClientIDMode.Static;
lblCriterios.Text = dt.Rows[rowIndex][colIndex].ToString();
cell.Controls.Add(lblCriterios);
}
else
{
txbNotas = new TextBox();
txbNotas.ID = "txtNotasRow_" + (rowIndex) + "_Col_" + colIndex;
txbNotas.ClientIDMode = System.Web.UI.ClientIDMode.Static;
txbNotas.CssClass = "text";
txbNotas.MaxLength = 3;
//txbNotas.Attributes["type"] = "Number";
txbNotas.Attributes["min"] = "0";
txbNotas.Attributes["max"] = "10";
txbNotas.Attributes["onkeyup"] = "funcaoImpedirValorAvaliar(this.id);";
txbNotas.Attributes["onblur"] = "funcaoAtualizarMedia(this.id);";
cell.Style.Add("text-align", "center");
txbNotas.Text = dt.Rows[rowIndex][colIndex].ToString();
RequiredFieldValidator rfvTxb = new RequiredFieldValidator();
rfvTxb.ID = "rfvTxb" + rowIndex + "_Col_" + colIndex;
rfvTxb.ControlToValidate = "txtNotasRow_" + rowIndex + "_Col_" + colIndex;
rfvTxb.EnableClientScript = true;
rfvTxb.ErrorMessage = " *";
rfvTxb.ForeColor = System.Drawing.Color.Red;
RangeValidator ranTxb = new RangeValidator();
ranTxb.ID = "ranTxb" + rowIndex + "_Col_" + colIndex;
ranTxb.ControlToValidate = "txtNotasRow_" + rowIndex + "_Col_" + colIndex;
ranTxb.MinimumValue = "0";
ranTxb.MaximumValue = "10";
ranTxb.Type = ValidationDataType.Double;
ranTxb.EnableClientScript = true;
ranTxb.ErrorMessage = " *";
ranTxb.ForeColor = System.Drawing.Color.Red;
cell.Controls.Add(txbNotas);
cell.Controls.Add(rfvTxb);
cell.Controls.Add(ranTxb);
}
row.Cells.Add(cell);
}
table.Rows.Add(row);
}
TableRow rowMedia = new TableRow();
Label lblMedia = new Label();
for (int colIndex = 0; colIndex < colsCount; colIndex++)
{
TableCell cell = new TableCell();
cell.CssClass = "mediaAvaliar";
lblMedia = new Label();
lblMedia.ID = "lblMediaRow_" + table.Rows.Count + "_Col_" + colIndex;
lblMedia.ClientIDMode = System.Web.UI.ClientIDMode.Static;
if (colIndex == 0)
{
lblMedia.Text = "Média Ponderada Individual: ";
}
else
{
lblMedia.Text = " ";
}
cell.Controls.Add(lblMedia);
rowMedia.Cells.Add(cell);
}
table.Rows.Add(rowMedia);
ScriptManager.RegisterStartupScript(this, this.GetType(), "ZebradoGridAvaliar", "ZebradoGridAvaliar();", true);
}
private void crearTabla(int cantTrab, int cantGest)
{
Table _table;
#region variables
_table = new Table();
_table.ID = "tbCapacitacion";
_table.CssClass = "table";
TableHeaderRow _header_fila = new TableHeaderRow();
#endregion
#region cabecera tabla
#region Nro
TableHeaderCell _header_celda = new TableHeaderCell();
_header_celda.Text = "Nro";
_header_celda.CssClass = "text-center";
_header_fila.Cells.Add(_header_celda);
_table.Rows.Add(_header_fila);
#endregion
#region Trabajador
_header_celda = new TableHeaderCell();
_header_celda.Text = "NOMBRE";
_header_celda.CssClass = "text-center";
_header_fila.Cells.Add(_header_celda);
_table.Rows.Add(_header_fila);
#endregion
#region Cedula
_header_celda = new TableHeaderCell();
_header_celda.Text = "DOCUMENTO DE IDENTIDAD";
_header_celda.CssClass = "text-center";
_header_fila.Cells.Add(_header_celda);
_table.Rows.Add(_header_fila);
#endregion
#region cantidad Horas
_header_celda = new TableHeaderCell();
_header_celda.Text = "CANTIDAD HORAS ACUMULADAS";
_header_celda.CssClass = "text-center";
_header_fila.Cells.Add(_header_celda);
_table.Rows.Add(_header_fila);
#endregion
Tuple <int, int> IdEmpSuc = Mgr_Empresa.Get_IdEmpresa_IdSucursal(ObjUsuario, ddlEmpresa, ddlSucursal);
IdEmpresa = IdEmpSuc.Item1;
IdSucursal = IdEmpSuc.Item2;
List <gestion_laboral> gestion_lista = new List <gestion_laboral>();
gestion_lista = Mgr_GestionLaboral.Get_GestionLaboralByCapacitacion(fechaInicial, fechaFinal, IdEmpresa, IdSucursal);
foreach (gestion_laboral gl in gestion_lista)
{
#region Temas
_header_celda = new TableHeaderCell();
string titulo = gl.descripcion + " <br/> " + Convert.ToDateTime(gl.fecha).ToString("dd-MM-yyy") + " Horas:" + gl.cant_horas;
_header_celda.Text = titulo.ToUpperInvariant();
_header_celda.CssClass = "text-center";
_header_fila.Cells.Add(_header_celda);
_table.Rows.Add(_header_fila);
#endregion
}
#endregion
TableCell _fila = new TableCell();
TableRow _columna = new TableRow();
int NumTrab = 1, gestion = 1, HorasAsistio = 0, inaJust = 0, InaInjust = 0, Asistencias = 0;
bool CantHoras = false;
List <trabajador> List_Trab = Mgr_Trabajador.Get_Trabajador(0, 0, Convert.ToInt32(IdSucursal), 0);
foreach (var item1 in List_Trab)
{
HorasAsistio = 0;
CantHoras = false;
List <trabajador_gestion> trab_lista = Mgr_Trabajador.Get_TrabajadoresByCapacitacion(item1.id_trabajador, fechaInicial, fechaFinal);
foreach (var item2 in trab_lista)
{
if (HorasAsistio == 0)
{
#region datos trabajador
_columna = new TableRow();
_columna.ID = "columna" + NumTrab;
_fila = new TableCell();
_fila.Text = "" + (NumTrab);
_columna.Cells.Add(_fila);
_table.Rows.Add(_columna);
_fila = new TableCell();
_fila.Text = string.Empty + (item1.primer_nombre + ' ' + item1.primer_apellido);
_fila.Attributes.Add("style", "white-space: nowrap;");
_columna.Cells.Add(_fila);
_table.Rows.Add(_columna);
_fila = new TableCell();
_fila.Text = string.Empty + (item1.cedula);
_columna.Cells.Add(_fila);
_table.Rows.Add(_columna);
#endregion
}
#region asistencias
_fila = new TableCell();
_fila.ID = "fila" + gestion + "_" + NumTrab;
if (item2.asistencia.Contains("SI"))
{
_fila.Text = "Asistió";
HorasAsistio = HorasAsistio + Convert.ToInt32(item2.gestion_laboral.cant_horas);
_fila.BackColor = System.Drawing.Color.MediumPurple;
Asistencias++;
}
else if (item2.asistencia.Contains("-"))
{
_fila.Text = "Sin Asistencia";
_fila.BackColor = System.Drawing.Color.YellowGreen;
}
else
{
if (item2.asistencia.Contains("Justificada"))
{
_fila.Text = "No Asistió";
_fila.BackColor = System.Drawing.Color.SkyBlue;
inaJust++;
}
else if (item2.asistencia.Contains("Injustificada"))
{
_fila.Text = "No Asistió";
_fila.BackColor = System.Drawing.Color.Tomato;
InaInjust++;
}
}
#endregion
_fila.CssClass = "text-center";
_columna.Cells.Add(_fila);
gestion++;
CantHoras = true;
}
if (CantHoras)
{
_table.Rows.Add(_columna);
_fila = new TableCell();
_fila.Text = "" + HorasAsistio;
_fila.CssClass = "text-center";
_fila.BackColor = System.Drawing.Color.DarkSeaGreen;
_columna.Cells.AddAt(3, _fila);
_table.Rows.Add(_columna);
NumTrab++;
pnTablaCapacitacion.Controls.Add(_table);
}
}
#region Generar la grafica
int totalIna = inaJust + InaInjust;
lblTotalInasistencias.Text = totalIna.ToString();
lblTotalAsistencias.Text = "" + Asistencias;
Double[] yAsistencias = { 0, 0 };
yAsistencias[0] = totalIna;
yAsistencias[1] = Asistencias;
String[] xCadenas = { "Inasistencia", "Asistencia" };
graficoAsistencia.Series["asistencias"].Label = "#PERCENT{P0}";
graficoAsistencia.Series["asistencias"].Points.DataBindXY(xCadenas, yAsistencias);
#endregion
}
private void fillStatisticTable()
{
IList <TblUsers> ilistusers;
ilistusers = TeacherHelper.GetStudentsOfGroup(group);
if (UserId > 0)
{
user = ServerModel.DB.Load <TblUsers>(UserId);
ilistusers.Clear();
ilistusers.Add(user);
}
StatisticTable.Rows.Clear();
TableHeaderRow headerRow = new TableHeaderRow();
TableHeaderCell headerCell = new TableHeaderCell();
headerCell.Text = studentStr;
headerRow.Cells.Add(headerCell);
foreach (TblStages stage in TeacherHelper.StagesOfCurriculum(curriculum))
{
foreach (TblThemes theme in TeacherHelper.ThemesOfStage(stage))
{
headerCell = new TableHeaderCell();
headerCell.Text = theme.Name;
headerRow.Cells.Add(headerCell);
}
}
headerCell = new TableHeaderCell();
headerCell.Text = totalStr;
headerRow.Cells.Add(headerCell);
headerCell = new TableHeaderCell();
headerCell.Text = Translations.StatisticShowController_fillStatisticTable_Percent;
headerRow.Cells.Add(headerCell);
headerCell = new TableHeaderCell();
headerCell.Text = "ECTS";
headerRow.Cells.Add(headerCell);
StatisticTable.Rows.Add(headerRow);
foreach (TblUsers student in ilistusers)
{
var studentRow = new TableRow();
TableCell studentCell = new TableHeaderCell {
HorizontalAlign = HorizontalAlign.Center
};
studentCell.Controls.Add(new HyperLink
{
Text = student.DisplayName,
NavigateUrl = ServerModel.Forms.BuildRedirectUrl(new StatisticShowGraphController
{
GroupID = GroupID,
CurriculumID = curriculum.ID,
UserId = student.ID,
BackUrl = RawUrl
})
});
studentRow.Cells.Add(studentCell);
double pasedCurriculum = 0;
double totalCurriculum = 0;
foreach (TblStages stage in TeacherHelper.StagesOfCurriculum(curriculum))
{
foreach (TblThemes theme in TeacherHelper.ThemesOfStage(stage))
{
double result = 0;
double totalresult = 0;
int learnercount = TeacherHelper.GetLastIndexOfAttempts(student.ID, theme.ID);
TblOrganizations organization;
organization = ServerModel.DB.Load <TblOrganizations>(theme.OrganizationRef);
foreach (TblItems items in TeacherHelper.ItemsOfOrganization(organization))
{
totalresult += Convert.ToDouble(items.Rank);
}
foreach (TblLearnerAttempts attempt in TeacherHelper.AttemptsOfTheme(theme))
{
if (attempt.ID == TeacherHelper.GetLastLearnerAttempt(student.ID, theme.ID))
{
foreach (TblLearnerSessions session in TeacherHelper.SessionsOfAttempt(attempt))
{
CmiDataModel cmiDataModel = new CmiDataModel(session.ID, student.ID, false);
List <TblVarsInteractions> interactionsCollection = cmiDataModel.GetCollection <TblVarsInteractions>("interactions.*.*");
for (int i = 0, j = 0; i < int.Parse(cmiDataModel.GetValue("interactions._count")); i++)
{
for (; j < interactionsCollection.Count && i == interactionsCollection[j].Number; j++)
{
if (interactionsCollection[j].Name == "result")
{
TblItems itm = ServerModel.DB.Load <TblItems>(session.ItemRef);
if (interactionsCollection[j].Value == "correct")
{
result += Convert.ToDouble(itm.Rank);
}
}
}
}
}
}
}
string attmpt = "";
if (learnercount > 0)
{
attmpt = "(" + learnercount.ToString() + " attempt )";
}
else if (learnercount == 0)
{
attmpt = "";
}
studentCell = new TableCell {
HorizontalAlign = HorizontalAlign.Center
};
studentCell.Controls.Add(new HyperLink
{
Text = result + "/" + totalresult + attmpt,
NavigateUrl = ServerModel.Forms.BuildRedirectUrl(new ThemeResultController
{
BackUrl = string.Empty,
LearnerAttemptId = TeacherHelper.GetLastLearnerAttempt(student.ID, theme.ID),
})
});
if (learnercount == 0)
{
studentCell.Enabled = false;
studentCell.BackColor = Color.Yellow;
}
else if (learnercount > 0)
{
studentCell.BackColor = Color.YellowGreen;
}
pasedCurriculum += result;
totalCurriculum += totalresult;
studentRow.Cells.Add(studentCell);
}
}
studentCell = new TableCell
{
HorizontalAlign = HorizontalAlign.Center,
Text = pasedCurriculum + "/" + totalCurriculum
};
studentRow.Cells.Add(studentCell);
studentCell = new TableCell {
HorizontalAlign = HorizontalAlign.Center
};
double temp_total;
if (totalCurriculum != 0)
{
temp_total = pasedCurriculum / totalCurriculum * 100;
}
else
{
temp_total = 0;
}
studentCell.Text = (temp_total).ToString("F2");
studentRow.Cells.Add(studentCell);
studentCell = new TableCell {
HorizontalAlign = HorizontalAlign.Center
};
studentCell.Text = TeacherHelper.ECTS_code(temp_total);
studentRow.Cells.Add(studentCell);
StatisticTable.Rows.Add(studentRow);
}
if (StatisticTable.Rows.Count == 1)
{
StatisticTable.Visible = false;
Message.Value = noStudents;
}
}
/// <summary>
/// Gets new table header cell which contains label and rollback image.
/// </summary>
/// <param name="suffixID">ID suffix</param>
/// <param name="documentID">Document ID</param>
/// <param name="versionID">Version history ID</param>
/// <param name="action">Action</param>
private TableHeaderCell GetRollbackTableHeaderCell(string suffixID, ObjectVersionHistoryInfo objectVersion)
{
TableHeaderCell tblHeaderCell = new TableHeaderCell();
// Label
Label lblValue = new Label();
lblValue.ID = "lbl" + suffixID;
lblValue.Text = HTMLHelper.HTMLEncode(GetVersionNumber(objectVersion.VersionNumber, objectVersion.VersionModifiedWhen));
// Panel
Panel pnlLabel = new Panel();
pnlLabel.ID = "pnlLabel" + suffixID;
pnlLabel.CssClass = "LeftAlign";
pnlLabel.Controls.Add(lblValue);
tblHeaderCell.Controls.Add(pnlLabel);
// Add rollback controls if user authorized to modify selected object
if (UserInfoProvider.IsAuthorizedPerObject(objectVersion.VersionObjectType, PermissionsEnum.Modify, CMSContext.CurrentSiteName, CMSContext.CurrentUser))
{
// Rollback panel
Panel pnlImage = new Panel();
pnlImage.ID = "pnlRollback" + suffixID;
pnlImage.CssClass = "RightAlign";
// Rollback image
Image imgRollback = new Image();
imgRollback.ID = "imgRollback" + suffixID;
string tooltip = null;
string confirmText = null;
// Set image action and description according to roll back type
if (chkDisplayAllData.Checked)
{
tooltip = GetString("objectversioning.versionlist.versionfullrollbacktooltip");
confirmText = GetString("objectversioning.versionlist.confirmfullrollback");
imgRollback.ImageUrl = GetImageUrl(IsCheckedOutByCurrentUser ? "CMSModules/CMS_RecycleBin/restorechilds.png" : "CMSModules/CMS_RecycleBin/restorechildsdisabled.png");
}
else
{
tooltip = GetString("history.versionrollbacktooltip");
confirmText = GetString("Unigrid.ObjectVersionHistory.Actions.Rollback.Confirmation");
imgRollback.ImageUrl = GetImageUrl(IsCheckedOutByCurrentUser ? "Design/Controls/UniGrid/Actions/undo.png" : "Design/Controls/UniGrid/Actions/undodisabled.png");
}
imgRollback.AlternateText = tooltip;
imgRollback.ToolTip = tooltip;
imgRollback.Style.Add("cursor", "pointer");
// Prepare onclick script
if (IsCheckedOutByCurrentUser)
{
var confirmScript = "if (confirm(\"" + confirmText + "\")) { ";
confirmScript += ControlsHelper.GetPostBackEventReference(this, objectVersion.VersionID + "|" + chkDisplayAllData.Checked) + "; return false; }";
imgRollback.Attributes.Add("onclick", confirmScript);
}
pnlImage.Controls.Add(imgRollback);
tblHeaderCell.Controls.Add(pnlImage);
}
return(tblHeaderCell);
}
/// <summary>
/// Generates the permission matrix for the current library.
/// </summary>
private void CreateMatrix()
{
// Get library resource info
if ((ResLibrary != null) && (LibraryInfo != null))
{
// Get permissions for the current library resource
DataSet permissions = PermissionNameInfoProvider.GetResourcePermissions(ResLibrary.ResourceId);
if (DataHelper.DataSourceIsEmpty(permissions))
{
lblInfo.ResourceString = "general.emptymatrix";
lblInfo.Visible = true;
}
else
{
TableRow headerRow = new TableRow();
headerRow.CssClass = "UniGridHead";
TableCell newCell = new TableCell();
TableHeaderCell newHeaderCell = new TableHeaderCell();
newHeaderCell.Text = " ";
newHeaderCell.CssClass = "MatrixHeader";
newHeaderCell.Attributes["style"] = "width:28%;";
headerRow.Cells.Add(newHeaderCell);
DataView dv = permissions.Tables[0].DefaultView;
dv.Sort = "PermissionDisplayName ASC";
// Generate header cells
foreach (DataRowView drv in dv)
{
string permissionName = drv.Row["PermissionName"].ToString();
if (permissionArray.Contains(permissionName.ToLowerCSafe()))
{
newHeaderCell = new TableHeaderCell();
newHeaderCell.CssClass = "MatrixHeader";
newHeaderCell.Attributes["style"] = "width:12%;text-align:center;white-space:nowrap;";
newHeaderCell.Text = HTMLHelper.HTMLEncode(drv.Row["PermissionDisplayName"].ToString());
newHeaderCell.ToolTip = Convert.ToString(drv.Row["PermissionDescription"]);
newHeaderCell.HorizontalAlign = HorizontalAlign.Center;
headerRow.Cells.Add(newHeaderCell);
}
}
// Insert the empty cell at the end
newHeaderCell = new TableHeaderCell();
newHeaderCell.Text = " ";
headerRow.Cells.Add(newHeaderCell);
tblMatrix.Rows.Add(headerRow);
// Render library access permissions
object[,] accessNames = new object[5,2];
accessNames[0, 0] = GetString("security.nobody");
accessNames[0, 1] = SecurityAccessEnum.Nobody;
accessNames[1, 0] = GetString("security.allusers");
accessNames[1, 1] = SecurityAccessEnum.AllUsers;
accessNames[2, 0] = GetString("security.authenticated");
accessNames[2, 1] = SecurityAccessEnum.AuthenticatedUsers;
accessNames[3, 0] = GetString("security.groupmembers");
accessNames[3, 1] = SecurityAccessEnum.GroupMembers;
accessNames[4, 0] = GetString("security.authorizedroles");
accessNames[4, 1] = SecurityAccessEnum.AuthorizedRoles;
TableRow newRow = null;
int rowIndex = 0;
for (int access = 0; access <= accessNames.GetUpperBound(0); access++)
{
SecurityAccessEnum currentAccess = ((SecurityAccessEnum)accessNames[access, 1]);
// If the security isn't displayed as part of group section
if (((currentAccess == SecurityAccessEnum.GroupAdmin) || (currentAccess == SecurityAccessEnum.GroupMembers)) && (!(LibraryInfo.LibraryGroupID > 0)))
{
// Do not render this access item
}
else
{
// Generate cell holding access item name
newRow = new TableRow();
newRow.CssClass = ((rowIndex % 2 == 0) ? "EvenRow" : "OddRow");
newCell = new TableCell();
newCell.CssClass = "MatrixHeader";
newCell.Text = accessNames[access, 0].ToString();
newCell.Wrap = false;
newRow.Cells.Add(newCell);
rowIndex++;
// Render the permissions access items
int permissionIndex = 0;
for (int permission = 0; permission < (tblMatrix.Rows[0].Cells.Count - 2); permission++)
{
newCell = new TableCell();
newCell.HorizontalAlign = HorizontalAlign.Center;
int accessEnum = Convert.ToInt32(accessNames[access, 1]);
// Check if the currently processed access is applied for permission
bool isAllowed = CheckPermissionAccess(accessEnum, permission, tblMatrix.Rows[0].Cells[permission + 1].Text);
// Disable column in roles grid if needed
if ((currentAccess == SecurityAccessEnum.AuthorizedRoles) && !isAllowed)
{
gridMatrix.DisableColumn(permissionIndex);
}
// Insert the radio button for the current permission
string permissionText = tblMatrix.Rows[0].Cells[permission + 1].Text;
string elemId = ClientID + "_" + permission + "_" + access;
newCell.Text = "<label style=\"display:none;\" for=\"" + elemId + "\">" + permissionText + "</label><input type=\"radio\" id=\"" + elemId + "\" name=\"" + permissionText + "\" " + (Enable ? "" : "disabled=\"disabled\"") + " onclick=\"" + Page.ClientScript.GetPostBackEventReference(this, permission + "|" + accessEnum) + "\" " + ((isAllowed) ? "checked = \"checked\"" : "") + "/>";
newCell.Wrap = false;
newRow.Cells.Add(newCell);
permissionIndex++;
}
newCell = new TableCell();
newCell.Text = " ";
newRow.Cells.Add(newCell);
// Add the access row to the table
tblMatrix.Rows.Add(newRow);
}
}
// Get permission matrix for roles of the current site/group
mNoRolesAvailable = !gridMatrix.HasData;
if (!mNoRolesAvailable)
{
// Security - Role separator
newRow = new TableRow();
newCell = new TableCell();
newCell.Text = " ";
newCell.Attributes.Add("colspan", Convert.ToString(tblMatrix.Rows[0].Cells.Count));
newRow.Controls.Add(newCell);
tblMatrix.Rows.Add(newRow);
// Security - Role separator text
newRow = new TableRow();
newCell = new TableCell();
newCell.CssClass = "MatrixLabel";
newCell.Text = GetString("SecurityMatrix.RolesAvailability");
newCell.Attributes.Add("colspan", Convert.ToString(tblMatrix.Rows[0].Cells.Count));
newRow.Controls.Add(newCell);
tblMatrix.Rows.Add(newRow);
}
}
}
}
/// <summary>
/// Reloads control with new data.
/// </summary>
private void ReloadData()
{
tblDocument.Rows.Clear();
DataClassInfo ci = DataClassInfoProvider.GetDataClass(Node.NodeClassName);
if (ci != null)
{
fi = FormHelper.GetFormInfo(ci.ClassName, false);
TableHeaderCell labelCell = new TableHeaderCell();
TableHeaderCell valueCell = null;
TableHeaderCell valueCompare = null;
// Add header column with version number
if (CompareNode == null)
{
labelCell.Text = GetString("General.FieldName");
labelCell.EnableViewState = false;
valueCell = new TableHeaderCell();
valueCell.EnableViewState = false;
valueCell.Text = GetString("General.Value");
// Add table header
AddRow(labelCell, valueCell, "UniGridHead", false);
}
else
{
labelCell.Text = GetString("lock.versionnumber");
valueCell = GetRollbackTableHeaderCell("source", Node.DocumentID, versionHistoryId);
valueCompare = GetRollbackTableHeaderCell("compare", CompareNode.DocumentID, versionCompare);
// Add table header
AddRow(labelCell, valueCell, valueCompare, true, "UniGridHead", false);
}
if (ci.ClassIsCoupledClass)
{
// Add coupled class fields
IDataClass coupleClass = DataClassFactory.NewDataClass(Node.NodeClassName);
if (coupleClass != null)
{
foreach (string col in coupleClass.StructureInfo.ColumnNames)
{
// If comparing with other version and current coupled column is not versioned do not display it
if (!((CompareNode != null) && !(VersionManager.IsVersionedCoupledColumn(Node.NodeClassName, col))))
{
AddField(Node, CompareNode, col);
}
}
}
}
// Add versioned document class fields
IDataClass docClass = DataClassFactory.NewDataClass("cms.document");
if (docClass != null)
{
foreach (string col in docClass.StructureInfo.ColumnNames)
{
// If comparing with other version and current document column is not versioned do not display it
// One exception is DocumentNamePath column which will be displayed even if it is not marked as a versioned column
if (!((CompareNode != null) && (!(VersionManager.IsVersionedDocumentColumn(col) || (col.ToLower() == "documentnamepath")))))
{
AddField(Node, CompareNode, col);
}
}
}
// Add versioned document class fields
IDataClass treeClass = DataClassFactory.NewDataClass("cms.tree");
if (treeClass != null)
{
foreach (string col in treeClass.StructureInfo.ColumnNames)
{
// Do not display cms_tree columns when comparing with other version
// cms_tree columns are not versioned
if (CompareNode == null)
{
AddField(Node, CompareNode, col);
}
}
}
// Add unsorted attachments to the table
AddField(Node, CompareNode, UNSORTED);
}
}
/// <summary>
/// Gets new table header cell which contains label and rollback image.
/// </summary>
/// <param name="suffixID">ID suffix</param>
/// <param name="documentID">Document ID</param>
/// <param name="versionID">Version history ID</param>
/// <param name="action">Action</param>
private TableHeaderCell GetRollbackTableHeaderCell(string suffixID, int documentID, int versionID)
{
TableHeaderCell tblHeaderCell = new TableHeaderCell();
tblHeaderCell.EnableViewState = false;
string tooltip = GetString("history.versionrollbacktooltip");
// Label
Label lblValue = new Label();
lblValue.ID = "lbl" + suffixID;
lblValue.Text = HTMLHelper.HTMLEncode(GetVersionNumber(documentID, versionID));
lblValue.EnableViewState = false;
// Panel
Panel pnlLabel = new Panel();
pnlLabel.ID = "pnlLabel" + suffixID;
pnlLabel.CssClass = "LeftAlign";
pnlLabel.Controls.Add(lblValue);
pnlLabel.EnableViewState = false;
// Rollback image
Image imgRollback = new Image();
imgRollback.ID = "imgRollback" + suffixID;
imgRollback.AlternateText = tooltip;
imgRollback.ToolTip = tooltip;
imgRollback.EnableViewState = false;
// Disable buttons according to permissions
if (!CanApprove || !CanModify || (CheckedOutByAnotherUser && !CanCheckIn))
{
imgRollback.ImageUrl = GetImageUrl("Design/Controls/UniGrid/Actions/undodisabled.png");
imgRollback.Enabled = false;
}
else
{
imgRollback.ImageUrl = GetImageUrl("Design/Controls/UniGrid/Actions/undo.png");
imgRollback.Style.Add("cursor", "pointer");
}
// Prepare onclick script
string confirmScript = "if (confirm(" + ScriptHelper.GetString(GetString("Unigrid.VersionHistory.Actions.Rollback.Confirmation")) + ")) { ";
confirmScript += Page.ClientScript.GetPostBackEventReference(this, versionID.ToString()) + "; return false; }";
imgRollback.Attributes.Add("onclick", confirmScript);
// Rollback panel
Panel pnlImage = new Panel();
pnlImage.EnableViewState = false;
pnlImage.ID = "pnlRollback" + suffixID;
pnlImage.CssClass = "RightAlign";
pnlImage.Controls.Add(imgRollback);
tblHeaderCell.Controls.Add(pnlLabel);
tblHeaderCell.Controls.Add(pnlImage);
return(tblHeaderCell);
}
private void GenerateTable(string studentID)
{
string ID = studentID;
DataTable dt = CreateDataTable1(ID);
//DataTable dt2 = CreatDataTable2();
//DataTable dtBoth = myJoinMethod(dt, dt2, "EvalResponseID", "CourseID");
//System.Diagnostics.Debug.WriteLine(dt.Rows[0][0].ToString());
//System.Diagnostics.Debug.WriteLine(dt.Rows[0][1].ToString());
//System.Diagnostics.Debug.WriteLine(dt.Rows[0][2].ToString());
//System.Diagnostics.Debug.WriteLine(dt.Rows[0][3].ToString());
//System.Diagnostics.Debug.WriteLine(dt.Rows[0][4].ToString());
Table table = new Table();
GridView grid = new GridView();
TableRow row = null;
table.CellSpacing = 20;
table.CellPadding = 10;
table.GridLines = GridLines.Vertical;
// Add the Headers
row = new TableRow();
TableHeaderCell course = new TableHeaderCell();
course.Text = "Class Name";
row.Cells.Add(course);
TableHeaderCell viewEval = new TableHeaderCell();
viewEval.Text = "View Evaluation";
row.Cells.Add(viewEval);
table.Rows.Add(row);
// determine which datatable has more rows so for loop captures everything
int rowCount = dt.Rows.Count;
System.Diagnostics.Debug.WriteLine(rowCount);
for (int i = 0; i < rowCount; i++)
{
System.Diagnostics.Debug.WriteLine(dt.Rows[i][1].ToString());
System.Diagnostics.Debug.WriteLine(dt.Rows[i][4].ToString());
// Row containing the class names that the studentID passed in has taken (EvaluateeEmail to see how many evaluations have been filled out ABOUT a student)
row = new TableRow();
TableCell courseName = new TableCell();
courseName.Text = dt.Rows[i][0].ToString();
row.Cells.Add(courseName);
TableCell eval = new TableCell();
LinkButton evalLink = new LinkButton();
evalLink.Text = "View This Evaluation";
evalLink.Click += evalLink_Click;
evalLink.CommandArgument = dt.Rows[i][5].ToString();
eval.Controls.Add(evalLink);
row.Cells.Add(eval);
table.Rows.Add(row);
}
form1.Controls.Add(table);
}
protected void BindAllSubject(bool initial)
{
BLL.CCOM.Subject bll = new BLL.CCOM.Subject();
try
{
List <Model.CCOM.Subject> subjectList = bll.GetModelList("Major_Agency_id=" + Convert.ToInt32(this.ddlMajor.SelectedItem.Value));
foreach (Model.CCOM.Subject subject in subjectList)
{
subjectDic.Add(subject.Subject_id, subject);
}
}
catch (Exception e)
{
return;
}
//添加表头
TableHeaderRow header = new TableHeaderRow();
this.subjectTable.Controls.Add(header);
TableHeaderCell headerCell1 = new TableHeaderCell();
headerCell1.Text = "标题";
headerCell1.Attributes.Add("width", "26%");
header.Cells.Add(headerCell1);
TableHeaderCell headerCell2 = new TableHeaderCell();
headerCell2.Text = "值类型";
headerCell2.Attributes.Add("width", "16%");
header.Cells.Add(headerCell2);
TableHeaderCell headerCell3 = new TableHeaderCell();
headerCell3.Text = "考试方式";
headerCell3.Attributes.Add("width", "8%");
header.Cells.Add(headerCell3);
TableHeaderCell headerCell4 = new TableHeaderCell();
headerCell4.Text = "管理机构";
headerCell4.Attributes.Add("width", "14%");
header.Cells.Add(headerCell4);
TableHeaderCell headerCell5 = new TableHeaderCell();
headerCell5.Text = "权值";
headerCell5.Attributes.Add("width", "8%");
header.Cells.Add(headerCell5);
TableHeaderCell headerCell6 = new TableHeaderCell();
headerCell6.Text = "描述";
headerCell6.Attributes.Add("width", "16%");
header.Cells.Add(headerCell6);
TableHeaderCell headerCell7 = new TableHeaderCell();
headerCell7.Text = "操作";
headerCell7.Attributes.Add("width", "12%");
header.Cells.Add(headerCell7);
BLL.CCOM.Period pbll = new BLL.CCOM.Period();
var pmodel = pbll.GetModel("Period_state=1");
int periodId = pmodel.Period_id;
if (this.ddlMajor.SelectedItem.Value == "#")
{
this.subjectTable.Controls.Clear();
return;
}
int majorId = Convert.ToInt32(this.ddlMajor.SelectedItem.Value);
root = bll.GetModel("Major_Agency_id=" + majorId + "and Subject_level=0");
if (root == null)
{
Model.CCOM.Subject model = new Model.CCOM.Subject();
model.Major_Agency_id = majorId;
model.Period_id = periodId;
model.Fs_id = 0;
model.Subject_weight = 0;
model.Value_type = 0;
model.Subject_level = 0;
model.Subject_title = "";
int Fsid = bll.Add(model);
root = bll.GetModel(Fsid);
}
BindSubject(root, true, initial, 0);
}
//function to retrive questions
public void GetQuestions()
{
DataTable tab = new DataTable();
BLL obj = new BLL();
tab.Rows.Clear();
if (DropDownListType.SelectedIndex > 0)
{
tab = obj.GetQuestionsByType(int.Parse(DropDownListType.SelectedValue));
}
else
{
tab = obj.GetAllQuestions();
}
int serialNo = 1;
if (tab.Rows.Count > 0)
{
tableQA.Rows.Clear();
for (int cnt = 0; cnt < tab.Rows.Count; cnt++)
{
TableRow row1 = new TableRow();
TableCell row1_cell1 = new TableCell();
row1_cell1.Font.Size = 10;
row1_cell1.Text = cnt + serialNo + ".";
row1.Controls.Add(row1_cell1);
TableCell cell_topic = new TableCell();
//cell_topic.Width = 750;
HyperLink li = new HyperLink();
li.ID = tab.Rows[cnt]["QuestionId"].ToString();
li.Text = tab.Rows[cnt]["Question"].ToString();
li.NavigateUrl = string.Format("Answers.aspx?Question={0}&QuestionId={1}", tab.Rows[cnt]["Question"].ToString(), tab.Rows[cnt]["QuestionId"].ToString());
cell_topic.Controls.Add(li);
row1.Controls.Add(cell_topic);
TableRow row2 = new TableRow();
TableCell row2Cell1 = new TableCell();
row2Cell1.Text = " ";
row2.Controls.Add(row2Cell1);
TableCell row2Cell2 = new TableCell();
row2Cell2.Text = "<br/>";
row2.Controls.Add(row2Cell2);
TableRow row3 = new TableRow();
TableCell row3cell1 = new TableCell();
row3cell1.Text = " ";
row3.Controls.Add(row3cell1);
DataTable tab50 = new DataTable();
tab50.Rows.Clear();
tab50 = obj.GetMemberById(int.Parse(tab.Rows[cnt]["MemberId"].ToString()));
TableCell row3cell2 = new TableCell();
row3cell2.Text = "Posted By : " + tab50.Rows[0]["FName"].ToString() + " ," + "Posted Date : " + tab.Rows[cnt]["PostedDate"].ToString() + "<br/>";
row3.Controls.Add(row3cell2);
TableRow row4 = new TableRow();
TableCell row4cell1 = new TableCell();
row4cell1.Text = " ";
row4.Controls.Add(row4cell1);
// if (DropDownListType.SelectedIndex > 0)
// {
TableCell row10_cell1 = new TableCell();
row10_cell1.HorizontalAlign = HorizontalAlign.Right;
Button btnDelete = new Button();
btnDelete.ID = "Del~" + tab.Rows[cnt]["QuestionId"].ToString();
btnDelete.Text = "Delete";
btnDelete.OnClientClick = "return confirm('Are your sure want to delete?')";
btnDelete.Click += new EventHandler(btnDelete_Click);
row10_cell1.Controls.Add(btnDelete);
row4.Controls.Add(row10_cell1);
// }
TableRow row10 = new TableRow();
TableCell row10cell1 = new TableCell();
row10cell1.ColumnSpan = 10;
row10cell1.Width = 900;
row10cell1.Text = "<hr/>";
row10.Controls.Add(row10cell1);
tableQA.Controls.Add(row1);
tableQA.Controls.Add(row2);
tableQA.Controls.Add(row3);
tableQA.Controls.Add(row4);
tableQA.Controls.Add(row10);
}
}
else
{
tableQA.Rows.Clear();
TableHeaderRow row = new TableHeaderRow();
TableHeaderCell cell = new TableHeaderCell();
cell.ForeColor = System.Drawing.Color.Red;
if (DropDownListType.SelectedIndex > 0)
{
cell.Text = "No Questions Found for the type " + DropDownListType.SelectedItem.Text;
}
else
{
cell.Text = "No Questions Found";
}
row.Controls.Add(cell);
tableQA.Controls.Add(row);
}
}
public Table[] vratiTabelaProizvodi(OracleDataReader drO)
{
int i = 1;
int j = 0;
int pat = 1;
Table[] nova = new Table[100];
TableHeaderCell head;
TableCell cel;
TableRow row = new TableRow();
TableFooterRow foot;
nova[j] = new Table();
while (drO.Read())
{
if (pat == 1)
{
//nova[j] = new Table();
head = new TableHeaderCell();
head.Text = "Бр";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Производ_ID";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Attributes.Add("class", "hide");
head.Text = "Тип_ID";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Attributes.Add("class", "hide");
head.Text = "Данок_ID";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Име";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Група";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Данок";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Цена";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Колинчина";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Потврди";
row.Controls.Add(head);
nova[j].Controls.Add(row);
pat = 2;
}
if (i > 10)
{
i = 1;
j++;
row = new TableRow();
nova[j] = new Table();
head = new TableHeaderCell();
head.Text = "Бр";
head.Attributes.Add("class", "hide");
head = new TableHeaderCell();
head.Text = "Производ_ID";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Тип_ID";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Данок_ID";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Име";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Група";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Данок";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Цена";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Колинчина";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Потврди";
row.Controls.Add(head);
nova[j].Controls.Add(row);
}
row = new TableRow();
cel = new TableCell();
cel.Text = i.ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["IDP"].ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["IDT"].ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["IDD"].ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["Име"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["Група"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["Данок"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["Цена"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
TextBox kolicinaTextBox = new TextBox();
kolicinaTextBox.Text = "0";
kolicinaTextBox.Width = Unit.Pixel(70);
kolicinaTextBox.Style.Add("text-align", "right");
kolicinaTextBox.Attributes.Add("onfocus", "proveriVlez(this)");
kolicinaTextBox.Attributes.Add("onblur", "proveriIzlez(this)");
kolicinaTextBox.ID = "kolicinaTextBox" + i.ToString();
cel.Controls.Add(kolicinaTextBox);
row.Controls.Add(cel);
cel = new TableCell();
Button insertBtn = new Button();
insertBtn.Text = "Додади";
insertBtn.ID = "dodadiBtn." + j.ToString() + "." + i.ToString();
insertBtn.Click += insertKopce;
cel.Controls.Add(insertBtn);
row.Controls.Add(cel);
nova[j].Controls.Add(row);
i++;
}
Table[] kraj = new Table[j + 1];
if (nova[0].Rows.Count > 0)
{
for (int w = 0; w <= j; w++)
{
foot = new TableFooterRow();
cel = new TableCell();
cel.ColumnSpan = 5;
for (int q = 1; q <= j + 1; q++)
{
Button kopce = new Button();
kopce.ID = q.ToString();
kopce.Click += new EventHandler(kopce_Click);
kopce.Text = q.ToString();
cel.Controls.Add(kopce);
}
foot.Controls.Add(cel);
if (nova[w] != null)
nova[w].Rows.Add(foot);
kraj[w] = nova[w];
}
}
else
{
foot = new TableFooterRow();
cel = new TableCell();
cel.Text = " Нема такви податоци во производи ";
cel.BorderColor = System.Drawing.Color.White;
cel.BorderWidth = Unit.Pixel(2);
cel.BorderStyle = BorderStyle.Solid;
foot.Controls.Add(cel);
nova[0].Rows.Add(foot);
kraj[0] = nova[0];
}
return kraj;
}
/// <summary>
/// Page pre-render
/// </summary>
protected void Page_PreRender(object sender, EventArgs e)
{
if ((Version != null) && (VersionCompare != null))
{
// Prepare header with rollback controls
TableRow tr = new TableHeaderRow() { TableSection = TableRowSection.TableHeader };
tr.CssClass = "unigrid-head";
TableHeaderCell th = new TableHeaderCell();
th.Text = GetString("lock.versionnumber");
tr.Cells.Add(th);
// Switch header sides if necessary
if (VersionCompare.VersionID < Version.VersionID)
{
tr.Cells.Add(GetRollbackTableHeaderCell("compare", VersionCompare));
tr.Cells.Add(GetRollbackTableHeaderCell("source", Version));
}
else
{
tr.Cells.Add(GetRollbackTableHeaderCell("source", Version));
tr.Cells.Add(GetRollbackTableHeaderCell("compare", VersionCompare));
}
if ((viewDataSet.DataSet.Tables.Count <= 1) && (viewDataSet.CompareDataSet.Tables.Count <= 1))
{
viewDataSet.Table.Rows.RemoveAt(0);
}
viewDataSet.Table.Rows.AddAt(0, tr);
}
}
/// <summary>
/// Generates the permission matrix for the current library.
/// </summary>
private void CreateMatrix()
{
// Get library resource info
if ((ResLibrary != null) && (LibraryInfo != null))
{
// Get permissions for the current library resource
DataSet permissions = PermissionNameInfoProvider.GetResourcePermissions(ResLibrary.ResourceID);
if (DataHelper.DataSourceIsEmpty(permissions))
{
lblInfo.ResourceString = "general.emptymatrix";
lblInfo.Visible = true;
}
else
{
TableRow headerRow = new TableRow();
headerRow.TableSection = TableRowSection.TableHeader;
headerRow.CssClass = "unigrid-head";
TableHeaderCell newHeaderCell = new TableHeaderCell();
newHeaderCell.CssClass = "first-column";
headerRow.Cells.Add(newHeaderCell);
DataView dv = permissions.Tables[0].DefaultView;
dv.Sort = "PermissionDisplayName ASC";
// Generate header cells
foreach (DataRowView drv in dv)
{
string permissionName = drv.Row["PermissionName"].ToString();
if (permissionArray.Contains(permissionName.ToLowerCSafe()))
{
newHeaderCell = new TableHeaderCell();
newHeaderCell.CssClass = "matrix-header";
newHeaderCell.Text = HTMLHelper.HTMLEncode(drv.Row["PermissionDisplayName"].ToString());
newHeaderCell.ToolTip = Convert.ToString(drv.Row["PermissionDescription"]);
headerRow.Cells.Add(newHeaderCell);
}
}
tblMatrix.Rows.Add(headerRow);
// Render library access permissions
object[,] accessNames = new object[5, 2];
accessNames[0, 0] = GetString("security.nobody");
accessNames[0, 1] = SecurityAccessEnum.Nobody;
accessNames[1, 0] = GetString("security.allusers");
accessNames[1, 1] = SecurityAccessEnum.AllUsers;
accessNames[2, 0] = GetString("security.authenticated");
accessNames[2, 1] = SecurityAccessEnum.AuthenticatedUsers;
accessNames[3, 0] = GetString("security.groupmembers");
accessNames[3, 1] = SecurityAccessEnum.GroupMembers;
accessNames[4, 0] = GetString("security.authorizedroles");
accessNames[4, 1] = SecurityAccessEnum.AuthorizedRoles;
TableRow newRow;
int rowIndex = 0;
for (int access = 0; access <= accessNames.GetUpperBound(0); access++)
{
SecurityAccessEnum currentAccess = ((SecurityAccessEnum)accessNames[access, 1]);
// If the security isn't displayed as part of group section
if (((currentAccess == SecurityAccessEnum.GroupAdmin) || (currentAccess == SecurityAccessEnum.GroupMembers)) && (!(LibraryInfo.LibraryGroupID > 0)))
{
// Do not render this access item
}
else
{
// Generate cell holding access item name
newRow = new TableRow();
TableCell newCell = new TableCell();
newCell.CssClass = "matrix-header";
newCell.Text = accessNames[access, 0].ToString();
newRow.Cells.Add(newCell);
rowIndex++;
// Render the permissions access items
int permissionIndex = 0;
for (int permission = 0; permission < (tblMatrix.Rows[0].Cells.Count - 1); permission++)
{
newCell = new TableCell();
int accessEnum = Convert.ToInt32(accessNames[access, 1]);
// Check if the currently processed access is applied for permission
bool isAllowed = CheckPermissionAccess(accessEnum, permission, tblMatrix.Rows[0].Cells[permission + 1].Text);
// Disable column in roles grid if needed
if ((currentAccess == SecurityAccessEnum.AuthorizedRoles) && !isAllowed)
{
gridMatrix.DisableColumn(permissionIndex);
}
// Insert the radio button for the current permission
var radio = new CMSRadioButton
{
Checked = isAllowed,
Enabled = Enable,
};
radio.Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(this, permission + "|" + accessEnum));
newCell.Controls.Add(radio);
newRow.Cells.Add(newCell);
permissionIndex++;
}
// Add the access row to the table
tblMatrix.Rows.Add(newRow);
}
}
// Check if media library has some roles assigned
headTitle.Visible = gridMatrix.HasData;
}
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow && e.Row.RowState == DataControlRowState.Normal || e.Row.RowState==DataControlRowState.Alternate)
{
string live = ((Label)(e.Row.FindControl("Label1"))).Text;
DateTime live1 = DateTime.Parse(live.ToString(), System.Globalization.CultureInfo.CreateSpecificCulture("en-CA"));
SqlDataAdapter adp = new SqlDataAdapter("select * from fc011 where dt='" + live1 + "'", ConfigurationManager.ConnectionStrings["ForestConnectionString"].ConnectionString);
DataSet ds = new DataSet();
adp.Fill(ds);
if (ds.Tables[0].Rows.Count != 0)
{
((Label)(e.Row.FindControl("Label2"))).Text = ds.Tables[0].Rows[0][2].ToString();
((Label)(e.Row.FindControl("Label3"))).Text = ds.Tables[0].Rows[0][3].ToString();
((Label)(e.Row.FindControl("Label4"))).Text = ds.Tables[0].Rows[0][4].ToString();
((Label)(e.Row.FindControl("Label5"))).Text = ds.Tables[0].Rows[0][5].ToString();
((Label)(e.Row.FindControl("Label6"))).Text = ds.Tables[0].Rows[0][6].ToString();
((Label)(e.Row.FindControl("Label7"))).Text = ds.Tables[0].Rows[0][7].ToString();
((Label)(e.Row.FindControl("Label8"))).Text = ds.Tables[0].Rows[0][8].ToString();
((Label)(e.Row.FindControl("Label9"))).Text = ds.Tables[0].Rows[0][9].ToString();
((Label)(e.Row.FindControl("Label10"))).Text = ds.Tables[0].Rows[0][10].ToString();
((Label)(e.Row.FindControl("Label11"))).Text = ds.Tables[0].Rows[0][11].ToString();
((Label)(e.Row.FindControl("Label12"))).Text = ds.Tables[0].Rows[0][12].ToString();
((Label)(e.Row.FindControl("Label13"))).Text = ds.Tables[0].Rows[0][13].ToString();
((Label)(e.Row.FindControl("Label14"))).Text = ds.Tables[0].Rows[0][14].ToString();
}
}
if (e.Row.RowState == DataControlRowState.Edit )
{
DateTime dt= Convert.ToDateTime(DateTime.Parse( ((Label)(e.Row.FindControl("Label1"))).Text, System.Globalization.CultureInfo.CreateSpecificCulture("en-CA")));
//string live =((Label)(e.Row.FindControl("Label1"))).Text;
// DateTime live1 = DateTime.Parse(live.ToString(), System.Globalization.CultureInfo.CreateSpecificCulture("en-CA"));
SqlDataAdapter adp = new SqlDataAdapter("select * from fc011 where dt='" + dt + "'", ConfigurationManager.ConnectionStrings["ForestConnectionString"].ConnectionString);
DataSet ds = new DataSet();
adp.Fill(ds);
if (ds.Tables[0].Rows.Count != 0)
{
//((TextBox)(e.Row.FindControl("TextBox1"))).Text = ds.Tables[0].Rows[0][2].ToString();
//((TextBox)(e.Row.FindControl("TextBox2"))).Text = ds.Tables[0].Rows[0][3].ToString();
//((TextBox)(e.Row.FindControl("TextBox3"))).Text = ds.Tables[0].Rows[0][4].ToString();
//((TextBox)(e.Row.FindControl("TextBox4"))).Text = ds.Tables[0].Rows[0][5].ToString();
//((TextBox)(e.Row.FindControl("TextBox5"))).Text = ds.Tables[0].Rows[0][6].ToString();
//((TextBox)(e.Row.FindControl("TextBox6"))).Text = ds.Tables[0].Rows[0][7].ToString();
//((TextBox)(e.Row.FindControl("TextBox7"))).Text = ds.Tables[0].Rows[0][8].ToString();
//((TextBox)(e.Row.FindControl("TextBox8"))).Text = ds.Tables[0].Rows[0][9].ToString();
//((TextBox)(e.Row.FindControl("TextBox9"))).Text = ds.Tables[0].Rows[0][10].ToString();
//((TextBox)(e.Row.FindControl("TextBox10"))).Text = ds.Tables[0].Rows[0][11].ToString();
//((TextBox)(e.Row.FindControl("TextBox11"))).Text = ds.Tables[0].Rows[0][12].ToString();
//((TextBox)(e.Row.FindControl("TextBox12"))).Text = ds.Tables[0].Rows[0][13].ToString();
//((TextBox)(e.Row.FindControl("TextBox13"))).Text = ds.Tables[0].Rows[0][14].ToString();
//((TextBox)(e.Row.FindControl("TextBox14"))).Text = ds.Tables[0].Rows[0][15].ToString();
//((TextBox)(e.Row.FindControl("TextBox15"))).Text = ds.Tables[0].Rows[0][16].ToString();
//((TextBox)(e.Row.FindControl("TextBox16"))).Text = ds.Tables[0].Rows[0][17].ToString();
//((TextBox)(e.Row.FindControl("TextBox17"))).Text = ds.Tables[0].Rows[0][18].ToString();
//((TextBox)(e.Row.FindControl("TextBox18"))).Text = ds.Tables[0].Rows[0][19].ToString();
//((TextBox)(e.Row.FindControl("TextBox19"))).Text = ds.Tables[0].Rows[0][20].ToString();
//((TextBox)(e.Row.FindControl("TextBox20"))).Text = ds.Tables[0].Rows[0][21].ToString();
//((TextBox)(e.Row.FindControl("TextBox21"))).Text = ds.Tables[0].Rows[0][22].ToString();
//((Label)(e.Row.FindControl("Label1"))).Text = dt.ToString("dd/MM/yyyy");
////((Label)(e.Row.FindControl("TextBox23"))).Text = (Convert.ToDecimal(ds.Tables[0].Rows[0][6]) + Convert.ToDecimal(ds.Tables[0].Rows[0][8]) + Convert.ToDecimal(ds.Tables[0].Rows[0][10]) + Convert.ToDecimal(ds.Tables[0].Rows[0][12]) + Convert.ToDecimal(ds.Tables[0].Rows[0][14]) + Convert.ToDecimal(ds.Tables[0].Rows[0][16]) + Convert.ToDecimal(ds.Tables[0].Rows[0][18]) + Convert.ToDecimal(ds.Tables[0].Rows[0][20]) + Convert.ToDecimal(ds.Tables[0].Rows[0][22])).ToString();
//((TextBox)(e.Row.FindControl("TextBox24"))).Text = ds.Tables[0].Rows[0][25].ToString();
//((TextBox)(e.Row.FindControl("TextBox25"))).Text = ds.Tables[0].Rows[0][26].ToString();
//((TextBox)(e.Row.FindControl("TextBox26"))).Text = ds.Tables[0].Rows[0][27].ToString();
}
else
{
//((TextBox)(e.Row.FindControl("TextBox1"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox2"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox3"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox4"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox5"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox6"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox7"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox8"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox9"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox10"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox11"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox12"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox13"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox14"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox15"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox16"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox17"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox18"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox19"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox20"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox21"))).Text = 0.ToString();
////((Label)(e.Row.FindControl("TextBox22"))).Text = (Convert.ToDecimal(ds.Tables[0].Rows[0][5]) + Convert.ToDecimal(ds.Tables[0].Rows[0][7]) + Convert.ToDecimal(ds.Tables[0].Rows[0][9]) + Convert.ToDecimal(ds.Tables[0].Rows[0][11]) + Convert.ToDecimal(ds.Tables[0].Rows[0][13]) + Convert.ToDecimal(ds.Tables[0].Rows[0][15]) + Convert.ToDecimal(ds.Tables[0].Rows[0][17]) + Convert.ToDecimal(ds.Tables[0].Rows[0][19]) + Convert.ToDecimal(ds.Tables[0].Rows[0][21])).ToString();
////((Label)(e.Row.FindControl("TextBox23"))).Text = (Convert.ToDecimal(ds.Tables[0].Rows[0][6]) + Convert.ToDecimal(ds.Tables[0].Rows[0][8]) + Convert.ToDecimal(ds.Tables[0].Rows[0][10]) + Convert.ToDecimal(ds.Tables[0].Rows[0][12]) + Convert.ToDecimal(ds.Tables[0].Rows[0][14]) + Convert.ToDecimal(ds.Tables[0].Rows[0][16]) + Convert.ToDecimal(ds.Tables[0].Rows[0][18]) + Convert.ToDecimal(ds.Tables[0].Rows[0][20]) + Convert.ToDecimal(ds.Tables[0].Rows[0][22])).ToString();
//((TextBox)(e.Row.FindControl("TextBox24"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox25"))).Text = 0.ToString();
//((TextBox)(e.Row.FindControl("TextBox26"))).Text = 0.ToString();
}
}
if (e.Row.RowType == DataControlRowType.Header)
{
GridView gv = sender as GridView;
GridViewRow row = new GridViewRow(0, -1, DataControlRowType.Header, DataControlRowState.Normal);
GridViewRow row3 = new GridViewRow(4, 4, DataControlRowType.Header, DataControlRowState.Normal);
GridViewRow row1 = new GridViewRow(0, -1, DataControlRowType.Header, DataControlRowState.Normal);
Table t = (Table)GridView1.Controls[0];
if (gv.HasControls())
{
row.HorizontalAlign = HorizontalAlign.Center;
row1.HorizontalAlign = HorizontalAlign.Center;
TableCell FileDate1 = new TableHeaderCell();
FileDate1.Text = "Date";
FileDate1.HorizontalAlign = HorizontalAlign.Center;
row1.Cells.Add(FileDate1);
TableCell FileDate2 = new TableHeaderCell();
FileDate2.Text = "Tins";
FileDate2.HorizontalAlign = HorizontalAlign.Center;
row1.Cells.Add(FileDate2);
TableCell FileDate3 = new TableHeaderCell();
FileDate3.Text = "Drums";
FileDate3.HorizontalAlign = HorizontalAlign.Center;
row1.Cells.Add(FileDate3);
TableCell FileDate4 = new TableHeaderCell();
FileDate4.Text = "Net Wt with Sakki";
row1.Cells.Add(FileDate4);
TableCell FileDate5 = new TableHeaderCell();
FileDate5.Text = "X";
FileDate5.ColumnSpan = 2;
row3.HorizontalAlign = HorizontalAlign.Center;
TableCell FileDate51 = new TableHeaderCell();
FileDate51.Text = "";
FileDate51.ColumnSpan = 4;
row3.Cells.Add(FileDate51);
TableCell FileDate52 = new TableHeaderCell();
FileDate52.Text = "TPB";
row3.Cells.Add(FileDate52);
TableCell FileDate53 = new TableHeaderCell();
FileDate53.Text = "wt.";
row3.Cells.Add(FileDate53);
TableCell FileDate54 = new TableHeaderCell();
FileDate54.Text = "TPB";
row3.Cells.Add(FileDate54);
TableCell FileDate55 = new TableHeaderCell();
FileDate55.Text = "wt.";
row3.Cells.Add(FileDate55);
TableCell FileDate56 = new TableHeaderCell();
FileDate56.Text = "TPB";
row3.Cells.Add(FileDate56);
TableCell FileDate57 = new TableHeaderCell();
FileDate57.Text = "wt.";
row3.Cells.Add(FileDate57);
TableCell FileDate58 = new TableHeaderCell();
FileDate58.Text = "TPB";
row3.Cells.Add(FileDate58);
TableCell FileDate59 = new TableHeaderCell();
FileDate59.Text = "wt.";
row3.Cells.Add(FileDate59);
TableCell FileDate60 = new TableHeaderCell();
FileDate60.Text = "TPB";
row3.Cells.Add(FileDate60);
TableCell FileDate61 = new TableHeaderCell();
FileDate61.Text = "wt.";
row3.Cells.Add(FileDate61);
TableCell FileDate62 = new TableHeaderCell();
FileDate62.Text = "TPB";
row3.Cells.Add(FileDate62);
TableCell FileDate63 = new TableHeaderCell();
FileDate63.Text = "wt.";
row3.Cells.Add(FileDate63);
TableCell FileDate64 = new TableHeaderCell();
FileDate64.Text = "TPB";
row3.Cells.Add(FileDate64);
TableCell FileDate65 = new TableHeaderCell();
FileDate65.Text = "wt.";
row3.Cells.Add(FileDate65);
TableCell FileDate66 = new TableHeaderCell();
FileDate66.Text = "TPB";
row3.Cells.Add(FileDate66);
TableCell FileDate67 = new TableHeaderCell();
FileDate67.Text = "wt.";
row3.Cells.Add(FileDate67);
TableCell FileDate68 = new TableHeaderCell();
FileDate68.Text = "TPB";
row3.Cells.Add(FileDate68);
TableCell FileDate69 = new TableHeaderCell();
FileDate69.Text = "wt.";
row3.Cells.Add(FileDate69);
TableCell FileDate70 = new TableHeaderCell();
FileDate70.Text = "TPB";
row3.Cells.Add(FileDate70);
TableCell FileDate71 = new TableHeaderCell();
FileDate71.Text = "wt.";
row3.Cells.Add(FileDate71);
TableCell FileDate72 = new TableHeaderCell();
FileDate72.Text = "";
FileDate72.ColumnSpan = 4;
row3.Cells.Add(FileDate72);
row1.Cells.Add(FileDate5);
TableCell FileDate6 = new TableHeaderCell();
FileDate6.Text = "WW";
FileDate6.ColumnSpan = 2;
row1.Cells.Add(FileDate6);
TableCell FileDate7 = new TableHeaderCell();
FileDate7.Text = "WG";
FileDate7.ColumnSpan = 2;
row1.Cells.Add(FileDate7);
TableCell FileDate8 = new TableHeaderCell();
FileDate8.Text = "N";
FileDate8.ColumnSpan = 2;
row1.Cells.Add(FileDate8);
TableCell FileDate9 = new TableHeaderCell();
FileDate9.Text = "M";
FileDate9.ColumnSpan = 2;
row1.Cells.Add(FileDate9);
TableCell FileDate10 = new TableHeaderCell();
FileDate10.Text = "K";
FileDate10.ColumnSpan = 2;
row1.Cells.Add(FileDate10);
TableCell FileDate11 = new TableHeaderCell();
FileDate11.Text = "H";
FileDate11.ColumnSpan = 2;
row1.Cells.Add(FileDate11);
TableCell FileDate12 = new TableHeaderCell();
FileDate12.Text = "D";
FileDate12.ColumnSpan = 2;
row1.Cells.Add(FileDate12);
TableCell FileDate13 = new TableHeaderCell();
FileDate13.Text = "B";
FileDate13.ColumnSpan = 2;
row1.Cells.Add(FileDate13);
TableCell FileDate14 = new TableHeaderCell();
FileDate14.Text = "Total";
FileDate14.ColumnSpan = 2;
row1.Cells.Add(FileDate14);
TableCell FileDate15 = new TableHeaderCell();
FileDate15.Text = "T.Oil";
row1.Cells.Add(FileDate15);
TableCell FileDate16 = new TableHeaderCell();
FileDate16.Text = "Sign of production foreman";
row1.Cells.Add(FileDate16);
TableCell FileDate17 = new TableHeaderCell();
FileDate17.Text = "Sign of factory manager";
row1.Cells.Add(FileDate17);
TableCell FileDate17a = new TableHeaderCell();
FileDate17a.Text = "";
row1.Cells.Add(FileDate17a);
// Adding Cells
TableCell FileDate = new TableHeaderCell();
FileDate.Text = "Resin receipts for production";
FileDate.ColumnSpan = 3;
row.Cells.Add(FileDate);
TableCell cell = new TableHeaderCell();
cell.ColumnSpan = 25; // ********
cell.Text = "Production figures Rosin For the month of";
row.Cells.Add(cell);
//}
}
//t.Rows.AddAt(0, row3);
//t.Rows.AddAt(0, row1);
//t.Rows.AddAt(0, row);
//((Table)GridView1.Controls[0]).Rows.AddAt(1, row);
//((Table)GridView1.Controls[0]).Rows.AddAt(1, row1);
//((Table)GridView1.Controls[0]).Rows.AddAt(1, row3);
}
}
/// <summary>
/// Creates table.
/// </summary>
private void CreateTable(bool useDefaultValue)
{
Table table = new Table();
table.CssClass = "table table-hover";
table.CellPadding = -1;
table.CellSpacing = -1;
// Create table header
TableHeaderRow topHeader = new TableHeaderRow();
TableHeaderRow header = new TableHeaderRow();
topHeader.TableSection = TableRowSection.TableHeader;
header.TableSection = TableRowSection.TableHeader;
AddTableHeaderCell(topHeader, "");
AddTableHeaderCell(topHeader, GetString("srch.local"), false, 3);
AddTableHeaderCell(header, GetString("srch.settings.fieldname"), true);
AddTableHeaderCell(header, GetString("development.content"), true);
AddTableHeaderCell(header, GetString("srch.settings.searchable"), true);
AddTableHeaderCell(header, GetString("srch.settings.tokenized"), true);
if (DisplayAzureFields)
{
AddTableHeaderCell(topHeader, GetString("srch.azure"), false, 6);
AddTableHeaderCell(header, GetString("srch.settings." + AzureSearchFieldFlags.CONTENT), true);
AddTableHeaderCell(header, GetString("srch.settings." + AzureSearchFieldFlags.RETRIEVABLE), true);
AddTableHeaderCell(header, GetString("srch.settings." + AzureSearchFieldFlags.SEARCHABLE), true);
AddTableHeaderCell(header, GetString("srch.settings." + AzureSearchFieldFlags.FACETABLE), true);
AddTableHeaderCell(header, GetString("srch.settings." + AzureSearchFieldFlags.FILTERABLE), true);
AddTableHeaderCell(header, GetString("srch.settings." + AzureSearchFieldFlags.SORTABLE), true);
}
if (DisplayIField)
{
AddTableHeaderCell(topHeader, GetString("general.general"));
AddTableHeaderCell(header, GetString("srch.settings.ifield"), true);
}
var thc = new TableHeaderCell();
thc.CssClass = "main-column-100";
topHeader.Cells.Add(thc);
thc = new TableHeaderCell();
thc.CssClass = "main-column-100";
header.Cells.Add(thc);
table.Rows.Add(topHeader);
table.Rows.Add(header);
pnlContent.Controls.Add(table);
// Create table content
if ((mAttributes != null) && (mAttributes.Count > 0))
{
// Create row for each field
foreach (ColumnDefinition column in mAttributes)
{
SearchSettingsInfo ssi = null;
TableRow tr = new TableRow();
if (!DataHelper.DataSourceIsEmpty(mInfos))
{
DataRow[] dr = mInfos.Tables[0].Select("name = '" + column.ColumnName + "'");
if ((dr.Length > 0) && (mSearchSettings != null))
{
ssi = mSearchSettings.GetSettingsInfo((string)dr[0]["id"]);
}
}
// Add cell with field name
TableCell tc = new TableCell();
Label lbl = new Label();
lbl.Text = column.ColumnName;
tc.Controls.Add(lbl);
tr.Cells.Add(tc);
var defaultSearchSettings = useDefaultValue ? SearchHelper.CreateDefaultSearchSettings(column.ColumnName, column.ColumnType) : null;
tr.Cells.Add(CreateTableCell(SearchSettings.CONTENT, column, useDefaultValue ? defaultSearchSettings.GetFlag(SearchSettings.CONTENT) : ssi?.GetFlag(SearchSettings.CONTENT) ?? false, "development.content"));
tr.Cells.Add(CreateTableCell(SearchSettings.SEARCHABLE, column, useDefaultValue ? defaultSearchSettings.GetFlag(SearchSettings.SEARCHABLE) : ssi?.GetFlag(SearchSettings.SEARCHABLE) ?? false, "srch.settings.searchable"));
tr.Cells.Add(CreateTableCell(SearchSettings.TOKENIZED, column, useDefaultValue ? defaultSearchSettings.GetFlag(SearchSettings.TOKENIZED) : ssi?.GetFlag(SearchSettings.TOKENIZED) ?? false, "srch.settings.tokenized"));
if (DisplayAzureFields)
{
tr.Cells.Add(CreateTableCell(AzureSearchFieldFlags.CONTENT, column, useDefaultValue ? defaultSearchSettings.GetFlag(AzureSearchFieldFlags.CONTENT) : ssi?.GetFlag(AzureSearchFieldFlags.CONTENT) ?? false, "srch.settings." + AzureSearchFieldFlags.CONTENT));
tr.Cells.Add(CreateTableCell(AzureSearchFieldFlags.RETRIEVABLE, column, useDefaultValue ? defaultSearchSettings.GetFlag(AzureSearchFieldFlags.RETRIEVABLE) : ssi?.GetFlag(AzureSearchFieldFlags.RETRIEVABLE) ?? false, "srch.settings." + AzureSearchFieldFlags.RETRIEVABLE));
tr.Cells.Add(CreateTableCell(AzureSearchFieldFlags.SEARCHABLE, column, useDefaultValue ? defaultSearchSettings.GetFlag(AzureSearchFieldFlags.SEARCHABLE) : ssi?.GetFlag(AzureSearchFieldFlags.SEARCHABLE) ?? false, "srch.settings." + AzureSearchFieldFlags.SEARCHABLE));
tr.Cells.Add(CreateTableCell(AzureSearchFieldFlags.FACETABLE, column, useDefaultValue ? defaultSearchSettings.GetFlag(AzureSearchFieldFlags.FACETABLE) : ssi?.GetFlag(AzureSearchFieldFlags.FACETABLE) ?? false, "srch.settings." + AzureSearchFieldFlags.FACETABLE));
tr.Cells.Add(CreateTableCell(AzureSearchFieldFlags.FILTERABLE, column, useDefaultValue ? defaultSearchSettings.GetFlag(AzureSearchFieldFlags.FILTERABLE) : ssi?.GetFlag(AzureSearchFieldFlags.FILTERABLE) ?? false, "srch.settings." + AzureSearchFieldFlags.FILTERABLE));
tr.Cells.Add(CreateTableCell(AzureSearchFieldFlags.SORTABLE, column, useDefaultValue ? defaultSearchSettings.GetFlag(AzureSearchFieldFlags.SORTABLE) : ssi?.GetFlag(AzureSearchFieldFlags.SORTABLE) ?? false, "srch.settings." + AzureSearchFieldFlags.SORTABLE));
}
// Add cell with 'iFieldname' value
if (DisplayIField)
{
tc = new TableCell();
CMSTextBox txt = new CMSTextBox();
txt.ID = column.ColumnName + SearchSettings.IFIELDNAME;
txt.CssClass += " form-control";
txt.MaxLength = 200;
if (ssi != null)
{
txt.Text = ssi.FieldName;
}
tc.Controls.Add(txt);
tr.Cells.Add(tc);
}
tc = new TableCell();
tr.Cells.Add(tc);
table.Rows.Add(tr);
}
}
}
protected void load_fields(object sender, EventArgs e)
{
SqlDataReader rdr;
using (SqlConnection con = new SqlConnection("Data Source=i4bbv5vnt4.database.windows.net;Initial Catalog=TeamCacAh4UPauaP;Persist Security Info=True;User ID=TeamCache;Password=Password!"))
{
con.Open();
SqlCommand cmd1 = new SqlCommand("SELECT acct_name, acct_bal, acct_type FROM Accounts", con);
rdr = cmd1.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
if (rdr["acct_type"].ToString() == "Assets" || rdr["acct_type"].ToString() == "Expenses")
{
TableRow tmp = new TableRow();
Table2.Rows.Add(tmp);
TableCell tmpN = new TableCell();
TableCell tmpB = new TableCell();
TableCell tmpBl = new TableCell();
tmpN.Text = rdr["acct_name"].ToString();
tmpB.Text = rdr["acct_bal"].ToString();
tmpBl.Text = "";
tmp.Cells.Add(tmpN);
tmp.Cells.Add(tmpB);
tmp.Cells.Add(tmpBl);
}
else if (rdr["acct_type"].ToString() == "Equity" || rdr["acct_type"].ToString() == "Liabilities" || rdr["acct_type"].ToString() == "Revenue Account")
{
TableRow tmp = new TableRow();
Table2.Rows.Add(tmp);
TableCell tmpN = new TableCell();
TableCell tmpB = new TableCell();
TableCell tmpBl = new TableCell();
tmpN.Text = rdr["acct_name"].ToString();
tmpB.Text = rdr["acct_bal"].ToString();
tmpBl.Text = "";
tmp.Cells.Add(tmpN);
tmp.Cells.Add(tmpBl);
tmp.Cells.Add(tmpB);
}
}
}
//cmd1.ExecuteNonQuery();
con.Close();
}
TableHeaderRow totalR = new TableHeaderRow();
Table2.Rows.Add(totalR);
TableHeaderCell totalC = new TableHeaderCell();
totalC.Text = "Total: ";
totalR.Cells.Add(totalC);
TableHeaderCell totalDR = new TableHeaderCell();
totalDR.Text = "$" + DRSum(sender, e);
totalR.Cells.Add(totalDR);
TableHeaderCell totalCR = new TableHeaderCell();
totalCR.Text = "$" + CRSum(sender, e);
totalR.Cells.Add(totalCR);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.officer_department) || autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
{
// ======== Process ===========
// Head Table
string[] ar = { "ชื่อกลุ่มวิชา (ภาษาไทย)", "ชื่อกลุ่มวิชา (ภาษาอังกฤษ)", "แก้ไข", "ลบ" };
tblGroup.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblGroup.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead = new TableHeaderRow();
tRowHead.TableSection = TableRowSection.TableHeader;
for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++)
{
// Create a new cell and add it to the row.
TableHeaderCell cellHead = new TableHeaderCell();
cellHead.Text = ar[cellCtr - 1];
tRowHead.Cells.Add(cellHead);
}
tblGroup.Rows.Add(tRowHead);
List <CourseGroup> courseGroup = new List <CourseGroup>();
courseGroup = new CourseGroup().getCourseGroup();
foreach (CourseGroup data in courseGroup)
{
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
TableCell cellCategoryThName = new TableCell();
cellCategoryThName.Text = data.CourseGroupThName;
tRowBody.Cells.Add(cellCategoryThName);
TableCell cellCategoryEnName = new TableCell();
cellCategoryEnName.Text = data.CourseGroupEnName;
tRowBody.Cells.Add(cellCategoryEnName);
TableCell cellEdit = new TableCell();
string urlEdit = "editGROUP.aspx?token=" + data.CourseGroupCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editModal");
hypEdit.Attributes.Add("data-toggle", "modal");
hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "Edit";
cellEdit.Controls.Add(hypEdit);
cellEdit.CssClass = "text-center";
cellEdit.Width = 50;
tRowBody.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "deleteGROUP.aspx?token=" + data.CourseGroupCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteModal");
hypDel.Attributes.Add("data-toggle", "modal");
hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "Delete";
cellDel.Controls.Add(hypDel);
cellDel.CssClass = "text-center";
cellDel.Width = 50;
tRowBody.Cells.Add(cellDel);
tblGroup.Rows.Add(tRowBody);
}
//=============================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Form.Attributes.Add("enctype", "multipart/form-data");
ObjUsuario = Utilidades.ValidarSesion(HttpContext.Current.User.Identity as FormsIdentity, this);
BoolEmpSuc = Mgr_Empresa.Get_Empresa_Sucursal(ObjUsuario);
phEmpresa.Visible = BoolEmpSuc.Item1;
phSucursal.Visible = BoolEmpSuc.Item2;
fechaInicial = Convert.ToDateTime("01/01/" + DateTime.Now.Year);
fechaFinal = Convert.ToDateTime("31/12/" + DateTime.Now.Year);
if (!IsPostBack)
{
CargarListas();
}
else
{
foreach (var ctlID in Page.Request.Form.AllKeys)
{
if (ctlID != null)
{
Control c = Page.FindControl(ctlID) as Control;
if (c is DropDownList)
{
if (c.ClientID.Contains("ddlSucursal"))
{
int nroTrabajadores = 0;
int cantGestiones = 0;
//Buscar cantidad de trabajadores para la empresa seleccionada.(Cantidad de filas)
nroTrabajadores = Mgr_Trabajador.Get_Trabajadores_ByCapacidad(Convert.ToInt32(ddlSucursal.SelectedValue), fechaInicial, fechaFinal);
//Cantidad de gestiones laborales de tipo capacitacion para el trimestre seleccionado (Cantidad de Columnas)
cantGestiones = Mgr_GestionLaboral.Get_GestionLaboralByFecha(fechaInicial, fechaFinal);
if (nroTrabajadores > 0)
{
crearTabla(nroTrabajadores, cantGestiones);
phAsistenciasLeyenda.Visible = true;
}
else
{
phAsistenciasLeyenda.Visible = false;
Table _table;
_table = new Table();
_table.ID = "tbCapacitacion";
_table.CssClass = "table";
TableHeaderRow _header_fila = new TableHeaderRow();
//Nro
TableHeaderCell _header_celda = new TableHeaderCell();
_header_celda.Text = "No Existen trabajadores asociados a ninguna gestion laboral.";
_header_celda.CssClass = "text-center";
_header_fila.Cells.Add(_header_celda);
_table.Rows.Add(_header_fila);
pnTablaCapacitacion.Controls.Add(_table);
}
}
}
}
}
}
}
private void ShowResult(StuGLSearch stuGLSearch)
{
lblTitle.Text = Page.Title;
// 當期資料
GridView gvCurrentData = new GalaxyApp().CreatGridView("gvCurrentData", "gltable ", new CglFunc().CDicTOTable(new CglData().GetCurrentDataDics(stuGLSearch)), true, true);
gvCurrentData.DataBind();
pnlCurrentData.Controls.Add(gvCurrentData);
#region Initialize
InitialArray();
#endregion Initialize
#region Setup the Css of numbers
dicNumcssclass = new Dictionary <string, string>();
foreach (var KeyPair in dicCurrentNums)
{
if (KeyPair.Value > 0)
{
dicNumcssclass.Add(KeyPair.Value.ToString(InvariantCulture), KeyPair.Key);
}
}
#endregion Setup the Css of numbers
#region dicTablePercent
if (ViewState["dicTablePercent"] == null)
{
ViewState.Add("dicTablePercent", new CglTablePercent().GetTP(stuGLSearch, StrXmlDirectory, StrFnTPxml));
//Update10(stuSearch00);
}
Dictionary <string, object> dicTablePercent = (Dictionary <string, object>)ViewState["dicTablePercent"];
#endregion
#region Data Part
#region dtTpHit
DataTable dtTpHit = new CglTablePercent().GetTablePercentHit(stuGLSearch, dicTablePercent);
dtTpHit.TableName = string.Format(InvariantCulture, "dtTpHit_{0}", stuGLSearch.InDataRowsLimit);
if (dtTpHit.Columns.Contains("TpHit02ID"))
{
dtTpHit.Columns.Remove("TpHit02ID");
}
if (dtTpHit.Columns.Contains("TpHit01ID"))
{
dtTpHit.Columns.Remove("TpHit01ID");
}
if (dtTpHit.Columns.Contains("lngTotalSN"))
{
dtTpHit.Columns.Remove("lngTotalSN");
}
if (dtTpHit.Columns.Contains("intDataRowsLimit"))
{
dtTpHit.Columns.Remove("intDataRowsLimit");
}
dtTpHit.DefaultView.Sort = "[srtCheck] DESC , [dblHitRate] ASC , [intTotal] DESC , [intHit] ASC";
#endregion dtTpHit
#region dtDHigh0125
DataTable dtDHigh0125 = new CglTablePercent().GetDHigh0125(stuGLSearch, dicTablePercent);
dtDHigh0125.TableName = string.Format(InvariantCulture, "dtDHigh0125_{0}_{1}", stuGLSearch.InDataRowsLimit, stuGLSearch.InCriticalNum);
#endregion dtDHigh0125
#region dtTpHit10
DataTable dtTpHit10 = new CglTablePercent().GetTablePercentHit10(stuGLSearch, StrXmlDirectory, strFnTPHit10xml);
dtTpHit10.TableName = string.Format(InvariantCulture, "TpHit10_{0}", stuGLSearch.InDataRowsLimit);
dtTpHit10.DefaultView.Sort = "[srtCheck] DESC ";
#endregion dtTpHit10
#region dtdicDelNum
Dictionary <string, string> dicDelNum_All = new CglTablePercent().GetTPDelNum(stuGLSearch, dtTpHit, lstDelete, lstNotDelete);
Dictionary <string, int> dicDelNum = ConvertToDicDelNum(dicDelNum_All);
dicDelNum = dicDelNum.OrderByDescending(x => x.Value).ToDictionary(x => x.Key, x => x.Value);
DataTable dtdicDelNum = new CglFunc().CDicTOTable(dicDelNum, null);
dtdicDelNum.TableName = string.Format(CultureInfo.InvariantCulture, "DelNum_{0}", stuGLSearch.InDataRowsLimit);
#endregion dtdicDelNum
#region dtdicDelNum_Hit
DicDelNum_Hit = ConvertToDicDelNum_Hit(stuGLSearch, dicDelNum_All);
DicDelNum_Hit = DicDelNum_Hit.OrderBy(x => x.Key).ToDictionary(x => x.Key, x => x.Value);
DataTable dtdicDelNum_Hit = new CglFunc().CDicTOTable(DicDelNum_Hit, null);
dtdicDelNum_Hit.TableName = string.Format(CultureInfo.InvariantCulture, "DelNum_Hit{0}", stuGLSearch.InDataRowsLimit);
#endregion dtdicDelNum_Hit
#endregion Data Part
#region Show the result
StringBuilder sbDelete = new StringBuilder();
sbDelete.AppendLine(string.Format(InvariantCulture, "DataRowsLimit : {0} ", stuGLSearch.InDataRowsLimit));
sbDelete.AppendLine(string.Format(InvariantCulture, "Delete : {0} ", string.Join(",", lstDelete.ToArray())));
sbDelete.AppendLine(string.Format(InvariantCulture, "NotDelete : {0} ", string.Join(",", lstNotDelete.ToArray())));
pnlDetail.Controls.Add(new GalaxyApp().CreatLabel("lblDelete", sbDelete.ToString(), ""));
#region dtdicDelNum
Panel pnlDelNum = new GalaxyApp().CreatPanel(string.Format(InvariantCulture, "pnl{0}", "DelNum"), "max-width");
pnlDetail.Controls.Add(pnlDelNum);
#region SetButtons
HyperLink hlDelNum = new GalaxyApp().CreatHyperLink("hlDelNum", "glbutton glbutton-lightblue ", "統計",
new Uri(string.Format(InvariantCulture, "#{0}", pnlDelNum.ID)));
pnlButtons.Controls.Add(hlDelNum);
#endregion SetButtons
#region Set table tblDelNum
Table tblDelNum = new GalaxyApp().CreatTable("gltable", dtdicDelNum.TableName);
#region Set Columns of table tblHitCount
TableHeaderRow thrHeader_DelNum = new TableHeaderRow();
TableRow trRow_DelNum = new TableRow();
foreach (DataColumn dcColumn in dtdicDelNum.Columns)
{
TableHeaderCell thcColumnFreq = new TableHeaderCell
{
Text = string.Format(InvariantCulture, "{0:00}", int.Parse(dcColumn.ColumnName, InvariantCulture))
};
if (dicNumcssclass.ContainsKey(dcColumn.ColumnName))
{
thcColumnFreq.CssClass = dicNumcssclass[dcColumn.ColumnName];
}
thrHeader_DelNum.Controls.Add(thcColumnFreq);
using TableCell tcCell = new TableCell
{
Text = string.Format(InvariantCulture, "{0}", dtdicDelNum.Rows[0][dcColumn.ColumnName].ToString())
};
trRow_DelNum.Controls.Add(tcCell);
}
tblDelNum.Controls.Add(thrHeader_DelNum);
tblDelNum.Controls.Add(trRow_DelNum);
#endregion
#endregion
pnlDelNum.Controls.Add(tblDelNum);
#endregion dtdicDelNum
#region dtdicDelNum_Hit
#region Set panel pnlDelNum_Hit
Panel pnlDelNum_Hit = new GalaxyApp().CreatPanel(string.Format(InvariantCulture, "pnl{0}", "DelNum_Hit"), "max-width");
pnlDetail.Controls.Add(pnlDelNum_Hit);
#endregion Set panel pnlHitCount
GridView gvDelNum_Hit = new GalaxyApp().CreatGridView(dtdicDelNum_Hit.TableName, "gltable ", dtdicDelNum_Hit, true, false);
gvDelNum_Hit.ShowHeaderWhenEmpty = true;
gvDelNum_Hit.AllowSorting = true;
gvDelNum_Hit.Caption = dtdicDelNum_Hit.TableName;
if (gvDelNum_Hit.Columns.Count == 0)
{
for (int i = 0; i < dtdicDelNum_Hit.Columns.Count; i++)
{
BoundField bfCell = new BoundField()
{
DataField = dtdicDelNum_Hit.Columns[i].ColumnName,
HeaderText = dtdicDelNum_Hit.Columns[i].ColumnName,
ReadOnly = true,
};
gvDelNum_Hit.Columns.Add(bfCell);
}
}
gvDelNum_Hit.DataBind();
pnlDelNum_Hit.Controls.Add(gvDelNum_Hit);
#endregion dtdicDelNum_Hit
#region dtDHigh0125
#region SetButtons
//HyperLink hlDHigh0125 = new HyperLink()
//{
// ID = "hlDelNum",
// CssClass = "glbutton glbutton-lightblue ",
// Text = "統計",
// NavigateUrl = string.Format(InvariantCulture, "#pnl{0}", "DHigh0125")
//};
pnlButtons.Controls.Add(hlDelNum);
#endregion SetButtons
#region Set panel pnlDelNum
//Panel pnlDHigh0125 = new Panel() { ID = string.Format(InvariantCulture, "pnl{0}", "DHigh0125"), CssClass = "max-width" };
pnlDetail.Controls.Add(pnlDelNum);
#endregion Set panel pnlHitCount
#region Set table tblDelNum
Table tblDHigh0125 = new GalaxyApp().CreatTable("gltable", string.Format(InvariantCulture, "{0}({1})", dtDHigh0125.TableName, dtDHigh0125.Columns.Count));
#region Set Columns of table tblHitCount
using (TableHeaderRow thrHeader_DHigh0125 = new TableHeaderRow())
{
using TableRow trRow_DHigh0125 = new TableRow();
foreach (DataColumn dcColumn in dtDHigh0125.Columns)
{
using (TableHeaderCell thcColumnFreq = new TableHeaderCell())
{
thcColumnFreq.Text = string.Format(InvariantCulture, "{0:00}", int.Parse(dcColumn.ColumnName, InvariantCulture));
thrHeader_DHigh0125.Controls.Add(thcColumnFreq);
if (dicNumcssclass.ContainsKey(int.Parse(dcColumn.ColumnName, InvariantCulture).ToString(InvariantCulture)))
{
thcColumnFreq.CssClass = dicNumcssclass[int.Parse(dcColumn.ColumnName, InvariantCulture).ToString(InvariantCulture)];
}
}
using TableCell tcCell = new TableCell
{
Text = string.Format(InvariantCulture, "{0}", dtDHigh0125.Rows[0][dcColumn.ColumnName].ToString())
};
trRow_DHigh0125.Controls.Add(tcCell);
}
#endregion
tblDHigh0125.Controls.Add(thrHeader_DHigh0125);
tblDHigh0125.Controls.Add(trRow_DHigh0125);
}
#endregion
pnlDelNum.Controls.Add(tblDHigh0125);
#endregion dtdicDelNum
#region dtTpHit
Panel pnlTpHit = new GalaxyApp().CreatPanel(string.Format(InvariantCulture, "pnl{0}", "TpHit"), "max-width");
pnlDetail.Controls.Add(pnlTpHit);
#region SetButtons
HyperLink hlTpHit = new GalaxyApp().CreatHyperLink("hlTpHit", "glbutton glbutton-lightblue ", "TpHit",
new Uri(string.Format(InvariantCulture, "#{0}", pnlTpHit.ID)));
pnlButtons.Controls.Add(hlTpHit);
#endregion SetButtons
#region gvdtTpHit
GridView gvdtTpHit = new GalaxyApp().CreatGridView(dtTpHit.TableName, "gltable ", dtTpHit, true, false);
gvdtTpHit.AllowSorting = true;
gvdtTpHit.Caption = string.Format(InvariantCulture, "{0}({1})", dtTpHit.TableName, dtTpHit.Rows.Count);
gvdtTpHit.ShowHeaderWhenEmpty = true;
if (gvdtTpHit.Columns.Count == 0)
{
for (int i = 0; i < dtTpHit.Columns.Count; i++)
{
BoundField bfCell = new BoundField()
{
DataField = dtTpHit.Columns[i].ColumnName,
HeaderText = dtTpHit.Columns[i].ColumnName,
ReadOnly = true,
};
if (i > 3)
{
bfCell.HeaderText = string.Format(InvariantCulture, "{0:00}", int.Parse(dtTpHit.Columns[i].ColumnName.Substring(4), InvariantCulture));
if (dicNumcssclass.ContainsKey(int.Parse(dtTpHit.Columns[i].ColumnName.Substring(4), InvariantCulture).ToString(InvariantCulture)))
{
bfCell.HeaderStyle.CssClass = dicNumcssclass[int.Parse(dtTpHit.Columns[i].ColumnName.Substring(4), InvariantCulture).ToString(InvariantCulture)];
bfCell.ItemStyle.CssClass = dicNumcssclass[int.Parse(dtTpHit.Columns[i].ColumnName.Substring(4), InvariantCulture).ToString(InvariantCulture)];
}
}
gvdtTpHit.Columns.Add(bfCell);
}
}
gvdtTpHit.RowDataBound += GvdtTpHit_RowDataBound;
gvdtTpHit.DataBind();
pnlTpHit.Controls.Add(gvdtTpHit);
#endregion gvdtTpHit
#endregion dtTpHit
#region dtTpHit10
Panel pnlTpHit10 = new GalaxyApp().CreatPanel(string.Format(InvariantCulture, "pnl{0}", "TpHit10"), "max-width");
pnlDetail.Controls.Add(pnlTpHit10);
#region SetButtons
HyperLink hlTpHit10 = new GalaxyApp().CreatHyperLink("hlTpHit10", "glbutton glbutton-lightblue ", "TpHit10",
new Uri(string.Format(InvariantCulture, "#{0}", pnlTpHit10.ID)));
pnlButtons.Controls.Add(hlTpHit10);
#endregion SetButtons
#region gvTpHit10
GridView gvTpHit10 = new GalaxyApp().CreatGridView(dtTpHit10.TableName, "gltable ", dtTpHit10, true, false);
gvTpHit10.AllowSorting = true;
gvTpHit10.Caption = string.Format(InvariantCulture, "{0}({1})", dtTpHit10.TableName, dtTpHit10.Rows.Count);
gvTpHit10.ShowHeaderWhenEmpty = true;
if (gvTpHit10.Columns.Count == 0)
{
for (int i = 0; i < dtTpHit10.Columns.Count; i++)
{
BoundField bfCell = new BoundField()
{
DataField = dtTpHit10.Columns[i].ColumnName,
HeaderText = dtTpHit10.Columns[i].Caption,
ReadOnly = true,
};
if (i > 0)
{
if (bfCell.HeaderText.Contains("T"))
{
bfCell.HeaderStyle.CssClass = "row_lightyellow";
bfCell.ItemStyle.CssClass = "row_lightyellow";
}
}
gvTpHit10.Columns.Add(bfCell);
}
}
gvTpHit10.RowDataBound += GvTpHit10_RowDataBound;;
gvTpHit10.DataBind();
pnlTpHit10.Controls.Add(gvTpHit10);
#endregion gvTpHit10
#endregion dtTpHit10
#endregion Show the result
}
/// <summary>
/// Generates the permission matrix for the cutrrent project.
/// </summary>
private void CreateMatrix()
{
// Get project resource info
if (resProjects == null)
{
resProjects = ResourceInfoProvider.GetResourceInfo("CMS.ProjectManagement");
}
// Get project object
if ((project == null) && (ProjectID > 0))
{
project = ProjectInfoProvider.GetProjectInfo(ProjectID);
}
if ((resProjects != null) && (project != null))
{
// Get permissions for the current project resource
DataSet permissions = PermissionNameInfoProvider.GetResourcePermissions(resProjects.ResourceId);
if (DataHelper.DataSourceIsEmpty(permissions))
{
lblInfo.Text = GetString("general.emptymatrix");
}
else
{
TableRow headerRow = new TableRow();
headerRow.CssClass = "UniGridHead";
TableCell newCell = new TableCell();
TableHeaderCell newHeaderCell = new TableHeaderCell();
newHeaderCell.Text = " ";
newHeaderCell.Attributes["style"] = "width:200px;";
headerRow.Cells.Add(newHeaderCell);
foreach (string permission in allowedPermissions)
{
DataRow[] drArray = permissions.Tables[0].DefaultView.Table.Select("PermissionName = '" + permission + "'");
if ((drArray != null) && (drArray.Length > 0))
{
DataRow dr = drArray[0];
newHeaderCell = new TableHeaderCell();
newHeaderCell.Attributes["style"] = "text-align:center;white-space:nowrap;";
newHeaderCell.Text = dr["PermissionDisplayName"].ToString();
newHeaderCell.ToolTip = dr["PermissionDescription"].ToString();
newHeaderCell.HorizontalAlign = HorizontalAlign.Center;
headerRow.Cells.Add(newHeaderCell);
}
else
{
throw new Exception("[Security matrix] Column '" + permission + "' cannot be found.");
}
}
newHeaderCell = new TableHeaderCell();
newHeaderCell.Text = " ";
headerRow.Cells.Add(newHeaderCell);
tblMatrix.Rows.Add(headerRow);
// Render project access permissions
object[,] accessNames = new object[5,2];
accessNames[0, 0] = GetString("security.nobody");
accessNames[0, 1] = SecurityAccessEnum.Nobody;
accessNames[1, 0] = GetString("security.allusers");
accessNames[1, 1] = SecurityAccessEnum.AllUsers;
accessNames[2, 0] = GetString("security.authenticated");
accessNames[2, 1] = SecurityAccessEnum.AuthenticatedUsers;
accessNames[3, 0] = GetString("security.groupmembers");
accessNames[3, 1] = SecurityAccessEnum.GroupMembers;
accessNames[4, 0] = GetString("security.authorizedroles");
accessNames[4, 1] = SecurityAccessEnum.AuthorizedRoles;
TableRow newRow = null;
int rowIndex = 0;
for (int access = 0; access <= accessNames.GetUpperBound(0); access++)
{
SecurityAccessEnum currentAccess = ((SecurityAccessEnum)accessNames[access, 1]);
// If the security isn't displayed as part of group section
if ((currentAccess == SecurityAccessEnum.GroupMembers) && (project.ProjectGroupID == 0))
{
// Do not render this access item
}
else
{
// Generate cell holding access item name
newRow = new TableRow();
newRow.CssClass = ((rowIndex % 2 == 0) ? "EvenRow" : "OddRow");
newCell = new TableCell();
newCell.Text = accessNames[access, 0].ToString();
newCell.Wrap = false;
newCell.CssClass = "MatrixHeader";
newCell.Width = new Unit(28, UnitType.Percentage);
newRow.Cells.Add(newCell);
rowIndex++;
// Render the permissions access items
bool isAllowed = false;
bool isDisabled = (!Enable);
int permissionIndex = 0;
for (int permission = 0; permission < (tblMatrix.Rows[0].Cells.Count - 2); permission++)
{
newCell = new TableCell();
// Check if the currently processed access is applied for permission
isAllowed = CheckPermissionAccess(currentAccess, permission, tblMatrix.Rows[0].Cells[permission + 1].Text);
// Disable column in roles grid if needed
if ((currentAccess == SecurityAccessEnum.AuthorizedRoles) && !isAllowed)
{
gridMatrix.DisableColumn(permissionIndex);
}
// Insert the radio button for the current permission
string permissionText = tblMatrix.Rows[0].Cells[permission + 1].Text;
string elemId = ClientID + "_" + permission + "_" + access;
newCell.Text = "<label style=\"display:none;\" for=\"" + elemId + "\">" + permissionText + "</label><input type=\"radio\" id=\"" + elemId + "\" name=\"" + permissionText + "\" onclick=\"" +
ControlsHelper.GetPostBackEventReference(this, permission.ToString() + ";" + Convert.ToInt32(currentAccess).ToString()) + "\" " +
((isAllowed) ? "checked = \"checked\"" : "") + ((isDisabled) ? " disabled=\"disabled\"" : "") + "/>";
newCell.Wrap = false;
newCell.Width = new Unit(12, UnitType.Percentage);
newCell.HorizontalAlign = HorizontalAlign.Center;
newRow.Cells.Add(newCell);
permissionIndex++;
}
newCell = new TableCell();
newCell.Text = " ";
newRow.Cells.Add(newCell);
// Add the access row to the table
tblMatrix.Rows.Add(newRow);
}
}
// Check if project has some roles assigned
mNoRolesAvailable = !gridMatrix.HasData;
// Get permission matrix for current project resource
if (!mNoRolesAvailable)
{
// Security - Role separator
newRow = new TableRow();
newCell = new TableCell();
newCell.Text = " ";
newCell.Attributes.Add("colspan", Convert.ToString(tblMatrix.Rows[0].Cells.Count));
newRow.Controls.Add(newCell);
tblMatrix.Rows.Add(newRow);
// Security - Role separator text
newRow = new TableRow();
newCell = new TableCell();
newCell.CssClass = "MatrixLabel";
newCell.Text = GetString("SecurityMatrix.RolesAvailability");
newCell.Attributes.Add("colspan", Convert.ToString(tblMatrix.Rows[0].Cells.Count));
newRow.Controls.Add(newCell);
tblMatrix.Rows.Add(newRow);
}
}
}
}
private void buildAssignTable()
{
List <TblGroups> groups = ServerModel.DB.Query <TblGroups>(null);
IList <TblCurriculums> curriculums = TeacherHelper.CurrentUserCurriculums(FxCurriculumOperations.Use);
Table_Assignments.Rows.Clear();
//create header row
TableRow headerRow = new TableRow();
TableHeaderCell emptyHeaderCell = new TableHeaderCell();
emptyHeaderCell.Text = "";
headerRow.Cells.Add(emptyHeaderCell);
foreach (TblGroups group in groups)
{
TableHeaderCell headerCell = new TableHeaderCell();
headerCell.Text = group.Name;
headerRow.Cells.Add(headerCell);
}
Table_Assignments.Rows.Add(headerRow);
//create row for each curriculum
foreach (TblCurriculums curriculum in curriculums)
{
TableRow curriculumRow = new TableRow();
TableHeaderCell curriculumHeaderCell = new TableHeaderCell();
curriculumHeaderCell.Text = curriculum.Name;
curriculumRow.Cells.Add(curriculumHeaderCell);
IList <TblGroups> assignedGroups = TeacherHelper.GetGroupsForCurriculum(curriculum);
foreach (TblGroups group in groups)
{
bool isAssigned = false;
foreach (TblGroups assignedGroup in assignedGroups)
{
if (assignedGroup.ID == group.ID)
{
isAssigned = true;
break;
}
}
TableCell curriculumCell = new TableCell();
if (isAssigned)
{
Button modifyButton = new Button();
modifyButton.ID = group.ID.ToString() + modifyChar + curriculum.ID;
modifyButton.Text = modify;
modifyButton.PostBackUrl = ServerModel.Forms.BuildRedirectUrl <CurriculumTimelineController>(
new CurriculumTimelineController()
{
BackUrl = Request.RawUrl,
GroupID = group.ID,
CurriculumID = curriculum.ID
});
Button unsignButton = new Button();
unsignButton.ID = group.ID.ToString() + unsignChar + curriculum.ID;
unsignButton.Click += new EventHandler(unsignButton_Click);
unsignButton.Text = unsign;
curriculumCell.Controls.Add(modifyButton);
curriculumCell.Controls.Add(unsignButton);
}
else
{
Button assignButton = new Button();
assignButton.ID = group.ID.ToString() + assignChar + curriculum.ID;
assignButton.Click += new EventHandler(assignButton_Click);
assignButton.Text = assign;
curriculumCell.Controls.Add(assignButton);
}
curriculumRow.Cells.Add(curriculumCell);
}
Table_Assignments.Rows.Add(curriculumRow);
}
}
/// <summary>
/// Generate header of the matrix.
/// </summary>
/// <param name="matrixData">Data of the matrix to be generated</param>
private void GenerateMatrixHeader(List<DataRow> matrixData)
{
// Prepare matrix header
foreach (int index in ColumnOrderIndex)
{
DataRow dr = matrixData[index];
if (ShowHeaderRow)
{
// Create header cell
var thc = new TableHeaderCell
{
Scope = TableHeaderScope.Column,
Text = HTMLHelper.HTMLEncode(MacroResolver.Resolve(Convert.ToString(dr[ColumnItemDisplayNameColumn]))),
ToolTip = (ColumnItemTooltipColumn != null) ? GetTooltip(dr, ItemTooltipColumn) : null,
EnableViewState = false
};
thrFirstRow.Cells.Add(thc);
// Add disabled mark if needed
if (!IsColumnEditable(dr[ColumnItemIDColumn]))
{
thc.Text += DisabledColumnMark;
}
}
else
{
// Create header cell
var thc = new TableHeaderCell
{
Scope = TableHeaderScope.Column,
Text = " ",
EnableViewState = false
};
thrFirstRow.Cells.Add(thc);
}
}
}
/// <summary>Performs the data binding.</summary>
/// <param name="retrievedData">The retrieved data.</param>
protected override void PerformDataBinding(System.Collections.IEnumerable retrievedData)
{
table.Rows.Clear();
base.PerformDataBinding(retrievedData);
if (this.Columns.Count == 0)
{
throw new Exception("List of columns is null or empty.");
}
if (retrievedData == null)
{
return;
}
this.SetPaginator(ref retrievedData);
TableRow row;
var rowHeader = new TableRow();
rowHeader.TableSection = TableRowSection.TableHeader;
foreach (var boundColumn in this.Columns)
{
if (!DesignMode && TypeDescriptor.GetProperties(retrievedData.Cast <object>().First()).Find(boundColumn.FieldName, false) == null)
{
throw new NullReferenceException(String.Format("Column with name '{0}' not founded in datasource.", boundColumn.FieldName));
}
var cellHeader = new TableHeaderCell()
{
Text = boundColumn.Header
};
rowHeader.Cells.Add(cellHeader);
}
table.Rows.Add(rowHeader);
foreach (object dataItem in retrievedData)
{
row = new TableRow();
row.TableSection = TableRowSection.TableBody;
foreach (BoundColumn boundColumn in this.Columns)
{
var prop = TypeDescriptor.GetProperties(dataItem).Find(boundColumn.FieldName, false);
if (prop == null)
{
continue;
}
if (prop.GetValue(dataItem) == null)
{
row.Cells.Add(new TableCell());
continue;
}
switch (boundColumn.GetType().FullName)
{
case "Luzes.Core.UI.Web.Controls.Bootstrap.HyperlinkColumn":
row.Cells.Add(CreateHyperlinkColumn(prop, dataItem, (HyperlinkColumn)boundColumn));
break;
case "Luzes.Core.UI.Web.Controls.Bootstrap.DateColumn":
row.Cells.Add(CreateDateColumn(prop, dataItem, (DateColumn)boundColumn));
break;
case "Luzes.Core.UI.Web.Controls.Bootstrap.CheckBoxColumn":
row.Cells.Add(CreateCheckBoxColumn(prop, dataItem, (CheckBoxColumn)boundColumn));
break;
default:
row.Cells.Add(CreateColumn(prop, dataItem, boundColumn));
break;
}
}
table.Rows.Add(row);
}
}
/// <summary>
/// Display DataSet content.
/// </summary>
/// <param name="ds">DataSet to display</param>
private void DisplayDataSet(DataSet ds)
{
if (!DataHelper.DataSourceIsEmpty(ds))
{
// Prepare list of tables
string excludedTableNames = (ExcludedTableNames != null) ? ";" + ExcludedTableNames.Trim(';').ToLowerCSafe() + ";" : "";
List <string> tables = new List <string>();
foreach (DataTable dt in ds.Tables)
{
if (!DataHelper.DataSourceIsEmpty(dt))
{
string tableName = dt.TableName;
if (!excludedTableNames.Contains(";" + tableName.ToLowerCSafe() + ";"))
{
tables.Add(tableName);
}
}
}
// Generate the tables ordered by object type display name
foreach (string tableName in tables.OrderBy(x => GetString("ObjectType." + x)))
{
DataTable dt = ds.Tables[tableName];
if (!DataHelper.DataSourceIsEmpty(dt))
{
if (ds.Tables.Count > 1)
{
plcContent.Controls.Add(new LiteralControl(GetTableHeaderText(dt)));
}
Table contentTable;
if (!ForceRowDisplayFormat && (dt.Columns.Count >= 6) && !dt.TableName.EqualsCSafe(TranslationHelper.TRANSLATION_TABLE, true))
{
// Write all rows
foreach (DataRow dr in dt.Rows)
{
contentTable = new Table();
SetTable(contentTable);
// Set first table as table property
if (Table == null)
{
Table = contentTable;
}
// Create table header
TableCell labelCell = new TableHeaderCell();
labelCell.Text = GetString("General.FieldName");
TableCell valueCell = new TableHeaderCell();
valueCell.Text = GetString("General.Value");
AddRow(contentTable, labelCell, valueCell, null, "unigrid-head", true);
// Add values
foreach (DataColumn dc in dt.Columns)
{
string content = GetRowColumnContent(dr, dc, false);
if (ShowAllFields || !String.IsNullOrEmpty(content))
{
labelCell = new TableCell();
labelCell.Text = "<strong>" + dc.ColumnName + "</strong>";
valueCell = new TableCell();
valueCell.Text = content;
AddRow(contentTable, labelCell, valueCell, null);
}
}
plcContent.Controls.Add(contentTable);
plcContent.Controls.Add(new LiteralControl("<br />"));
}
}
else
{
contentTable = new Table();
SetTable(contentTable);
// Add header
TableRow tr = new TableHeaderRow {
TableSection = TableRowSection.TableHeader
};
tr.CssClass = "unigrid-head";
int h = 1;
foreach (DataColumn column in dt.Columns)
{
TableHeaderCell th = new TableHeaderCell();
th.Text = ValidationHelper.GetString(column.Caption, column.ColumnName);
if (!ForceRowDisplayFormat && (h == dt.Columns.Count))
{
th.CssClass = "main-column-100";
}
tr.Cells.Add(th);
h++;
}
contentTable.Rows.Add(tr);
// Write all rows
foreach (DataRow dr in dt.Rows)
{
tr = new TableRow();
// Add values
foreach (DataColumn dc in dt.Columns)
{
TableCell tc = new TableCell();
object value = dr[dc.ColumnName];
// Possible DataTime columns
if ((dc.DataType == typeof(DateTime)) && (value != DBNull.Value))
{
DateTime dateTime = Convert.ToDateTime(value);
CultureInfo cultureInfo = CultureHelper.GetCultureInfo(MembershipContext.AuthenticatedUser.PreferredUICultureCode);
value = dateTime.ToString(cultureInfo);
}
string content = ValidationHelper.GetString(value, String.Empty);
tc.Text = EncodeDisplayedData ? HTMLHelper.HTMLEncode(content) : content;
if (!ForceRowDisplayFormat)
{
tc.Style.Add(HtmlTextWriterStyle.WhiteSpace, "nowrap");
}
tr.Cells.Add(tc);
}
contentTable.Rows.Add(tr);
}
plcContent.Controls.Add(contentTable);
plcContent.Controls.Add(new LiteralControl("<br />"));
}
}
}
}
else
{
Label lblError = new Label();
lblError.CssClass = "InfoLabel";
lblError.Text = GetString("general.nodatafound");
plcContent.Controls.Add(lblError);
}
}
/// <summary>
/// Generates the permission matrix for the cutrrent project.
/// </summary>
private void CreateMatrix()
{
// Get project resource info
if (mResProjects == null)
{
mResProjects = ResourceInfoProvider.GetResourceInfo("CMS.ProjectManagement");
}
// Get project object
if ((mProject == null) && (ProjectID > 0))
{
mProject = ProjectInfoProvider.GetProjectInfo(ProjectID);
}
if ((mResProjects != null) && (mProject != null))
{
// Get permissions for the current project resource
DataSet permissions = PermissionNameInfoProvider.GetResourcePermissions(mResProjects.ResourceId);
if (DataHelper.DataSourceIsEmpty(permissions))
{
lblInfo.Text = GetString("general.emptymatrix");
lblInfo.Visible = true;
}
else
{
TableRow headerRow = new TableRow();
headerRow.TableSection = TableRowSection.TableHeader;
headerRow.CssClass = "unigrid-head";
TableHeaderCell newHeaderCell = new TableHeaderCell();
newHeaderCell.CssClass = "first-column";
headerRow.Cells.Add(newHeaderCell);
foreach (string permission in mAllowedPermissions)
{
DataRow[] drArray = permissions.Tables[0].DefaultView.Table.Select("PermissionName = '" + permission + "'");
if (drArray.Length > 0)
{
DataRow dr = drArray[0];
newHeaderCell = new TableHeaderCell();
newHeaderCell.Text = dr["PermissionDisplayName"].ToString();
newHeaderCell.ToolTip = dr["PermissionDescription"].ToString();
headerRow.Cells.Add(newHeaderCell);
}
else
{
throw new Exception("[Security matrix] Column '" + permission + "' cannot be found.");
}
}
tblMatrix.Rows.Add(headerRow);
// Render project access permissions
object[,] accessNames = new object[5, 2];
accessNames[0, 0] = GetString("security.nobody");
accessNames[0, 1] = SecurityAccessEnum.Nobody;
accessNames[1, 0] = GetString("security.allusers");
accessNames[1, 1] = SecurityAccessEnum.AllUsers;
accessNames[2, 0] = GetString("security.authenticated");
accessNames[2, 1] = SecurityAccessEnum.AuthenticatedUsers;
accessNames[3, 0] = GetString("security.groupmembers");
accessNames[3, 1] = SecurityAccessEnum.GroupMembers;
accessNames[4, 0] = GetString("security.authorizedroles");
accessNames[4, 1] = SecurityAccessEnum.AuthorizedRoles;
TableRow newRow;
int rowIndex = 0;
for (int access = 0; access <= accessNames.GetUpperBound(0); access++)
{
SecurityAccessEnum currentAccess = ((SecurityAccessEnum)accessNames[access, 1]);
// If the security isn't displayed as part of group section
if ((currentAccess == SecurityAccessEnum.GroupMembers) && (mProject.ProjectGroupID == 0))
{
// Do not render this access item
}
else
{
// Generate cell holding access item name
newRow = new TableRow();
TableCell newCell = new TableCell();
newCell.Text = accessNames[access, 0].ToString();
newCell.CssClass = "matrix-header";
newRow.Cells.Add(newCell);
rowIndex++;
// Render the permissions access items
int permissionIndex = 0;
for (int permission = 0; permission < (tblMatrix.Rows[0].Cells.Count - 1); permission++)
{
newCell = new TableCell();
// Check if the currently processed access is applied for permission
bool isAllowed = CheckPermissionAccess(currentAccess, permission, tblMatrix.Rows[0].Cells[permission + 1].Text);
// Disable column in roles grid if needed
if ((currentAccess == SecurityAccessEnum.AuthorizedRoles) && !isAllowed)
{
gridMatrix.DisableColumn(permissionIndex);
}
// Insert the radio button for the current permission
var radio = new CMSRadioButton
{
Checked = isAllowed,
Enabled = Enable,
};
radio.Attributes.Add("onclick", ControlsHelper.GetPostBackEventReference(this, permission + ";" + Convert.ToInt32(currentAccess)));
newCell.Controls.Add(radio);
newRow.Cells.Add(newCell);
permissionIndex++;
}
// Add the access row to the table
tblMatrix.Rows.Add(newRow);
}
}
// Check if project has some roles assigned
headTitle.Visible = gridMatrix.HasData;
}
}
}
private TableHeaderCell NewCellHeader()
{
TableHeaderCell cell = new TableHeaderCell();
return(cell);
}
/// <summary>
/// Gets new table header cell which contains label and rollback image.
/// </summary>
/// <param name="suffixID">ID suffix</param>
/// <param name="objectVersion">VersionHistoryInfo object</param>
private TableHeaderCell GetRollbackTableHeaderCell(string suffixID, ObjectVersionHistoryInfo objectVersion)
{
TableHeaderCell tblHeaderCell = new TableHeaderCell();
// Label
Label lblValue = new Label();
lblValue.ID = "lbl" + suffixID;
lblValue.Text = HTMLHelper.HTMLEncode(GetVersionNumber(objectVersion.VersionNumber, objectVersion.VersionModifiedWhen)) + " ";
tblHeaderCell.Controls.Add(lblValue);
// Add rollback controls if user authorized to modify selected object
if (objectVersion.CheckPermissions(PermissionsEnum.Modify, SiteContext.CurrentSiteName, MembershipContext.AuthenticatedUser))
{
// Rollback image
var imgRollback = new HyperLink();
imgRollback.ID = "imgRollback" + suffixID;
imgRollback.CssClass = "table-header-action";
imgRollback.NavigateUrl = "#";
string tooltip = null;
string confirmText = null;
var info = BaseAbstractInfoProvider.GetInfoById(Version.VersionObjectType, Version.VersionObjectID);
var rollbackEnabled = !SynchronizationHelper.IsCheckedOutByOtherUser(info);
// Set image action and description according to roll back type
if (chkDisplayAllData.Checked)
{
tooltip = GetString("objectversioning.versionlist.versionfullrollbacktooltip");
confirmText = GetString("objectversioning.versionlist.confirmfullrollback");
}
else
{
tooltip = GetString("history.versionrollbacktooltip");
confirmText = GetString("Unigrid.ObjectVersionHistory.Actions.Rollback.Confirmation");
}
imgRollback.Text = tooltip;
imgRollback.Enabled = rollbackEnabled;
// Prepare onclick script
if (rollbackEnabled)
{
var confirmScript = "if (confirm(\"" + confirmText + "\")) { ";
confirmScript += ControlsHelper.GetPostBackEventReference(this, objectVersion.VersionID + "|" + chkDisplayAllData.Checked) + "; return false; }";
imgRollback.Attributes.Add("onclick", confirmScript);
}
tblHeaderCell.Controls.Add(imgRollback);
}
return tblHeaderCell;
}
/// <summary>
/// Generates the permission matrix for the current forum.
/// </summary>
private void CreateMatrix()
{
// Get forum resource info
if (resForums == null)
{
resForums = ResourceInfoProvider.GetResourceInfo("CMS.Forums");
}
// Get forum object
if ((forum == null) && (ForumID > 0))
{
forum = ForumInfoProvider.GetForumInfo(ForumID);
}
if ((resForums != null) && (forum != null))
{
// Get permissions for the current forum resource
DataSet permissions = PermissionNameInfoProvider.GetResourcePermissions(resForums.ResourceID);
if (DataHelper.DataSourceIsEmpty(permissions))
{
ShowInformation(GetString("general.emptymatrix"));
}
else
{
TableHeaderRow headerRow = new TableHeaderRow();
headerRow.CssClass = "unigrid-head";
headerRow.TableSection = TableRowSection.TableHeader;
TableCell newCell = new TableCell();
TableHeaderCell newHeaderCell = new TableHeaderCell();
newHeaderCell.CssClass = "first-column";
headerRow.Cells.Add(newHeaderCell);
foreach (string permission in allowedPermissions)
{
DataRow[] drArray = permissions.Tables[0].DefaultView.Table.Select("PermissionName = '" + permission + "'");
if (drArray.Length > 0)
{
DataRow dr = drArray[0];
newHeaderCell = new TableHeaderCell();
newHeaderCell.Text = dr["PermissionDisplayName"].ToString();
newHeaderCell.ToolTip = dr["PermissionDescription"].ToString();
headerRow.Cells.Add(newHeaderCell);
}
else
{
throw new Exception("[Security matrix] Column '" + permission + "' cannot be found.");
}
}
tblMatrix.Rows.Add(headerRow);
// Render forum access permissions
object[,] accessNames = new object[5, 2];
accessNames[0, 0] = GetString("security.nobody");
accessNames[0, 1] = SecurityAccessEnum.Nobody;
accessNames[1, 0] = GetString("security.allusers");
accessNames[1, 1] = SecurityAccessEnum.AllUsers;
accessNames[2, 0] = GetString("security.authenticated");
accessNames[2, 1] = SecurityAccessEnum.AuthenticatedUsers;
accessNames[3, 0] = GetString("security.groupmembers");
accessNames[3, 1] = SecurityAccessEnum.GroupMembers;
accessNames[4, 0] = GetString("security.authorizedroles");
accessNames[4, 1] = SecurityAccessEnum.AuthorizedRoles;
TableRow newRow = null;
for (int access = 0; access <= accessNames.GetUpperBound(0); access++)
{
SecurityAccessEnum currentAccess = ((SecurityAccessEnum)accessNames[access, 1]);
// If the security isn't displayed as part of group section
if ((currentAccess == SecurityAccessEnum.GroupMembers) && (!IsGroupForum))
{
// Do not render this access item
}
else
{
// Generate cell holding access item name
newRow = new TableRow();
newCell = new TableCell();
newCell.Text = accessNames[access, 0].ToString();
newCell.CssClass = "matrix-header";
newRow.Cells.Add(newCell);
// Render the permissions access items
bool isAllowed = false;
bool isEnabled = true;
int permissionIndex = 0;
for (int permission = 0; permission < (tblMatrix.Rows[0].Cells.Count - 1); permission++)
{
newCell = new TableCell();
// Check if the currently processed access is applied for permission
isAllowed = CheckPermissionAccess(currentAccess, permission, tblMatrix.Rows[0].Cells[permission + 1].Text);
isEnabled = ((currentAccess != SecurityAccessEnum.AllUsers) || (permission != 1)) && Enable;
// Disable column in roles grid if needed
if ((currentAccess == SecurityAccessEnum.AuthorizedRoles) && !isAllowed)
{
gridMatrix.DisableColumn(permissionIndex);
}
// Insert the radio button for the current permission
var radio = new CMSRadioButton
{
Checked = isAllowed,
Enabled = isEnabled,
};
radio.Attributes.Add("onclick", ControlsHelper.GetPostBackEventReference(this, permission + ";" + Convert.ToInt32(currentAccess)));
newCell.Controls.Add(radio);
newRow.Cells.Add(newCell);
permissionIndex++;
}
// Add the access row to the table
tblMatrix.Rows.Add(newRow);
}
}
// Check if forum has some roles assigned
headTitle.Visible = gridMatrix.HasData;
}
}
}
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
GridView gv = sender as GridView;
GridViewRow row = new GridViewRow(0, -1, DataControlRowType.Header, DataControlRowState.Normal);
Table t = (Table)gv.Controls[0];
// Adding Cells
TableCell FileDate = new TableHeaderCell();
FileDate.Text = "Date";
row.Cells.Add(FileDate);
TableCell cell = new TableHeaderCell();
cell.Text = "Rosin B grade";
row.Cells.Add(cell);
t.Rows.AddAt(0, row);
TableCell cell1 = new TableHeaderCell();
cell1.Text = "T. Oil";
row.Cells.Add(cell1);
t.Rows.AddAt(0, row);
TableCell cell2 = new TableHeaderCell();
cell2.Text = "Bitumen";
row.Cells.Add(cell2);
t.Rows.AddAt(0, row);
TableCell cell3 = new TableHeaderCell();
cell3.Text = "Lime";
row.Cells.Add(cell3);
t.Rows.AddAt(0, row);
TableCell cell4 = new TableHeaderCell();
cell4.Text = "Black Lamp";
row.Cells.Add(cell4);
t.Rows.AddAt(0, row);
TableCell cell6 = new TableHeaderCell();
cell6.Text = "Steam Coal/Fuel Wood";
row.Cells.Add(cell6);
t.Rows.AddAt(0, row);
TableCell cell7 = new TableHeaderCell();
cell7.Text = "Daily Production";
row.Cells.Add(cell7);
t.Rows.AddAt(0, row);
TableCell cell8 = new TableHeaderCell();
cell8.Text = "Progressive Total";
row.Cells.Add(cell8);
t.Rows.AddAt(0, row);
TableCell cell9 = new TableHeaderCell();
cell9.Text = "Lot No.";
row.Cells.Add(cell9);
t.Rows.AddAt(0, row);
TableCell cell10 = new TableHeaderCell();
cell10.Text = "Batch No.";
row.Cells.Add(cell10);
t.Rows.AddAt(0, row);
TableCell cell11 = new TableHeaderCell();
cell11.Text = "Sign of Subsidiary Section Incharge";
row.Cells.Add(cell11);
t.Rows.AddAt(0, row);
TableCell cell12 = new TableHeaderCell();
cell12.Text = "Sign of FM/GM";
row.Cells.Add(cell12);
t.Rows.AddAt(0, row);
t.Rows.AddAt(0, row);
TableCell cell13 = new TableHeaderCell();
TableCell cell14 = new TableHeaderCell();
cell14.Text = "Remarks";
row.Cells.Add(cell14);
t.Rows.AddAt(0, row);
}
}
//Ger information om aktuell data i databas:
public void button_info(HtmlGenericControl display, HtmlGenericControl display2,
Chart ch3DPie, Label lbl3DPie, Page sida)
{
OrderedDictionary dictRec = new OrderedDictionary();
int rowcount = 0;
try
{
dictRec = db.GetInfo();
rowcount = dictRec.Count;
}
finally
{ }
//Value- och key-kollektioner initieras mha Interface:
ICollection keyKollektion = dictRec.Keys;
ICollection valueKollektion = dictRec.Values;
//Skapar arrays och kopierar kollektionerna till desamma:
String[] keys = new String[rowcount];
int[] values = new int[rowcount];
keyKollektion.CopyTo(keys, 0);
valueKollektion.CopyTo(values, 0);
if (rowcount > 0)
{
//Rensar display från text och gridviews
clr.Clean_surfaces(sida);
DateTime Now = DateTime.Now;
//Skapar de olika tabellerna:
Table tblCDDVD = new Table();
Table tblVinyl = new Table();
Table tblDataMeida = new Table();
Table tblKluster = new Table();
int sum_cddvd = 0;
int sum_vinyl = 0;
int sum_datamedia = 0;
//Rubrik för infosidan:
string add = "<h1>Följande info för tabeller finns: </h1>";
display.InnerHtml = add;
//Skriver ut CD/DVD-info om skivtabell:
//Rubrikrad:
TableRow rubrikrad_cddvd = new TableRow();
tblCDDVD.Controls.Add(rubrikrad_cddvd);
TableHeaderCell hcell_cddvd = new TableHeaderCell();
//hcell_cddvd.BorderWidth = 1;
hcell_cddvd.HorizontalAlign = HorizontalAlign.Left;
hcell_cddvd.Text = "CD/DVD:";
rubrikrad_cddvd.Controls.Add(hcell_cddvd);
//Tabellinnehåll:
for (int i = 0; i < 11; i++)
{
TableRow rad = new TableRow();
tblCDDVD.Controls.Add(rad);
TableCell cell = new TableCell();
//cell.BorderWidth = 1;
cell.Text = "Antal " + keys[i] + ": " + "<b>" + values[i] + "</b>";
rad.Controls.Add(cell);
sum_cddvd += values[i];
}
//Summeringsrad:
TableRow sumrad_cddvd = new TableRow();
TableHeaderCell hsumma_cddvd = new TableHeaderCell();
hsumma_cddvd.HorizontalAlign = HorizontalAlign.Left;
hsumma_cddvd.Text = "Summa: " + sum_cddvd.ToString() + " cd/dvd(s)";
sumrad_cddvd.Controls.Add(hsumma_cddvd);
tblCDDVD.Controls.Add(sumrad_cddvd);
//Skriver ut vinyl-info om skivtabell:
//Rubrikrad:
TableRow rubrikrad_vinyl = new TableRow();
tblVinyl.Controls.Add(rubrikrad_vinyl);
TableHeaderCell hcell_vinyl = new TableHeaderCell();
//hcell_vinyl.BorderWidth = 1;
hcell_vinyl.HorizontalAlign = HorizontalAlign.Left;
hcell_vinyl.Text = "Vinyl:";
rubrikrad_vinyl.Controls.Add(hcell_vinyl);
//Tabellinnehåll:
for (int i = 11; i < 23; i++)
{
TableRow rad = new TableRow();
tblVinyl.Controls.Add(rad);
TableCell cell = new TableCell();
//cell.BorderWidth = 1;
cell.Text = "Antal " + keys[i] + ": " + "<b>" + values[i] + "</b>";
rad.Controls.Add(cell);
sum_vinyl += values[i];
}
//Summeringsrad:
TableRow sumrad_vinyl = new TableRow();
TableHeaderCell hsumma_vinyl = new TableHeaderCell();
hsumma_vinyl.HorizontalAlign = HorizontalAlign.Left;
hsumma_vinyl.Text = "Summa: " + sum_vinyl.ToString() + " vinyl(er)";
sumrad_vinyl.Controls.Add(hsumma_vinyl);
tblVinyl.Controls.Add(sumrad_vinyl);
//Skriver ut datamedia-info om skivtabell:
//Rubrikrad:
TableRow rubrikrad_datam = new TableRow();
tblDataMeida.Controls.Add(rubrikrad_datam);
TableHeaderCell hcell_datam = new TableHeaderCell();
//hcell_datam.BorderWidth = 1;
hcell_datam.HorizontalAlign = HorizontalAlign.Left;
hcell_datam.Text = "Datamedia:";
rubrikrad_datam.Controls.Add(hcell_datam);
//Tabellinnehåll:
//for (int i = 11; i < 23; i++)
//{
TableRow rad_datam = new TableRow();
tblDataMeida.Controls.Add(rad_datam);
TableCell cell_datam = new TableCell();
//cell_datam.BorderWidth = 1;
cell_datam.Text = "Antal " + keys[23] + ": " + "<b>" + values[23] + "</b>";
rad_datam.Controls.Add(cell_datam);
sum_datamedia += values[23];
//}
//Summeringsrad:
TableRow sumrad_datamedia = new TableRow();
TableHeaderCell hsumma_datamedia = new TableHeaderCell();
hsumma_datamedia.HorizontalAlign = HorizontalAlign.Left;
hsumma_datamedia.Text = "Summa: " + sum_datamedia.ToString() + " mp3(s)";
sumrad_datamedia.Controls.Add(hsumma_datamedia);
tblDataMeida.Controls.Add(sumrad_datamedia);
//Sätter upp layouten för ovanstående tabeller:
TableRow rad_Kluster = new TableRow();
TableCell cell1_Kluster = new TableCell();
TableCell cell2_Kluster = new TableCell();
TableCell cell3_Kluster = new TableCell();
cell1_Kluster.Controls.Add(tblCDDVD);
cell2_Kluster.Controls.Add(tblVinyl);
cell3_Kluster.Controls.Add(tblDataMeida);
cell1_Kluster.VerticalAlign = VerticalAlign.Top;
cell2_Kluster.VerticalAlign = VerticalAlign.Top;
cell3_Kluster.VerticalAlign = VerticalAlign.Top;
rad_Kluster.Controls.Add(cell1_Kluster);
rad_Kluster.Controls.Add(cell2_Kluster);
rad_Kluster.Controls.Add(cell3_Kluster);
tblKluster.Controls.Add(rad_Kluster);
//Visar alla tabeller inkl. layout på displayen:
display.Controls.Add(tblKluster);
//Totalsumma för antal skivor i skivtabell:
int totalsumma = sum_cddvd + sum_vinyl + sum_datamedia;
//Visar tid när sidan skapades och totalsumma för skivdatabas:
string add2 = "<h3 id=nogreen> Totalsumma för skivdatabas: " + totalsumma + " enheter </h3>";
add2 += "<h3>" + "Sidan skapades: " + Now + "</h3>";
display2.InnerHtml = add2;
//Visar 3D-piechart + dess label:
ch3DPie.Visible = true;
lbl3DPie.Visible = true;
}
else
{
//Rensar display från text och gridviews
clr.Clean_surfaces(sida);
display.InnerHtml = "<h2>Inga erhållna värden från databas.</h2>";
}
}
protected void GridView2_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
GridView gv3 = sender as GridView;
GridViewRow row3 = new GridViewRow(0, -1, DataControlRowType.Header, DataControlRowState.Normal);
Table t3 = (Table)gv3.Controls[0];
// Adding Cells
TableCell FileDateb2 = new TableHeaderCell();
FileDateb2.Text = "";
row3.Cells.Add(FileDateb2);
TableCell FileDateb3 = new TableHeaderCell();
FileDateb3.Text = "Per Piece";
row3.Cells.Add(FileDateb3);
TableCell FileDateb4 = new TableHeaderCell();
FileDateb4.Text = "Per M3";
row3.Cells.Add(FileDateb4);
TableCell FileDateb5 = new TableHeaderCell();
FileDateb5.Text = "";
row3.Cells.Add(FileDateb5);
TableCell FileDateb6 = new TableHeaderCell();
FileDateb6.Text = "Per Piece";
row3.Cells.Add(FileDateb6);
TableCell FileDateb7 = new TableHeaderCell();
FileDateb7.Text = "Per M3";
row3.Cells.Add(FileDateb7);
TableCell FileDateb8 = new TableHeaderCell();
FileDateb8.Text = "";
row3.Cells.Add(FileDateb8);
TableCell FileDateb9 = new TableHeaderCell();
FileDateb9.Text = "Amt.";
row3.Cells.Add(FileDateb9);
TableCell FileDateb11 = new TableHeaderCell();
FileDateb11.Text = "%";
row3.Cells.Add(FileDateb11);
t3.Rows.AddAt(0, row3);
GridView gv = sender as GridView;
GridViewRow row = new GridViewRow(0, -1, DataControlRowType.Header, DataControlRowState.Normal);
Table t = (Table)gv.Controls[0];
TableCell cell1 = new TableHeaderCell();
cell1.Text = "Vol. M3";
row.Cells.Add(cell1);
TableCell cell2 = new TableHeaderCell();
cell2.Text = "Rate Obtained Per Piece/Per M3";
cell2.ColumnSpan = 2;
row.Cells.Add(cell2);
TableCell cell3 = new TableHeaderCell();
cell3.Text = "Sale/Bid Ammount";
row.Cells.Add(cell3);
TableCell cell4 = new TableHeaderCell();
cell4.ColumnSpan = 2;
cell4.Text = "Floor Rate Per M3";
row.Cells.Add(cell4);
TableCell cell5 = new TableHeaderCell();
cell5.Text = "Ammount";
row.Cells.Add(cell5);
TableCell cell6 = new TableHeaderCell();
cell6.Text = "Variations (+/-)%";
cell6.ColumnSpan = 2;
row.Cells.Add(cell6);
t.Rows.AddAt(0, row);
Table t8 = (Table)gv.Controls[0];
}
}
//function to load company products
private void LoadProducts()
{
BLL obj = new BLL();
DataTable tabProducts = new DataTable();
try
{
if (DropDownListCompanies.SelectedIndex > 0)
{
if (DropDownListCategories.SelectedIndex > 0)
{
tabProducts = obj.GetProductsByCompanyIdandCategoryId(DropDownListCompanies.SelectedValue, int.Parse(DropDownListCategories.SelectedValue));
}
else
{
tabProducts = obj.GetProductsByCompany(DropDownListCompanies.SelectedValue);
}
}
else
{
tabProducts = obj.GetAllProducts();
}
if (tabProducts.Rows.Count > 0)
{
tableProducts.Rows.Clear();
tableProducts.BorderStyle = BorderStyle.Double;
tableProducts.GridLines = GridLines.Both;
tableProducts.BorderColor = System.Drawing.Color.DarkGray;
TableRow headerrow = new TableRow();
headerrow.Height = 30;
headerrow.ForeColor = System.Drawing.Color.WhiteSmoke;
headerrow.BackColor = System.Drawing.Color.Gray;
TableCell cell1 = new TableCell();
cell1.Text = "<b>Photo</b>";
headerrow.Controls.Add(cell1);
TableCell cell3 = new TableCell();
cell3.Text = "<b>Category Name</b>";
headerrow.Controls.Add(cell3);
TableCell cell4 = new TableCell();
cell4.Text = "<b>Product Name</b>";
headerrow.Controls.Add(cell4);
TableCell cell5 = new TableCell();
cell5.Text = "<b>Product Cost</b>";
headerrow.Controls.Add(cell5);
if (DropDownListCompanies.SelectedIndex > 0 && DropDownListCategories.SelectedIndex > 0)
{
TableCell cell6 = new TableCell();
cell6.Text = "<b>Rating</b>";
headerrow.Controls.Add(cell6);
}
tableProducts.Controls.Add(headerrow);
for (int cnt = 0; cnt < tabProducts.Rows.Count; cnt++)
{
TableRow row = new TableRow();
row.Height = 30;
TableCell cellPhoto = new TableCell();
cellPhoto.VerticalAlign = VerticalAlign.Top;
cellPhoto.Width = 50;
cellPhoto.Height = 50;
Image imgPhoto = new Image();
imgPhoto.Width = 50;
imgPhoto.Height = 50;
imgPhoto.ImageUrl = tabProducts.Rows[cnt]["ProductPhoto"].ToString();
cellPhoto.Controls.Add(imgPhoto);
row.Controls.Add(cellPhoto);
TableCell cellType = new TableCell();
cellType.Width = 150;
DataTable tabCategory = new DataTable();
tabCategory = obj.GetCategoryById(int.Parse(tabProducts.Rows[cnt]["CategoryId"].ToString()));
cellType.Text = tabCategory.Rows[0]["CategoryName"].ToString();
row.Controls.Add(cellType);
TableCell cellPName = new TableCell();
cellPName.Width = 150;
HyperLink hypPName = new HyperLink();
hypPName.Text = tabProducts.Rows[cnt]["ProductName"].ToString();
hypPName.NavigateUrl = string.Format("~/Customer/ProductDetails.aspx?categoryId={0}&productId={1}&productName={2}", tabProducts.Rows[cnt]["CategoryId"].ToString(), tabProducts.Rows[cnt]["ProductId"].ToString(), tabProducts.Rows[cnt]["ProductName"].ToString());
cellPName.Controls.Add(hypPName);
row.Controls.Add(cellPName);
TableCell cellCost = new TableCell();
cellCost.Width = 150;
cellCost.Text = tabProducts.Rows[cnt]["ProductCost"].ToString();
row.Controls.Add(cellCost);
if (DropDownListCompanies.SelectedIndex > 0 && DropDownListCategories.SelectedIndex > 0)
{
TableCell cellRating = new TableCell();
DropDownList dropdownlistRating = new DropDownList();
dropdownlistRating.Width = 200;
dropdownlistRating.ID = tabProducts.Rows[cnt]["ProductId"].ToString();
for (int i = 1; i < 6; i++)
{
dropdownlistRating.Items.Add(i.ToString());
}
DataTable tabRatings = new DataTable();
tabRatings = obj.CheckCustomerRating(Session["CustomerId"].ToString(), int.Parse(tabProducts.Rows[cnt]["ProductId"].ToString()));
if (tabRatings.Rows.Count > 0)
{
string valueText = dropdownlistRating.Items.FindByValue(tabRatings.Rows[0]["Rating"].ToString()).ToString();
ListItem itemValue = new ListItem(valueText, tabRatings.Rows[0]["Rating"].ToString());
int Index = dropdownlistRating.Items.IndexOf(itemValue);
if (Index != -1)
{
dropdownlistRating.SelectedIndex = Index;
}
}
cellRating.Controls.Add(dropdownlistRating);
row.Controls.Add(cellRating);
}
tableProducts.Controls.Add(row);
}
}
else
{
tableProducts.Rows.Clear();
tableProducts.GridLines = GridLines.None;
TableHeaderRow row = new TableHeaderRow();
TableHeaderCell cell = new TableHeaderCell();
cell.Font.Bold = true;
cell.ForeColor = System.Drawing.Color.Red;
cell.ColumnSpan = 5;
cell.Text = "No Products Found";
row.Controls.Add(cell);
tableProducts.Controls.Add(row);
}
}
catch
{
}
}
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
GridView gv = sender as GridView;
//((Label)gv.HeaderRow.FindControl("label8")).Text = "dd".ToString();
if (gv.HasControls())
{
GridViewRow row = new GridViewRow(0, 2, DataControlRowType.Header, DataControlRowState.Normal);
Table t = (Table)GridView1.Controls[0];
// Adding Cells
TableCell FileDate = new TableHeaderCell();
FileDate.Text = "Particulars";
FileDate.ColumnSpan = 3;
row.Cells.Add(FileDate);
TableCell cell = new TableHeaderCell();
cell.ColumnSpan = 7; // ********
cell.Text = "CPF Subscription";
row.Cells.Add(cell);
//t.Rows.AddAt(0, row);
//TableCell FileDate1 = new TableHeaderCell();
//FileDate1.ColumnSpan = 0;
//row.Cells.Add(FileDate1);
//TableCell cell1 = new TableHeaderCell();
//cell1.ColumnSpan = 4; // ********
//cell1.Text = "Employer's Share";
//row.Cells.Add(cell1);
TableCell cell2 = new TableHeaderCell();
cell2.ColumnSpan = 4; // ********
cell2.Text = "Interest on Subscription";
row.Cells.Add(cell2);
t.Rows.AddAt(0, row);
//TableCell cell3 = new TableHeaderCell();
//cell3.ColumnSpan = 4; // ********
//cell3.Text = "Interest on Employer Share";
//row.Cells.Add(cell3);
//TableCell cell4 = new TableHeaderCell();
//cell4.ColumnSpan = 2; // ********
//cell4.Text = "Progressive total issue";
//row.Cells.Add(cell4);
//TableCell cell5 = new TableHeaderCell();
//cell5.ColumnSpan = 2; // ********
//cell5.Text = "Balance";
//row.Cells.Add(cell5);
//TableCell cell6 = new TableHeaderCell();
//cell6.Text = "";
//row.Cells.Add(cell6);
//t.Rows.AddAt(0, row);
//next row
//if (e.Row.RowType == DataControlRowType.Header)
//{
GridViewRow tr = new GridViewRow(0, -1, DataControlRowType.Header, DataControlRowState.Normal);
//for (short i = 1; i <= 13; ++i)
//{
TableCell td = new TableCell();
td.Text = "1".ToString();
tr.Cells.Add(td);
//}
TableCell td1 = new TableCell();
td1.Text = "2".ToString();
tr.Cells.Add(td1);
TableCell td2 = new TableCell();
td2.Text = "3".ToString();
tr.Cells.Add(td2);
TableCell td26 = new TableCell();
td26.Text = "4".ToString();
tr.Cells.Add(td26);
TableCell td27 = new TableCell();
td27.Text = "5".ToString();
tr.Cells.Add(td27);
TableCell td3 = new TableCell();
td3.Text = "6".ToString();
tr.Cells.Add(td3);
TableCell td4 = new TableCell();
td4.Text = "7".ToString();
tr.Cells.Add(td4);
TableCell td5 = new TableCell();
td5.Text = "8".ToString();
tr.Cells.Add(td5);
TableCell td6 = new TableCell();
td6.Text = "9".ToString();
tr.Cells.Add(td6);
TableCell td7 = new TableCell();
td7.Text = "10".ToString();
tr.Cells.Add(td7);
//TableCell td8 = new TableCell();
//td8.Text = "11".ToString();
//tr.Cells.Add(td8);
//TableCell td9 = new TableCell();
//td9.Text = "12".ToString();
//tr.Cells.Add(td9);
//TableCell td10 = new TableCell();
//td10.Text = "13".ToString();
//tr.Cells.Add(td10);
//TableCell td11 = new TableCell();
//td11.Text = "14".ToString();
//tr.Cells.Add(td11);
TableCell td12 = new TableCell();
td12.Text = "11".ToString();
tr.Cells.Add(td12);
TableCell td13 = new TableCell();
td13.Text = "12".ToString();
tr.Cells.Add(td13);
TableCell td14 = new TableCell();
td14.Text = "13".ToString();
tr.Cells.Add(td14);
TableCell td141 = new TableCell();
td141.Text = "14".ToString();
tr.Cells.Add(td141);
//TableCell td142 = new TableCell();
//td142.Text = "19".ToString();
//tr.Cells.Add(td142);
//TableCell td143 = new TableCell();
//td143.Text = "20".ToString();
//tr.Cells.Add(td143);
//TableCell td144 = new TableCell();
//td144.Text = "21".ToString();
//tr.Cells.Add(td144);
//TableCell td145 = new TableCell();
//td145.Text = "22".ToString();
//tr.Cells.Add(td145);
TableCell td146 = new TableCell();
td146.Text = "15".ToString();
tr.Cells.Add(td146);
//TableCell td147 = new TableCell();
//td147.Text = "16".ToString();
//tr.Cells.Add(td147);
((Table)gv.Controls[0]).Rows.Add(tr);
//}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty))
{
/*=============================*/
if (!Page.IsPostBack)
{
//โหลดแขนงวิชา
string sql = "Select * From SPECIAL_FIELD Order By SPEC_FIELD_CODE";
specialFData = specialFObj.getSpecialFieldManual(sql);
// Head Table
string[] ar = { "รหัส", "ชื่อย่อ", "ชื่อแขนงวิชา (thai)", "ชื่อแขนงวิชา (English)", "คณะ", "สถานะ", "แก้ไข", "ลบ" };
//Table tb1 = new Table();
tblSpecialField.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblSpecialField.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead = new TableHeaderRow();
tRowHead.TableSection = TableRowSection.TableHeader;
for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++)
{
// Create a new cell and add it to the row.
TableHeaderCell cellHead = new TableHeaderCell();
cellHead.Text = ar[cellCtr - 1];
tRowHead.Cells.Add(cellHead);
}
tblSpecialField.Rows.Add(tRowHead);
foreach (SpecialFieldData data in specialFData)
{
//ตรวจสอบสถานะการใช้งานของคณะ
if (new Faculty().getFaculty(data.SpecialField_FacultyCode).Faculty_Status != "0001")
{
continue;
}
else
{
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
TableCell cellCode = new TableCell();
cellCode.Text = data.SpecialField_Code;
tRowBody.Cells.Add(cellCode);
TableCell cellShortName = new TableCell();
cellShortName.Text = data.SpecialField_ShortName;
tRowBody.Cells.Add(cellShortName);
TableCell cellThai = new TableCell();
cellThai.Text = data.SpecialField_Thai;
tRowBody.Cells.Add(cellThai);
TableCell cellEng = new TableCell();
cellEng.Text = data.SpecialField_Eng;
tRowBody.Cells.Add(cellEng);
TableCell cellFaculty = new TableCell();
FacultyData fac = new Faculty().getFaculty(data.SpecialField_FacultyCode);
cellFaculty.Text = fac.Faculty_Thai;
tRowBody.Cells.Add(cellFaculty);
TableCell cellStatus = new TableCell();
//0001 = ใช้งาน
if (data.SpecialField_Status == "0001")
{
cellStatus.Text = "<h4 class='txt-color-green'><i class='fa fa-check'></i></h4>";
cellStatus.ToolTip = "ใช้งาน";
}
//0002 = ไม่ใช้งาน
if (data.SpecialField_Status == "0002")
{
cellStatus.Text = "<h4 class='txt-color-red'><i class='fa fa-times'></i></h4>";
cellStatus.ToolTip = "ไม่ใช้งาน";
}
cellStatus.CssClass = "text-center";
tRowBody.Cells.Add(cellStatus);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_Special_Field.aspx?token=" + data.SpecialField_Code;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editSpecial_Field");
hypEdit.Attributes.Add("data-toggle", "modal");
hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "Edit";
cellEdit.Controls.Add(hypEdit);
cellEdit.CssClass = "text-center";
tRowBody.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
//string urlDel = "#";
string urlDel = "delete_Special_Field.aspx?token=" + data.SpecialField_Code;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteSpecial_Field");
hypDel.Attributes.Add("data-toggle", "modal");
hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "Delete";
cellDel.Controls.Add(hypDel);
cellDel.CssClass = "text-center";
tRowBody.Cells.Add(cellDel);
tblSpecialField.Rows.Add(tRowBody);
}
}
} //end !Page.IsPostBack
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
private void parseResponse(string soapResult, string action)
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(soapResult);
XmlNamespaceManager manager = new XmlNamespaceManager(doc.NameTable);
manager.AddNamespace("ns", "http://www.nbrm.mk/klservice/");
XmlNode node = doc.DocumentElement.SelectSingleNode("//ns:GetExchangeRatesResult", manager);
string text = node.FirstChild.InnerText;
if (text.Contains("Formatot na parametarot"))
{
MyPanel.Visible = true;
MyTable.Visible = false;
return;
}
MyPanel.Visible = false;
MyTable.Visible = true;
string[] parts = text.Split(new string[] { "<KursZbir>", "</KursZbir>" }, StringSplitOptions.None);
MyTable.Rows.Clear();
TableHeaderRow row = new TableHeaderRow();
TableHeaderCell cell = new TableHeaderCell();
cell.Text = "Date";
cell.Style.Add("text-align", "center");
TableHeaderCell cell1 = new TableHeaderCell();
cell1.Text = "Currency";
cell1.Style.Add("text-align", "center");
TableHeaderCell cell2 = new TableHeaderCell();
cell2.Text = "Unit";
cell2.Style.Add("text-align", "center");
TableHeaderCell cell3 = new TableHeaderCell();
cell3.Text = "Buying rate";
cell3.Style.Add("text-align", "center");
TableHeaderCell cell4 = new TableHeaderCell();
cell4.Text = "Average rate";
cell4.Style.Add("text-align", "center");
TableHeaderCell cell5 = new TableHeaderCell();
cell5.Text = "Selling rate";
cell5.Style.Add("text-align", "center");
row.Cells.Add(cell);
row.Cells.Add(cell1);
row.Cells.Add(cell2);
row.Cells.Add(cell3);
row.Cells.Add(cell4);
row.Cells.Add(cell5);
MyTable.Rows.Add(row);
foreach (string part in parts)
{
if (part.Trim().Equals("") || part.StartsWith("<dsKurs>") || part.StartsWith("</dsKurs>"))
{
continue;
}
string[] otherParts = part.Split(new string[] { "<Datum>", "</Datum>" }, StringSplitOptions.None);
if (otherParts.Length > 0)
{
try
{
TableRow tempRow = new TableRow();
string datum = otherParts[1];
DateTime date = Convert.ToDateTime(datum);
TableCell tempCell1 = new TableCell();
if (date.Month <= 9)
{
tempCell1.Text = date.Day + ".0" + date.Month + "." + date.Year;
}
else
{
tempCell1.Text = date.Day + "." + date.Month + "." + date.Year;
}
tempCell1.Style.Add("text-align", "center");
tempRow.Cells.Add(tempCell1);
string[] partsS = otherParts[2].Split(new string[] { "<Oznaka>", "</Oznaka>" }, StringSplitOptions.None);
string oznaka = partsS[1];
TableCell tempCell = new TableCell();
tempCell.Text = oznaka;
tempCell.Style.Add("text-align", "center");
tempRow.Cells.Add(tempCell);
string[] parts2 = partsS[2].Split(new string[] { "<Nomin>", "</Nomin>" }, StringSplitOptions.None);
string nomin = parts2[1];
TableCell tempCell2 = new TableCell();
tempCell2.Text = nomin;
tempCell2.Style.Add("text-align", "center");
tempRow.Cells.Add(tempCell2);
string[] parts3 = parts2[2].Split(new string[] { "<Kupoven>", "</Kupoven>" }, StringSplitOptions.None);
string kupoven = parts3[1];
TableCell tempCell3 = new TableCell();
tempCell3.Text = kupoven;
tempCell3.Style.Add("text-align", "center");
tempRow.Cells.Add(tempCell3);
string[] parts4 = parts3[2].Split(new string[] { "<Sreden>", "</Sreden>" }, StringSplitOptions.None);
string sreden = parts4[1];
TableCell tempCell4 = new TableCell();
tempCell4.Text = sreden;
tempCell4.Style.Add("text-align", "center");
tempRow.Cells.Add(tempCell4);
string[] parts5 = parts4[2].Split(new string[] { "<Prodazen>", "</Prodazen>" }, StringSplitOptions.None);
string prodazen = parts5[1];
TableCell tempCell5 = new TableCell();
tempCell5.Text = prodazen;
tempCell5.Style.Add("text-align", "center");
tempRow.Cells.Add(tempCell5);
MyTable.Rows.Add(tempRow);
}
catch (Exception ex)
{
}
}
}
}
protected void afternoon_Click(object sender, EventArgs e)
{
if (Session["number"] == null)
{
Response.Write("<script>alert('登录时间过期，请重新登录');window.location='../login.aspx';</script>");
return;
}
if (ddl_number.Text == "")
{
return;
}
DateTime time1 = Convert.ToDateTime(startime.Text);
DateTime time2 = Convert.ToDateTime(endtime.Text);
System.TimeSpan ND = time2 - time1;
int n = ND.Days; //天数差
if (time1 > time2)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('开始时间大于结束时间，请重新选择')</script>");
}
else
{
if (n > 31)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('只能查询31天以内的记录，请重新选择')</script>");
}
else
{
string gettime1 = "", gettime2 = "", gettime3 = "", gettime4 = "", gettime5 = "", getcanbu = "", getchebu = "", getchidao = "", getzaotiu = "", getqueqin = "", getligang = "", getnianxiu = "", getshijia = "", getlinshijia = "", getbingjia = "", getkuanggong = "";//获取早上考勤时间，允许迟到时间，旷工时间,午休时间,下午下班时间,加班时间,迟到时间，早退时间，旷工时间
double TADD1 = 0, TADD2 = 0, TADD3 = 0, TADD4 = 0;
int FADD = 0;
double CANADD = 0, CHEADD = 0;
String sql1 = "SELECT * FROM [KaoQinCanShu] where banci=@number";
SqlParameter[] sps1 = new SqlParameter[]
{
new SqlParameter("@number", ddr_banci.SelectedItem.Text),
};
using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql1, sps1))
{
if (dr.Read())
{
gettime1 = dr.GetString(dr.GetOrdinal("time1"));
gettime2 = dr.GetString(dr.GetOrdinal("time2"));
gettime3 = dr.GetString(dr.GetOrdinal("time3"));
gettime4 = dr.GetString(dr.GetOrdinal("time4"));
gettime5 = dr.GetString(dr.GetOrdinal("time5"));//晚班时间
getcanbu = dr.GetString(dr.GetOrdinal("canbu"));
getchebu = dr.GetString(dr.GetOrdinal("chebu"));
getchidao = dr.GetString(dr.GetOrdinal("chidao"));
getzaotiu = dr.GetString(dr.GetOrdinal("zaotiu"));
getqueqin = dr.GetString(dr.GetOrdinal("queqin"));
getligang = dr.GetString(dr.GetOrdinal("ligang"));
getnianxiu = dr.GetString(dr.GetOrdinal("nianxiu"));
getshijia = dr.GetString(dr.GetOrdinal("shijia"));
getlinshijia = dr.GetString(dr.GetOrdinal("linshijia"));
getbingjia = dr.GetString(dr.GetOrdinal("bingjia"));
getkuanggong = dr.GetString(dr.GetOrdinal("kuanggong"));
}
SqlHelper.Close();
}
TableHeaderRow thr = new TableHeaderRow();
//构建表头
string[] s_th = "日期,第一次刷卡(到岗)时间,最后一次刷卡(离岗)时间,累计在岗(小时),累计上岗时间(小时),累计离岗时间(小时),累计加班时间(小时),餐补,车补,缺勤,状态(早、晚),考勤分(扣分)".Split(',');
foreach (string _s in s_th)
{
TableHeaderCell thd = new TableHeaderCell();
thd.Text = _s;
thr.Cells.Add(thd);
}
tb_result.Rows.Add(thr);
//int i = 0;
for (int i = 0; i <= n; i++)
{
TableRow tr = new TableRow();
//日期
String strendti = time1.AddDays(i).ToString("yyyy-MM-dd");
string starttime = time1.AddDays(1 + i).ToString("yyyy-MM-dd");
TableCell td = new TableCell();
td.Text = strendti;
tr.Cells.Add(td);
////姓名
//TableCell td1 = new TableCell();
//td1.Text = Session["name"].ToString();
//tr.Cells.Add(td1);
string str_sql = "SELECT * FROM [cardinf] where c_id='" + ddl_number.SelectedItem.Text + "'and c_addr='" + ddr_address.SelectedItem.Text + "'and c_time>'" + strendti + "' and c_time<'" + starttime + "' ORDER BY c_time";
DataSet ds2 = SqlHelper.ExecuteDataSet(str_sql);
int i1 = ds2.Tables[0].Rows.Count;
string firsttime = "", lastime = "", Tjin = "", Tchu = "";
bool firstcardtime = true;
double T1 = 0, T2 = 0;
for (int j = 0; j < i1; j++)
{
if (ds2.Tables[0].Rows[j]["c_status"].ToString() == "进")
{
if (firstcardtime)
{
firsttime = ds2.Tables[0].Rows[j]["c_time"].ToString();
firstcardtime = false;
}
if (j + 1 < i1)
{
if (ds2.Tables[0].Rows[j + 1]["c_status"].ToString() == "进")
{
continue;
}
else
{
Tjin = ds2.Tables[0].Rows[j]["c_time"].ToString();
}
}
else
{
Tjin = ds2.Tables[0].Rows[j]["c_time"].ToString();
}
}
else
if (ds2.Tables[0].Rows[j]["c_status"].ToString() == "出")
{
if (j + 1 < i1)
{
if (ds2.Tables[0].Rows[j + 1]["c_status"].ToString() == "出")
{
continue;
}
else
{
Tchu = ds2.Tables[0].Rows[j]["c_time"].ToString();
}
}
else
{
Tchu = ds2.Tables[0].Rows[j]["c_time"].ToString();
}
lastime = ds2.Tables[0].Rows[j]["c_time"].ToString();
}
//累计在岗时间
if (Tjin != "" && Tchu != "")
{
DateTime time11 = Convert.ToDateTime(Tjin);
DateTime time21 = Convert.ToDateTime(Tchu);
if (time21 > time11)
{
System.TimeSpan ND11 = time21 - time11;
T1 += (double)ND11.TotalSeconds / (60 * 60); //秒数差
}
}
if (Tjin != "" && Tchu != "")
{
DateTime time12 = Convert.ToDateTime(Tjin);
DateTime time22 = Convert.ToDateTime(Tchu);
if (time22 < time12)
{
System.TimeSpan ND22 = time12 - time22;
T2 += (double)ND22.TotalSeconds / (60 * 60); //秒数差
}
}
}
//到岗时间
TableCell td2 = new TableCell();
td2.Text = firsttime;
tr.Cells.Add(td2);
//最后一次刷卡时间
TableCell td_last = new TableCell();
td_last.Text = lastime;
tr.Cells.Add(td_last);
//累计在岗
double T3 = 0;
TableCell td3 = new TableCell();
string nowtime2 = DateTime.Now.ToString("yyyy-MM-dd");
DateTime timenowtime2 = Convert.ToDateTime(nowtime2);
DateTime strendtime2 = Convert.ToDateTime(strendti);
DateTime time8 = Convert.ToDateTime(strendti + " " + gettime4);//下午下班时间6：00
if (firsttime != "")
{
DateTime time5 = Convert.ToDateTime(strendti + " " + gettime2); //上午下班时间11：45
DateTime time4 = Convert.ToDateTime(strendti + " " + gettime3); //下午上班时间12：45
DateTime time9 = Convert.ToDateTime(strendti + " " + gettime5); //晚上上班班时间6：30
DateTime time6 = Convert.ToDateTime(firsttime); //第一次刷卡时间
System.TimeSpan ND1 = time4 - time5; //中午午休时间
double wuxiu = (double)ND1.TotalSeconds / (60 * 60); //秒数差
System.TimeSpan ND2 = time9 - time8; //下午晚休时间
double wanxiu = (double)ND2.TotalSeconds / (60 * 60); //秒数差
string nowtim3 = DateTime.Now.ToString();
DateTime time3 = Convert.ToDateTime(nowtim3); //当前时间
if (timenowtime2 == strendtime2) //如果时间为当前系统的年月日（同当日明细查询）
{
if (time3 > time8 && lastime != "") //当前系统的时间大于下午下班时间
{
DateTime time7 = Convert.ToDateTime(lastime); //最后一次刷卡时间
if (time7 > time9) //最后一次刷卡时间大于晚上上班时间
{
System.TimeSpan ND11 = time7 - time6; //最后一次刷卡时间-第一次刷卡时间
T3 = (double)ND11.TotalSeconds / (60 * 60) - wuxiu - wanxiu;
}
if (time7 < time9 && time7 > time4) //最后一次刷卡时间小于晚上上班时间，大于下午下班时间12：45<time<6:30
{
System.TimeSpan ND1c = time7 - time6; //最后一次刷卡时间-第一次刷卡时间
T3 = (double)ND1c.TotalSeconds / (60 * 60) - wuxiu;
}
if (time7 < time4)//最后一次刷卡时间小于下午上班时间
{
System.TimeSpan ND2c = time7 - time6;
T3 = (double)ND2c.TotalSeconds / (60 * 60);
}
}
if (time3 < time8) //当前系统时间小于下午下班时间
{
if (time3 > time4) //当前系统大于下午上班时间
{
System.TimeSpan ND31 = time3 - time6; //中午午休时间
T3 = (double)ND31.TotalSeconds / (60 * 60) - wuxiu;
}
if (time3 < time4)
{
System.TimeSpan ND41 = time3 - time6;//中午午休时间
T3 = (double)ND41.TotalSeconds / (60 * 60);
}
}
}
else if (lastime != "")
{
DateTime time7 = Convert.ToDateTime(lastime); //最后一次刷卡时间
if (time7 > time9) //最后一次刷卡时间大于晚上上班时间
{
System.TimeSpan ND3 = time7 - time6;
T3 = (double)ND3.TotalSeconds / (60 * 60) - wuxiu - wanxiu;
}
if (time7 > time4 && time7 < time9)//最后一次刷卡时间大于下午上班时间小于晚上上班时间
{
System.TimeSpan ND4 = time7 - time6;
T3 = (double)ND4.TotalSeconds / (60 * 60) - wuxiu;
}
if (time7 < time4)//最后一次刷卡时间小于下午上班时间
{
System.TimeSpan ND5 = time7 - time6;
T3 = (double)ND5.TotalSeconds / (60 * 60);
}
}
}
if (T3 < 0)
{
T3 = 0;
}
td3.Text = T3.ToString("f2");
tr.Cells.Add(td3);
TADD1 += double.Parse(td3.Text);//累加
//累计上岗时间
TableCell td4 = new TableCell();
td4.Text = T1.ToString("f2");
tr.Cells.Add(td4);
TADD2 += double.Parse(td4.Text);//累计
//累计离岗
TableCell td5 = new TableCell();
td5.Text = T2.ToString("f2");
tr.Cells.Add(td5);
TADD3 += double.Parse(td5.Text);//累加
TableCell td6 = new TableCell();
TableCell td7 = new TableCell();
TableCell td8 = new TableCell();
double T4 = 0; //累计加班
string canbu = "", chebu = ""; //餐补，车补
if (firsttime != "" && lastime != "")
{
DateTime timelast = Convert.ToDateTime(lastime); //最后一次刷卡时间
DateTime timewanban = Convert.ToDateTime(strendti + " " + gettime5); //加班时间
if (timelast > timewanban)
{
System.TimeSpan ND4 = timelast - timewanban;//中午午休时间
T4 = (double)ND4.TotalSeconds / (60 * 60);
}
DateTime timecanbu = Convert.ToDateTime(strendti + " " + getcanbu); //餐补时间
DateTime timechebu = Convert.ToDateTime(strendti + " " + getchebu); //车补时间
String sql_canbu = "SELECT * FROM [userinfo] where number='" + ddl_number.SelectedItem.Text + "'";
using (SqlDataReader dr_canbu = SqlHelper.ExecuteReader(CommandType.Text, sql_canbu))
{
if (dr_canbu.Read())
{
if (dr_canbu["canbu"] != System.DBNull.Value)
{
canbu = dr_canbu.GetString(dr_canbu.GetOrdinal("canbu"));
}
if (dr_canbu["chebu"] != System.DBNull.Value)
{
chebu = dr_canbu.GetString(dr_canbu.GetOrdinal("chebu"));
}
}
SqlHelper.Close();
}
if (timelast < timecanbu)
{
canbu = "";
}
if (timelast < timechebu)
{
chebu = "";
}
}
td6.Text = T4.ToString("f2");;
tr.Cells.Add(td6);
TADD4 += double.Parse(td6.Text);//累加
//餐补
td7.Text = canbu;
tr.Cells.Add(td7);
if (canbu != "")
{
CANADD += double.Parse(canbu);
}
//车补
td8.Text = chebu;
tr.Cells.Add(td8);
if (chebu != "")
{
CHEADD += double.Parse(chebu);
}
//缺勤
TableCell td9 = new TableCell();
//判断是否是工作日
bool gongzuoritf = false;
string[] sArray = strendti.Split('-');
string nianfen = sArray[0] + "-" + sArray[1];
DateTime t = Convert.ToDateTime(strendti);;
String sql_gongzuo = "SELECT * FROM [gongzuori] where YearMon='" + nianfen + "'";
SqlParameter[] sps_gongzuo = new SqlParameter[]
{
new SqlParameter("@number", ddr_banci.SelectedItem.Text),
};
using (SqlDataReader dr_gongzuo = SqlHelper.ExecuteReader(CommandType.Text, sql_gongzuo, sps_gongzuo))
{
string getnianfen = "";
if (dr_gongzuo.Read())
{
getnianfen = dr_gongzuo.GetString(dr_gongzuo.GetOrdinal("gongzuodate"));
getnianfen = getnianfen.Replace("\n", string.Empty).Replace("\r", string.Empty);
string[] str_getnianfen = getnianfen.Split(',');
foreach (string _s in str_getnianfen)
{
if (strendti == _s)
{
gongzuoritf = true;
break;
}
}
SqlHelper.Close();
}
}
//获取请假记录
string qingjiashixiang = "";
bool kaoqinbool = false;
string Fen1 = "", Fen2 = "";//请假打分、出勤打分（迟到、早退、旷工）
String sql_qingjia = "SELECT * FROM [qingjia] where q_number='" + ddl_number.SelectedItem.Text + "' and q_enddate>='" + strendti + " " + gettime1 + "' and q_startdate<='" + strendti + " " + gettime4 + "' and q_statue='4'";
using (SqlDataReader dr_qingjia = SqlHelper.ExecuteReader(CommandType.Text, sql_qingjia))
{
if (dr_qingjia.Read())
{
qingjiashixiang = dr_qingjia.GetString(dr_qingjia.GetOrdinal("q_shixiang"));
kaoqinbool = true;
if (qingjiashixiang == "事假")
{
Fen1 = getshijia;
}
if (qingjiashixiang == "临时假")
{
Fen1 = getlinshijia;
}
if (qingjiashixiang == "年假")
{
Fen1 = getnianxiu;
}
if (qingjiashixiang == "病假")
{
Fen1 = getbingjia;
}
SqlHelper.Close();
}
else
if (firsttime == "")
{
if (timenowtime2 < strendtime2)
{
qingjiashixiang = "暂未记录";
}
else
{
if (!gongzuoritf)
{
qingjiashixiang = "休假";
}
else
{
qingjiashixiang = "旷工";
}
}
}
SqlHelper.Close();
}
td9.Text = qingjiashixiang;
tr.Cells.Add(td9);
//状态
TableCell td10 = new TableCell();
td10.Text = " ";
if (timenowtime2 < strendtime2)
{
td10.Text = "暂未记录";
}
else if (!kaoqinbool && gongzuoritf)
{
if (qingjiashixiang == "休假")
{
td10.Text = "";
}
else if (firsttime != "")
{
int Intgetchidao = int.Parse(getchidao) * 60; //迟到时间范围
int Intgetzaot = int.Parse(getzaotiu) * 60; //早退时间范围
int Intgetqueqin = int.Parse(getqueqin) * 60; //缺勤时间范围，超过为旷工
td10.Text = "";
DateTime DTcardgettime1 = Convert.ToDateTime(firsttime); //获取第一次刷卡时间
string kaoqintime = strendti + " " + gettime1; //获取早上考勤时间
DateTime DTkaoqintime = Convert.ToDateTime(kaoqintime);
System.TimeSpan NDkaoqin = DTcardgettime1 - DTkaoqintime; //早上考勤
int nTSeconds = (int)NDkaoqin.TotalSeconds; //秒数差
if (DTcardgettime1 > DTkaoqintime) //第一次刷卡时间大于早上考勤时间
{
if (nTSeconds <= Intgetchidao) //迟到时间小于等于迟到考勤时间范围
{
td10.Text = "正常,";
}
else
if (nTSeconds >= Intgetchidao && nTSeconds <= Intgetqueqin)
{
td10.Text = "迟到,";
Fen2 = getligang;
}
else
if (nTSeconds > Intgetqueqin)
{
td10.Text = "旷工,";
Fen2 = getkuanggong;
}
}
else
{
td10.Text = "正常,";
}
string getnowtime = DateTime.Now.ToString();
DateTime getnowdate = Convert.ToDateTime(getnowtime);//当前时间
if (lastime != "" && gongzuoritf)
{
DateTime timelast1 = Convert.ToDateTime(lastime); //最后一次刷卡时间
System.TimeSpan NDkaoqinxiawu = time8 - timelast1; //下午考勤
int nTSecondsxiawu = (int)NDkaoqinxiawu.TotalSeconds; //秒数差
if (timelast1 < time8 && getnowdate > time8) //最后一次刷卡时间小于下午下班时间
{
if (nTSecondsxiawu <= Intgetzaot) //迟到时间小于等于迟到考勤时间范围
{
td10.Text += "正常";
}
else
if (nTSecondsxiawu > Intgetzaot && nTSecondsxiawu <= Intgetqueqin)
{
td10.Text += "早退";
if (Fen2 != getkuanggong && Fen2 == getligang)
{
int intligang = int.Parse(getligang) + int.Parse(getligang);
Fen2 = intligang.ToString();
}
if (Fen2 != getkuanggong && Fen2 != getligang)
{
Fen2 = getligang;
}
}
else
if (nTSecondsxiawu > Intgetqueqin)
{
td10.Text += "旷工";
Fen2 = getkuanggong;
}
}
if (timelast1 > time8 && getnowdate > time8)
{
td10.Text += "正常";
}
if (DTcardgettime1 <= DTkaoqintime && timelast1 >= time8)
{
td10.Text = "正常,正常";
}
if (getnowdate > time8)
{
if (nTSecondsxiawu + nTSeconds > Intgetqueqin)
{
Fen2 = getkuanggong;
}
}
}
else
{
if (getnowdate > time8)
{
td10.Text += "旷工";
Fen2 = getkuanggong;
}
}
}
else
{
td10.Text = "缺勤";
Fen2 = getkuanggong;
}
}
tr.Cells.Add(td10);
TableCell td11 = new TableCell();
int intfen1 = 0, intfen2 = 0;
if (Fen1 != "")
{
intfen1 = int.Parse(Fen1);
}
if (Fen2 != "")
{
intfen2 = int.Parse(Fen2);
}
int zongfen = intfen1 + intfen2;
FADD += zongfen;
td11.Text = zongfen.ToString();
tr.Cells.Add(td11);
tb_result.Rows.Add(tr);
}
TableRow trZ = new TableRow();
TableCell tdZ1 = new TableCell();
tdZ1.Text = "累加";
trZ.Cells.Add(tdZ1);
TableCell tdZ2 = new TableCell();
tdZ2.Text = "";
trZ.Cells.Add(tdZ2);
TableCell tdZ_last = new TableCell();
tdZ_last.Text = "";
trZ.Cells.Add(tdZ_last);
TableCell tdZ3 = new TableCell();
tdZ3.Text = TADD1.ToString("f2");
trZ.Cells.Add(tdZ3);
TableCell tdZ4 = new TableCell();
tdZ4.Text = TADD2.ToString("f2");
trZ.Cells.Add(tdZ4);
TableCell tdZ5 = new TableCell();
tdZ5.Text = TADD3.ToString("f2");
trZ.Cells.Add(tdZ5);
TableCell tdZ6 = new TableCell();
tdZ6.Text = TADD4.ToString("f2");
trZ.Cells.Add(tdZ6);
//餐补
TableCell tdZ7 = new TableCell();
tdZ7.Text = CANADD.ToString("f1");
trZ.Cells.Add(tdZ7);
TableCell tdZ8 = new TableCell();
tdZ8.Text = CHEADD.ToString("f1");
trZ.Cells.Add(tdZ8);
TableCell tdZ9 = new TableCell();
tdZ2.Text = "";
trZ.Cells.Add(tdZ9);
TableCell tdZ10 = new TableCell();
tdZ10.Text = "";
trZ.Cells.Add(tdZ10);
//考勤分
TableCell tdZ11 = new TableCell();
tdZ11.Text = FADD.ToString();
trZ.Cells.Add(tdZ11);
tb_result.Rows.Add(trZ);
}
}
}
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
GridView gv = sender as GridView;
GridViewRow row = new GridViewRow(0, -1, DataControlRowType.Header, DataControlRowState.Normal);
Table t = (Table)gv.Controls[0];
// Adding Cells
TableCell FileDate = new TableHeaderCell();
FileDate.Text = "Time";
row.Cells.Add(FileDate);
GridViewRow row1 = new GridViewRow(0, -1, DataControlRowType.Header, DataControlRowState.Normal);
Table t1 = (Table)gv.Controls[0];
// Adding Cells
TableCell FileDate3 = new TableHeaderCell();
FileDate3.ColumnSpan = 1;
row1.Cells.Add(FileDate3);
TableCell FileDate31 = new TableHeaderCell();
FileDate31.Text = "From";
row1.Cells.Add(FileDate31);
TableCell FileDate32 = new TableHeaderCell();
FileDate32.Text = "To";
row1.Cells.Add(FileDate32);
TableCell FileDate33 = new TableHeaderCell();
FileDate33.Text = "From";
row1.Cells.Add(FileDate33);
TableCell FileDate329 = new TableHeaderCell();
FileDate329.Text = "To";
row1.Cells.Add(FileDate329);
TableCell FileDate326 = new TableHeaderCell();
FileDate326.Text = "Furnace Oil Pump Pressure";
row1.Cells.Add(FileDate326);
TableCell FileDate337 = new TableHeaderCell();
FileDate337.Text = "Temperature Of Furnace Oil";
row1.Cells.Add(FileDate337);
TableCell FileDate327 = new TableHeaderCell();
FileDate327.Text = "Boiler Steam Pressure";
row1.Cells.Add(FileDate327);
TableCell FileDate338 = new TableHeaderCell();
FileDate338.Text = "Temperature of Oil service tank";
row1.Cells.Add(FileDate338);
TableCell FileDate328 = new TableHeaderCell();
FileDate328.Text = "PH(Water)";
row1.Cells.Add(FileDate328);
TableCell FileDate339 = new TableHeaderCell();
FileDate339.Text = "Water Charges";
row1.Cells.Add(FileDate339);
TableCell FileDate340 = new TableHeaderCell();
FileDate340.Text = "Furanace oil expense";
row1.Cells.Add(FileDate340);
TableCell FileDate341 = new TableHeaderCell();
FileDate341.Text = "Particulars";
row1.Cells.Add(FileDate341);
t1.Rows.AddAt(0, row1);
TableCell cell3 = new TableHeaderCell();
cell3.ColumnSpan = 2;
cell3.Text = "Start Time";
row.Cells.Add(cell3);
t.Rows.AddAt(0, row);
TableCell cell4 = new TableHeaderCell();
cell4.ColumnSpan = 2;
cell4.Text = "Stop Time";
row.Cells.Add(cell4);
t.Rows.AddAt(0, row);
// TableCell cell6 = new TableHeaderCell();
// cell6.ColumnSpan = 2;
// cell6.Text = "Fuel consumed in boiler";
// row.Cells.Add(cell6);
// t.Rows.AddAt(0, row);
// TableCell cell71 = new TableHeaderCell();
// // cell71.ColumnSpan = 2;
// cell71.Text = "Indent number";
// row.Cells.Add(cell71);
// TableCell cell7 = new TableHeaderCell();
// cell7.ColumnSpan = 2;
// cell7.Text = "Signature";
// row.Cells.Add(cell7);
// t.Rows.AddAt(0, row);
// TableCell cell8 = new TableHeaderCell();
//// cell8.ColumnSpan = 2;
// cell8.Text = "Remarks";
// row.Cells.Add(cell8);
t.Rows.AddAt(0, row);
t.Rows.AddAt(0, row);
}
}
protected void moning_Click(object sender, EventArgs e)
{
if (Session["number"] == null)
{
Response.Write("<script>alert('登录时间过期，请重新登录');window.location='../login.aspx';</script>");
return;
}
if (ddl_number.Text == "")
{
// ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('')</script>");
return;
}
string gettime1 = "", gettime2 = "", gettime3 = "", gettime4 = "", gettime5 = "", getcanbu = "", getchebu = "", getchidao = "", getzaotiu = "", getqueqin = "";//获取早上考勤时间，允许迟到时间，旷工时间,午休时间,下午下班时间,加班时间
String sql1 = "SELECT * FROM [KaoQinCanShu] where banci=@number";
SqlParameter[] sps1 = new SqlParameter[]
{
new SqlParameter("@number", ddr_banci.SelectedItem.Text),
};
using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql1, sps1))
{
if (dr.Read())
{
gettime1 = dr.GetString(dr.GetOrdinal("time1"));
gettime2 = dr.GetString(dr.GetOrdinal("time2"));
gettime3 = dr.GetString(dr.GetOrdinal("time3"));
gettime4 = dr.GetString(dr.GetOrdinal("time4"));
gettime5 = dr.GetString(dr.GetOrdinal("time5"));//晚班时间
getcanbu = dr.GetString(dr.GetOrdinal("canbu"));
getchebu = dr.GetString(dr.GetOrdinal("chebu"));
getchidao = dr.GetString(dr.GetOrdinal("chidao"));
getzaotiu = dr.GetString(dr.GetOrdinal("zaotiu"));
getqueqin = dr.GetString(dr.GetOrdinal("queqin"));
}
SqlHelper.Close();
}
TableHeaderRow thr = new TableHeaderRow();
//构建表头
// string[] s_th = "员工编号,员工姓名,第一次刷卡(到岗)时间,最后一次刷卡(离岗)时间,累计在岗(小时),累计上岗时间(小时),累计离岗时间(小时),累计加班时间(小时),餐补,车补,缺勤,状态(早、晚)".Split(',');
string[] s_th = "第一次刷卡(到岗)时间,最后一次刷卡(离岗)时间,累计在岗(小时),累计上岗时间(小时),累计离岗时间(小时),累计加班时间(小时),餐补,车补,缺勤,状态(早、晚)".Split(',');
foreach (string _s in s_th)
{
TableHeaderCell thd = new TableHeaderCell();
thd.Text = _s;
thr.Cells.Add(thd);
}
tb_result.Rows.Add(thr);
TableRow tr = new TableRow();
//员工编号
/* TableCell td = new TableCell();
* td.Text = ddl_number.SelectedItem.Text;
* tr.Cells.Add(td);
* //姓名
* string user_name = "";
* String sql_name = "SELECT * FROM [userinfo] where number=@number";
* SqlParameter[] sps_name = new SqlParameter[]
* {
* new SqlParameter("@number",ddl_number.SelectedItem.Text),
* };
* using (SqlDataReader dr_name = SqlHelper.ExecuteReader(CommandType.Text, sql_name, sps_name))
* {
*
* if (dr_name.Read())
* {
* user_name = dr_name.GetString(dr_name.GetOrdinal("name"));
*
* }
* SqlHelper.Close();
* }
* TableCell td1 = new TableCell();
* td1.Text = user_name;
* tr.Cells.Add(td1);
*/
string strendti = DateTime.Now.ToString("yyyy-MM-dd");//获取当前系统时间
string endtime = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
string str_sql = "SELECT * FROM [cardinf] where c_id='" + ddl_number.SelectedItem.Text + "'and c_addr='" + ddr_address.SelectedItem.Text + "' and c_time>'" + strendti + "' and c_time<'" + endtime + "' ORDER BY c_time";
DataSet ds2 = SqlHelper.ExecuteDataSet(str_sql);
int i = ds2.Tables[0].Rows.Count;
string firsttime = "", lastime = "", Tjin = "", Tchu = "";
bool firstcardtime = true;
double T1 = 0, T2 = 0;
for (int j = 0; j < i; j++)//进出时间累加计算，获得上岗和离岗的时间总和
{
if (ds2.Tables[0].Rows[j]["c_status"].ToString() == "进")
{
if (firstcardtime)
{
firsttime = ds2.Tables[0].Rows[j]["c_time"].ToString();
firstcardtime = false;
}
if (j + 1 < i)
{
if (ds2.Tables[0].Rows[j + 1]["c_status"].ToString() == "进")
{
continue;
}
else
{
Tjin = ds2.Tables[0].Rows[j]["c_time"].ToString();
}
}
else
{
Tjin = ds2.Tables[0].Rows[j]["c_time"].ToString();
}
}
else
if (ds2.Tables[0].Rows[j]["c_status"].ToString() == "出")
{
if (j + 1 < i)
{
if (ds2.Tables[0].Rows[j + 1]["c_status"].ToString() == "出")
{
continue;
}
else
{
Tchu = ds2.Tables[0].Rows[j]["c_time"].ToString();
}
}
else
{
Tchu = ds2.Tables[0].Rows[j]["c_time"].ToString();
}
lastime = ds2.Tables[0].Rows[j]["c_time"].ToString();
}
//累计在岗时间
if (Tjin != "" && Tchu != "")
{
DateTime time1 = Convert.ToDateTime(Tjin);
DateTime time2 = Convert.ToDateTime(Tchu);
if (time2 > time1)
{
System.TimeSpan ND = time2 - time1;
T1 += (double)ND.TotalSeconds / (60 * 60); //秒数差
}
}
//累计离岗时间
if (Tjin != "" && Tchu != "")
{
DateTime time1 = Convert.ToDateTime(Tjin);
DateTime time2 = Convert.ToDateTime(Tchu);
if (time2 < time1)
{
System.TimeSpan ND = time1 - time2;
T2 += (double)ND.TotalSeconds / (60 * 60); //秒数差
}
}
}
//到岗时间
TableCell td2 = new TableCell();
td2.Text = firsttime;
tr.Cells.Add(td2);
//最后一次刷卡时间
TableCell td_last = new TableCell();
td_last.Text = lastime;
tr.Cells.Add(td_last);
//累计在岗
double T3 = 0;
TableCell td3 = new TableCell();
DateTime time8 = Convert.ToDateTime(strendti + " " + gettime4);//下午下班时间
if (firsttime != "")
{
string nowtime2 = DateTime.Now.ToString();
DateTime time3 = Convert.ToDateTime(nowtime2); //当前时间
DateTime time4 = Convert.ToDateTime(strendti + " " + gettime3); //下午上班时间
DateTime time5 = Convert.ToDateTime(strendti + " " + gettime2); //上午下班时间
DateTime time6 = Convert.ToDateTime(firsttime); //第一次刷卡时间
DateTime time9 = Convert.ToDateTime(strendti + " " + gettime5); //晚上上班班时间6：30
System.TimeSpan ND1 = time4 - time5; //中午午休时间
double wuxiu = (double)ND1.TotalSeconds / (60 * 60); //秒数差
System.TimeSpan ND2 = time9 - time8; //下午晚休时间
double wanxiu = (double)ND2.TotalSeconds / (60 * 60); //秒数差
if (time3 > time8 && lastime != "") //当前系统的时间大于下午下班时间
{
DateTime time7 = Convert.ToDateTime(lastime); //最后一次刷卡时间
if (time7 > time9) //最后一次刷卡时间大于晚上上班时间
{
System.TimeSpan ND11 = time7 - time6; //最后一次刷卡时间-第一次刷卡时间
T3 = (double)ND11.TotalSeconds / (60 * 60) - wuxiu - wanxiu;
}
if (time7 < time9 && time7 > time4) //最后一次刷卡时间小于晚上上班时间，大于下午下班时间12：45<time<6:30
{
System.TimeSpan ND1c = time7 - time6; //最后一次刷卡时间-第一次刷卡时间
T3 = (double)ND1c.TotalSeconds / (60 * 60) - wuxiu;
}
if (time7 < time4)//最后一次刷卡时间小于下午上班时间
{
System.TimeSpan ND2c = time7 - time6;
T3 = (double)ND2c.TotalSeconds / (60 * 60);
}
}
if (time3 < time8) //当前系统时间小于下午下班时间
{
if (time3 > time4) //当前系统大于下午上班时间
{
System.TimeSpan ND31 = time3 - time6; //中午午休时间
T3 = (double)ND31.TotalSeconds / (60 * 60) - wuxiu;
}
if (time3 < time4) //当前系统时间小于下午上班时间
{
System.TimeSpan ND41 = time3 - time6; //当前时间-第一次刷卡时间
T3 = (double)ND41.TotalSeconds / (60 * 60);
}
}
}
if (T3 < 0)
{
T3 = 0;
}
td3.Text = T3.ToString("f2");
tr.Cells.Add(td3);
//累计上岗时间
TableCell td4 = new TableCell();
td4.Text = T1.ToString("f2");
tr.Cells.Add(td4);
//累计离岗
TableCell td5 = new TableCell();
td5.Text = T2.ToString("f2");
tr.Cells.Add(td5);
TableCell td6 = new TableCell();
TableCell td7 = new TableCell();
TableCell td8 = new TableCell();
double T4 = 0; //累计加班
string canbu = "", chebu = ""; //餐补，车补
if (firsttime != "" && lastime != "")
{
DateTime timelast = Convert.ToDateTime(lastime); //最后一次刷卡时间
DateTime timewanban = Convert.ToDateTime(strendti + " " + gettime5); //加班时间
if (timelast > timewanban)
{
System.TimeSpan ND4 = timelast - timewanban;//中午午休时间
T4 = (double)ND4.TotalSeconds / (60 * 60);
}
DateTime timecanbu = Convert.ToDateTime(strendti + " " + getcanbu); //餐补时间
DateTime timechebu = Convert.ToDateTime(strendti + " " + getchebu); //车补时间
String sql_canbu = "SELECT * FROM [userinfo] where number='" + ddl_number.SelectedItem.Text + "'";
using (SqlDataReader dr_canbu = SqlHelper.ExecuteReader(CommandType.Text, sql_canbu))
{
if (dr_canbu.Read())
{
if (dr_canbu["canbu"] != System.DBNull.Value)
{
canbu = dr_canbu.GetString(dr_canbu.GetOrdinal("canbu"));
}
if (dr_canbu["chebu"] != System.DBNull.Value)
{
chebu = dr_canbu.GetString(dr_canbu.GetOrdinal("chebu"));
}
}
SqlHelper.Close();
}
if (timelast < timecanbu)
{
canbu = "";
}
if (timelast < timechebu)
{
chebu = "";
}
}
td6.Text = T4.ToString("f2");;
tr.Cells.Add(td6);
//餐补
td7.Text = canbu;
tr.Cells.Add(td7);
//车补
td8.Text = chebu;
tr.Cells.Add(td8);
//缺勤
TableCell td9 = new TableCell();
//判断是否是工作日
bool gongzuoritf = false;
string getnianfen = "";
string[] sArray = strendti.Split('-');
string nianfen = sArray[0] + "-" + sArray[1];
DateTime t = Convert.ToDateTime(strendti);;
String sql_gongzuo = "SELECT * FROM [gongzuori] where YearMon='" + nianfen + "'";
SqlParameter[] sps_gongzuo = new SqlParameter[]
{
new SqlParameter("@number", ddr_banci.SelectedItem.Text),
};
using (SqlDataReader dr_gongzuo = SqlHelper.ExecuteReader(CommandType.Text, sql_gongzuo, sps_gongzuo))
{
if (dr_gongzuo.Read())
{
getnianfen = dr_gongzuo.GetString(dr_gongzuo.GetOrdinal("gongzuodate"));
getnianfen = getnianfen.Replace("\n", string.Empty).Replace("\r", string.Empty);
string[] str_getnianfen = getnianfen.Split(',');
foreach (string _s in str_getnianfen)
{
if (strendti == _s)
{
gongzuoritf = true;
break;
}
}
SqlHelper.Close();
}
}
//获取请假记录
string qingjiashixiang = "";
bool kaoqinbool = false;
String sql_qingjia = "SELECT * FROM [qingjia] where q_number='" + ddl_number.SelectedItem.Text + "' and q_enddate>='" + strendti + " " + gettime1 + "' and q_startdate<='" + strendti + " " + gettime4 + "' and q_statue='4'";
using (SqlDataReader dr_qingjia = SqlHelper.ExecuteReader(CommandType.Text, sql_qingjia))
{
if (dr_qingjia.Read())
{
qingjiashixiang = dr_qingjia.GetString(dr_qingjia.GetOrdinal("q_shixiang"));
kaoqinbool = true;
}
else
if (firsttime == "")
{
if (!gongzuoritf)
{
qingjiashixiang = "休假";
}
else
{
qingjiashixiang = "旷工";
}
}
SqlHelper.Close();
}
td9.Text = qingjiashixiang;
tr.Cells.Add(td9);
//状态
TableCell td10 = new TableCell();
if (!kaoqinbool)
{
if (firsttime != "" && gongzuoritf)
{
int Intgetchidao = int.Parse(getchidao) * 60; //迟到时间范围
int Intgetzaot = int.Parse(getzaotiu) * 60; //早退时间范围
int Intgetqueqin = int.Parse(getqueqin) * 60; //缺勤时间范围，超过为旷工
td10.Text = "";
DateTime DTcardgettime1 = Convert.ToDateTime(firsttime); //获取第一次刷卡时间
string kaoqintime = strendti + " " + gettime1; //获取早上考勤时间
DateTime DTkaoqintime = Convert.ToDateTime(kaoqintime);
System.TimeSpan NDkaoqin = DTcardgettime1 - DTkaoqintime; //早上考勤
int nTSeconds = (int)NDkaoqin.TotalSeconds; //秒数差
if (DTcardgettime1 > DTkaoqintime) //第一次刷卡时间大于早上考勤时间
{
if (nTSeconds <= Intgetchidao) //迟到时间小于等于迟到考勤时间范围
{
td10.Text = "正常,";
}
else
if (nTSeconds >= Intgetchidao && nTSeconds <= Intgetqueqin)
{
td10.Text = "迟到,";
}
else
if (nTSeconds > Intgetqueqin)
{
td10.Text = "旷工,";
}
}
else
{
td10.Text = "正常,";
}
string getnowtime = DateTime.Now.ToString();
DateTime getnowdate = Convert.ToDateTime(getnowtime);//当前时间
if (lastime != "")
{
DateTime timelast1 = Convert.ToDateTime(lastime); //最后一次刷卡时间
System.TimeSpan NDkaoqinxiawu = time8 - timelast1; //下午考勤
int nTSecondsxiawu = (int)NDkaoqinxiawu.TotalSeconds; //秒数差
if (timelast1 < time8 && getnowdate > time8) //最后一次刷卡时间小于下午下班时间
{
if (nTSecondsxiawu <= Intgetzaot) //迟到时间小于等于迟到考勤时间范围
{
td10.Text += "正常";
}
else
if (nTSecondsxiawu > Intgetzaot && nTSecondsxiawu <= Intgetqueqin)
{
td10.Text += "早退";
}
else
if (nTSecondsxiawu > Intgetqueqin)
{
td10.Text += "旷工";
}
}
if (DTcardgettime1 <= DTkaoqintime && timelast1 >= time8)
{
td10.Text = "正常,正常";
}
if (timelast1 > time8 && getnowdate > time8)
{
td10.Text += "正常";
}
}
//if (nTSecondsxiawu + nTSeconds > Intgetqueqin)
//{
// td10.Text = "旷工";
//}
}
else
{
if (td9.Text == "休假")
{
td10.Text = "";
}
else
{
td10.Text = "旷工";
}
}
}
else
{
td10.Text = "";
}
tr.Cells.Add(td10);
tb_result.Rows.Add(tr);
}
public Table[] vratiTabelaProizvodiPopust(OracleDataReader drO)
{
int i = 1;
int j = 0;
int pat = 1;
Table[] nova = new Table[100];
TableHeaderCell head;
TableCell cel;
TableRow row = new TableRow();
TableFooterRow foot;
nova[j] = new Table();
while (drO.Read())
{
if (pat == 1)
{
//nova[j] = new Table();
head = new TableHeaderCell();
head.Text = "Бр";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Производ_ID";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Attributes.Add("class", "hide");
head.Text = "Тип_ID";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Attributes.Add("class", "hide");
head.Text = "Данок_ID";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Име";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Група";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Данок";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "ЦенаНаб";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Попуст";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Цена";
row.Controls.Add(head);
nova[j].Controls.Add(row);
pat = 2;
}
if (i > 10)
{
i = 1;
j++;
row = new TableRow();
nova[j] = new Table();
head = new TableHeaderCell();
head.Text = "Бр";
head.Attributes.Add("class", "hide");
head = new TableHeaderCell();
head.Text = "Производ_ID";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Тип_ID";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Данок_ID";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Име";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Група";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Данок";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "ЦенаНаб";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Попуст";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Цена";
row.Controls.Add(head);
nova[j].Controls.Add(row);
}
row = new TableRow();
cel = new TableCell();
cel.Text = i.ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["IDP"].ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["IDT"].ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["IDD"].ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["Име"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["Група"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["Данок"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["ЦенаНаб"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["Попуст"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["Цена"].ToString();
row.Controls.Add(cel);
nova[j].Controls.Add(row);
i++;
}
Table[] kraj = new Table[j + 1];
if (nova[0].Rows.Count > 0)
{
for (int w = 0; w <= j; w++)
{
foot = new TableFooterRow();
cel = new TableCell();
cel.ColumnSpan = 5;
for (int q = 1; q <= j + 1; q++)
{
Button kopce = new Button();
kopce.ID = q.ToString();
kopce.Click += new EventHandler(kopce_Click);
kopce.Text = q.ToString();
cel.Controls.Add(kopce);
}
foot.Controls.Add(cel);
if (nova[w] != null)
nova[w].Rows.Add(foot);
kraj[w] = nova[w];
}
}
else
{
foot = new TableFooterRow();
cel = new TableCell();
cel.Text = " Нема податоци";
cel.BorderColor = System.Drawing.Color.White;
cel.BorderWidth = Unit.Pixel(2);
cel.BorderStyle = BorderStyle.Solid;
foot.Controls.Add(cel);
nova[0].Rows.Add(foot);
kraj[0] = nova[0];
}
return kraj;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["statsViewer"] == null)
{
Response.Redirect("svLogin.aspx");
}
DataView dvj = (DataView)(sdcjobs.Select(DataSourceSelectArguments.Empty));
DataView dvc = (DataView)(sdccust.Select(DataSourceSelectArguments.Empty));
dvc.Sort = "custID";
string x = Request.QueryString["fstat"].ToString();
/*if(x=="1")
* {
* TableHeaderCell thc = new TableHeaderCell();
* thc.Text = "ENDED ON";
* thc.BorderWidth = 1;
* foreach (TableHeaderRow thr in tjobs.Rows)
* thr.Cells.Add(thc);
* }
* else
* {
* TableHeaderCell thc = new TableHeaderCell();
* thc.Text = "CURRENT PHASE";
* thc.BorderWidth = 1;
* foreach (TableHeaderRow thr in tjobs.Rows)
* thr.Cells.Add(thc);
* }*/
TableHeaderCell TableHeaderDetails = new TableHeaderCell();
TableHeaderDetails.Text = "DETAILS";
TableHeaderDetails.BorderWidth = 1;
tjobs.Rows[0].Cells.Add(TableHeaderDetails);
for (int i = 0; i < dvj.Table.Rows.Count; i++)
{
if (dvj.Table.Rows[i]["over"].ToString() == x)
{
TableRow tr = new TableRow();
TableCell tc1 = new TableCell();
tc1.Text = dvj.Table.Rows[i]["jobID"].ToString();
tr.Cells.Add(tc1);
TableCell tc2 = new TableCell();
LinkButton lb2 = new LinkButton();
lb2.Text = dvj.Table.Rows[i]["machineID"].ToString();
tc2.Controls.Add(lb2);
Session["bu"] = "svJobs.aspx?fstat=0";
lb2.PostBackUrl = "jobProgress.aspx?mid=" + lb2.Text + "&jid=" + tc1.Text;
tr.Cells.Add(tc2);
TableCell tc3 = new TableCell();
LinkButton lb3 = new LinkButton();
lb3.Text = dvc.Table.Rows[dvc.Find(dvj.Table.Rows[i]["customerID"])]["custName"].ToString();
tc3.Controls.Add(lb3);
lb3.PostBackUrl = "custDesc.aspx?cid=" + dvc.Table.Rows[dvc.Find(dvj.Table.Rows[i]["customerID"])]["custID"].ToString();;
tr.Cells.Add(tc3);
TableCell tc4 = new TableCell();
tc4.Text = (Convert.ToDateTime(dvj.Table.Rows[i]["startdate"])).ToShortDateString();
tr.Cells.Add(tc4);
//TableCell tc5 = new TableCell();
//tc5.BackColor = System.Drawing.Color.Green;
//tr.Cells.Add(tc5);
//TableCell tc6 = new TableCell();
//tr.Cells.Add(tc6);
tc1.BorderWidth = 1;
tc2.BorderWidth = 1;
tc3.BorderWidth = 1;
tc4.BorderWidth = 1;
//tc5.BorderWidth = 1;
//tc6.BorderWidth = 1;
/*if (x=="0")
* {
* TableCell c = new TableCell();
* c.Text =dvj.Table.Rows[i]["currentPhaseID"].ToString();
* tr.Cells.Add(c);
* c.BorderWidth = 1;
* }
* else
* {
* TableCell c = new TableCell();
* c.Text = (Convert.ToDateTime(dvj.Table.Rows[i]["enddate"])).ToShortDateString();
* tr.Cells.Add(c);
* c.BorderWidth = 1;
* }*/
TableCell tc7 = new TableCell();
Button b = new Button();
b.ID = tc1.Text;
b.Text = "VIEW DETAILS";
b.Click += B_Click;
b.CssClass = "btn btn-default";
tc7.Controls.Add(b);
tr.Cells.Add(tc7);
tc7.BorderWidth = 1;
tjobs.Rows.Add(tr);
}
}
foreach (TableRow tr in tjobs.Rows)
{
foreach (TableCell tc in tr.Cells)
{
tc.Attributes.CssStyle.Add("text-align", "center");
}
}
}
public Table[] vratiTabelaNaracka(OracleDataReader drO)
{
int i = 1;
int j = 0;
int pat = 1;
int vkupno = 0;
Table[] nova = new Table[100];
TableHeaderCell head;
TableCell cel;
TableRow row = new TableRow();
TableFooterRow foot;
nova[j] = new Table();
while (drO.Read())
{
if (pat == 1)
{
//nova[j] = new Table();
head = new TableHeaderCell();
head.Text = "Бр";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Производ_ID";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Attributes.Add("class", "hide");
head.Text = "Тип_ID";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Attributes.Add("class", "hide");
head.Text = "Данок_ID";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Име";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Група";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Данок";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Цена";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Колинчина";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Потврди";
row.Controls.Add(head);
nova[j].Controls.Add(row);
pat = 2;
}
if (i > 10)
{
i = 1;
j++;
row = new TableRow();
nova[j] = new Table();
head = new TableHeaderCell();
head.Text = "Бр";
head.Attributes.Add("class", "hide");
head = new TableHeaderCell();
head.Text = "Производ_ID";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Тип_ID";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Данок_ID";
head.Attributes.Add("class", "hide");
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Име";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Група";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Данок";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Цена";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Колинчина";
row.Controls.Add(head);
head = new TableHeaderCell();
head.Text = "Потврди";
row.Controls.Add(head);
nova[j].Controls.Add(row);
}
row = new TableRow();
cel = new TableCell();
cel.Text = i.ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["IDP"].ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["IDT"].ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["IDD"].ToString();
cel.Attributes.Add("class", "hide");
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["Име"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["Група"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["Данок"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["Цена"].ToString();
row.Controls.Add(cel);
cel = new TableCell();
cel.Text = drO["Количина"].ToString();
row.Controls.Add(cel);
vkupno += Convert.ToInt32(drO["Количина"].ToString()) * Convert.ToInt32(drO["Цена"].ToString());
cel = new TableCell();
Button brisiBtn = new Button();
brisiBtn.Text = "Избриши";
brisiBtn.ID = "izbrisiBtn." + j.ToString() + "." + i.ToString();
// brisiBtn.Click += new EventHandler(brisiBtn_Click);
brisiBtn.Click += delKopce;
cel.Controls.Add(brisiBtn);
row.Controls.Add(cel);
nova[j].Controls.Add(row);
i++;
}
Table[] kraj = new Table[j + 1];
if (nova[0].Rows.Count > 0)
{
for (int w = 0; w <= j; w++)
{
row = new TableRow();
cel = new TableCell();
cel.Text = "Вкупно-Нарачка:" + vkupno.ToString() + ".00 ден";
cel.Attributes.Add("class", "textCellLevo textVkupno");
row.Controls.Add(cel);
nova[w].Controls.Add(row);
foot = new TableFooterRow();
cel = new TableCell();
cel.ColumnSpan = 5;
for (int q = 1; q <= j + 1; q++)
{
Button kopce = new Button();
kopce.ID = "." + q.ToString();
kopce.Click += new EventHandler(kopceLista_Click);
kopce.Text = q.ToString();
cel.Controls.Add(kopce);
}
foot.Controls.Add(cel);
if (nova[w] != null)
nova[w].Rows.Add(foot);
kraj[w] = nova[w];
}
}
else
{
foot = new TableFooterRow();
cel = new TableCell();
cel.Text = " Нарачката е празна ";
cel.BorderColor = System.Drawing.Color.White;
cel.BorderWidth = Unit.Pixel(2);
cel.BorderStyle = BorderStyle.Solid;
foot.Controls.Add(cel);
nova[0].Rows.Add(foot);
kraj[0] = nova[0];
}
return kraj;
}
} // End of btn submit method
// Method to display confirmation page
protected void displayConfirmationPage(Student studentStat)
{
// Make a table for the student in the student list
foreach (Student student in studentType)
{
// Make form contents disappear.
optionsPage.Visible = false;
// Display confirmation page
confirmationPage.Visible = true;
// Display the student's name that's in the list
studentName.Text = student.Name;
// Display the student's status
studentStatus.Text = student.ToString();
// Display basic table structure for student
// Used this source for tables: How to Add Rows and Cells Dynamically to a Table Web Server Control
// https://msdn.microsoft.com/en-us/library/7bewx260.aspx
TableHeaderRow tableHeader = new TableHeaderRow();
courseTable.Rows.Add(tableHeader);
TableHeaderCell codeHeader = new TableHeaderCell();
codeHeader.Text = "Course Code";
tableHeader.Cells.Add(codeHeader);
TableHeaderCell titleHeader = new TableHeaderCell();
titleHeader.Text = "Course Title";
tableHeader.Cells.Add(titleHeader);
TableHeaderCell hoursHeader = new TableHeaderCell();
hoursHeader.Text = "Weekly Hours";
tableHeader.Cells.Add(hoursHeader);
TableHeaderCell feeHeader = new TableHeaderCell();
feeHeader.Text = "Fee Payable";
tableHeader.Cells.Add(feeHeader);
// For the student in the list, create table content for each course selected
foreach (Course course in student.getEnrolledCourses())
{
// Create a table row
TableRow tblRow = new TableRow();
courseTable.Rows.Add(tblRow);
// Create the row cells
TableCell cellCode = new TableCell();
cellCode.Text = course.Code;
TableCell cellTitle = new TableCell();
cellTitle.Text = course.Title;
TableCell cellHours = new TableCell();
cellHours.Text = course.WeeklyHours.ToString();
TableCell cellFee = new TableCell();
cellFee.Text = "$" + course.Fee.ToString();
// Add course info seperately to each table cell
tblRow.Cells.Add(cellCode);
tblRow.Cells.Add(cellTitle);
tblRow.Cells.Add(cellHours);
tblRow.Cells.Add(cellFee);
}
// Create an additional table row for total hours and fee
TableRow tblRowTotal = new TableRow();
courseTable.Rows.Add(tblRowTotal);
TableCell cellEmpty = new TableCell();
cellEmpty.Text = "";
tblRowTotal.Cells.Add(cellEmpty);
TableCell cellTotalText = new TableCell();
// Used similar method to align text based on second response on:
// https://stackoverflow.com/questions/25245839/align-a-label-to-the-right-using-asp-net
cellTotalText.Attributes.Add("Style", "text-align:right");
cellTotalText.Text = "Total";
tblRowTotal.Cells.Add(cellTotalText);
TableCell cellTotalHours = new TableCell();
cellTotalHours.Text = student.totalWeeklyHours().ToString();
tblRowTotal.Cells.Add(cellTotalHours);
TableCell cellTotalFee = new TableCell();
cellTotalFee.Text = "$" + student.feePayable().ToString();
tblRowTotal.Cells.Add(cellTotalFee);
} // End of studentType list
} // End of display confirmation page method
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
//GridView gv55 = sender as GridView;
//GridViewRow row55 = new GridViewRow(0, -1, DataControlRowType.Header, DataControlRowState.Normal);
//Table t55 = (Table)gv55.Controls[0];
//TableCell cell55 = new TableHeaderCell();
//cell55.Text = "Species";
//cell55.RowSpan = 1;
//row55.Cells.Add(cell55);
//t55.Rows.AddAt(0, row55);
GridView gv = sender as GridView;
GridViewRow row = new GridViewRow(0, -1, DataControlRowType.Header, DataControlRowState.Normal);
Table t = (Table)gv.Controls[0];
TableCell cell1 = new TableHeaderCell();
cell1.Text = "Species";
cell1.RowSpan = 1;
row.Cells.Add(cell1);
TableCell cell2 = new TableHeaderCell();
cell2.Text = "Previous volume sold w.e.f. "+ViewState["dt1"].ToString()+" to "+ViewState["dt2"].ToString();
row.Cells.Add(cell2);
cell2.ColumnSpan = 3;
TableCell cell3 = new TableHeaderCell();
cell3.Text = "Current volume sold during "+Convert.ToDateTime(ViewState["dt3"]).ToString("MMM-yyyy");
cell3.ColumnSpan = 3;
row.Cells.Add(cell3);
TableCell cell4 = new TableHeaderCell();
cell4.Text = "Total upto " + ViewState["dt3"].ToString();
cell4.ColumnSpan = 3;
row.Cells.Add(cell4);
TableCell cell5 = new TableHeaderCell();
cell5.Text = "Previous volume sold w.e.f. " + ViewState["dt4"].ToString() + " to " + ViewState["dt5"].ToString();
cell5.ColumnSpan = 3;
row.Cells.Add(cell5);
TableCell cell6 = new TableHeaderCell();
cell6.Text = "Current volume sold during " + Convert.ToDateTime(ViewState["dt6"]).ToString("MMM-yyyy");
cell6.ColumnSpan = 3;
row.Cells.Add(cell6);
TableCell cell7 = new TableHeaderCell();
cell7.Text = "Total upto " + ViewState["dt6"].ToString();
cell7.ColumnSpan = 3;
row.Cells.Add(cell7);
t.Rows.AddAt(0, row);
Table t8 = (Table)gv.Controls[0];
}
bool IsSubTotalRowNeedToAdd = false;
bool IsGrandTotalRowNeedtoAdd = false;
bool head_t = false;
if (DataBinder.Eval(e.Row.DataItem, "categ") == null)
{
head_t=true;
}
//if (DataBinder.Eval(e.Row.DataItem, "categ") != null && ViewState["chk2"].ToString() != "")
//{
// string chk = DataBinder.Eval(e.Row.DataItem, "categ").ToString();
// if (ViewState["chk2"].ToString() != chk)
// {
// IsSubTotalRowNeedToAdd = true;
// ViewState["chk2"] = chk.ToString();
// }
// else
// {
// ViewState["chk2"] = chk.ToString();
// }
//}
if ((strPreviousRowID != string.Empty) && (DataBinder.Eval(e.Row.DataItem, "categ") != null))
if (strPreviousRowID != DataBinder.Eval(e.Row.DataItem, "categ").ToString())
IsSubTotalRowNeedToAdd = true;
if ((strPreviousRowID != string.Empty) && (DataBinder.Eval(e.Row.DataItem, "categ") == null))
{
IsSubTotalRowNeedToAdd = true;
IsGrandTotalRowNeedtoAdd = true;
intSubTotalIndex = 1;
}
#region Getting the first Group Header Text
if ((strPreviousRowID == string.Empty) && (DataBinder.Eval(e.Row.DataItem, "categ") != null))
// Getting the First column text of first group
strGroupHeaderText = DataBinder.Eval(e.Row.DataItem, "categ").ToString();
#endregion
if (IsSubTotalRowNeedToAdd)
{
#region Adding Sub Total Row
GridView grdViewOrders = (GridView)sender;
// Creating a Row
GridViewRow row = new GridViewRow(0, 0, DataControlRowType.DataRow, DataControlRowState.Insert);
//Adding Total Cell
TableCell cell = new TableCell();
// Displaying the Group Total First Column Text here.
// This value can be decided when assigning strGroupHeaderText variable value.
// cell.Text = strGroupHeaderText;
cell.HorizontalAlign = HorizontalAlign.Right;
cell.Text = "Total <a href='avascript:showNestedGridView('customerID-<%# Eval("CustomerID") %>');">
<img id="imagecustomerID-<%# Eval("CustomerID") %>" alt="Click to show/hide orders" border="0" src="plus.png" />
</a>";
cell.ColumnSpan = 1;
cell.CssClass = "SubTotalRowStyle";
row.Cells.Add(cell);
//Adding Unit Price Column
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", vol_g1);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
row.Cells.Add(cell);
//Adding Quantity Column
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", amt_g1);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
row.Cells.Add(cell);
//Adding Discount Column
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", rate_g1);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
row.Cells.Add(cell);
//Adding Amount Column
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", vol_g2);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", amt_g2);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", rate_g2);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
//Adding Amount Column
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", vol_g3);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", amt_g3);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", rate_g3);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
//Adding Amount Column
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", vol_g4);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", amt_g4);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", rate_g4);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
//Adding Amount Column
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", vol_g5);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", amt_g5);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", rate_g5);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
//Adding Amount Column
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", vol_g6);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", amt_g6);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = string.Format("{0:0.00}", rate_g6);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "SubTotalRowStyle";
//cell.ColumnSpan = 18;
row.Cells.Add(cell);
//Adding the Row at the RowIndex position in the Grid
if (count555 == 0)
{
grdViewOrders.Controls[0].Controls.AddAt(7, row);
count555++;
vol_g1 = 0;
amt_g1 = 0;
rate_g1 = 0;
vol_g2 = 0;
amt_g2 = 0;
rate_g2 = 0;
vol_g3 = 0;
amt_g3 = 0;
rate_g3 = 0;
vol_g4 = 0;
amt_g4 = 0;
rate_g4 = 0;
vol_g5 = 0;
amt_g5 = 0;
rate_g5 = 0;
vol_g6 = 0;
amt_g6 = 0;
rate_g6 = 0;
}
else
{
grdViewOrders.Controls[0].Controls.AddAt(e.Row.RowIndex, row);
vol_g1 = 0;
amt_g1 = 0;
rate_g1 = 0;
vol_g2 = 0;
amt_g2 = 0;
rate_g2 = 0;
vol_g3 = 0;
amt_g3 = 0;
rate_g3 = 0;
vol_g4 = 0;
amt_g4 = 0;
rate_g4 = 0;
vol_g5 = 0;
amt_g5 = 0;
rate_g5 = 0;
vol_g6 = 0;
amt_g6 = 0;
rate_g6 = 0;
}
intSubTotalIndex++;
#endregion
#region Getting Next Group Header Details
if (DataBinder.Eval(e.Row.DataItem, "categ") != null)
// Once each group completed, getting the first column text of next group.
strGroupHeaderText = DataBinder.Eval(e.Row.DataItem, "categ").ToString();
#endregion
#region Reseting the Sub Total Variables
dblSubTotalUnitPrice = 0;
dblSubTotalQuantity = 0;
dblSubTotalDiscount = 0;
dblSubTotalAmount = 0;
#endregion
}
if (IsGrandTotalRowNeedtoAdd)
{
#region Grand Total Row
GridView grdViewOrders = (GridView)sender;
// Creating a Row
GridViewRow row = new GridViewRow(0, 0, DataControlRowType.DataRow, DataControlRowState.Insert);
//Adding Total Cell
TableCell cell = new TableCell();
cell.Text = "Grand Total";
cell.HorizontalAlign = HorizontalAlign.Right;
cell.ColumnSpan = 1;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Unit Price Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", gvol_g1);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Quantity Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", gamt_g1);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Discount Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", grate_g1);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Unit Price Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", gvol_g2);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Quantity Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", gamt_g2);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Discount Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", grate_g2);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Unit Price Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", gvol_g3);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Quantity Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", gamt_g3);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Discount Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", grate_g3);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Unit Price Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", gvol_g4);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Quantity Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", gamt_g4);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Discount Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", grate_g4);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Unit Price Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", gvol_g5);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Quantity Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", gamt_g5);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Discount Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", grate_g5);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Unit Price Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", gvol_g6);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Quantity Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", gamt_g6);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding Discount Column
cell = new TableCell();
cell.Text = string.Format("{0:0.000}", grate_g6);
cell.HorizontalAlign = HorizontalAlign.Center;
cell.CssClass = "GrandTotalRowStyle";
row.Cells.Add(cell);
//Adding the Row at the RowIndex position in the Grid
grdViewOrders.Controls[0].Controls.AddAt(e.Row.RowIndex, row);
count555 = 0;
#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
string exp = FilterJobs.SelectedValue;
string status = FilterStatus.SelectedValue;
SqlCommand query;
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString);
if (exp == "none")
{
if (status == "none")
{
query = new SqlCommand("Select jID, position as Position, openings as Openings, status as Status, experience as 'Applier Type', CAST(createdOn as VARCHAR(10)) as 'Started From' from [Job] where employerHREmail=@email");
query.Parameters.AddWithValue("email", Util.GetEmail(Request));
}
else
{
query = new SqlCommand("Select jID, position as Position, openings as Openings, status as Status, experience as 'Applier Type', CAST(createdOn as VARCHAR(10)) as 'Started From' from [Job] where status=@status and employerHREmail=@email");
query.Parameters.AddWithValue("status", status);
query.Parameters.AddWithValue("email", Util.GetEmail(Request));
}
}
else
{
if (status == "none")
{
query = new SqlCommand("Select jID, position as Position, openings as Openings, status as Status, experience as 'Applier Type', CAST(createdOn as VARCHAR(10)) as 'Started From' from [Job] where experience=@exp and employerHREmail=@email");
query.Parameters.AddWithValue("email", Util.GetEmail(Request));
query.Parameters.AddWithValue("exp", exp);
}
else
{
query = new SqlCommand("Select jID, position as Position, openings as Openings, status as Status, experience as 'Applier Type', CAST(createdOn as VARCHAR(10)) as 'Started From' from [Job] where status=@status and experience=@exp and employerHREmail=@email");
query.Parameters.AddWithValue("email", Util.GetEmail(Request));
query.Parameters.AddWithValue("status", status);
query.Parameters.AddWithValue("exp", exp);
}
}
connection.Open();
query.Connection = connection;
SqlDataAdapter adapter = new SqlDataAdapter(query);
DataTable datatable = new DataTable();
adapter.Fill(datatable);
DataTable tempTable = new DataTable();
tempTable = datatable.Copy();
datatable.Columns.RemoveAt(0);
JobTable.Rows.Clear();
TableHeaderCell[] ExtraCells = new TableHeaderCell[1];
TableHeaderCell viewCell = new TableHeaderCell();
viewCell.Text = "View";
viewCell.Scope = TableHeaderScope.Column;
ExtraCells[0] = viewCell;
Util.AddTableHeaders(JobTable, datatable, ExtraCells);
for (int i = 0; i < datatable.Rows.Count; i++)
{
DataRow row = datatable.Rows[i];
TableRow tableRow = new TableRow();
tableRow.CssClass = "table-row";
foreach (DataColumn col in datatable.Columns)
{
if (col.ColumnName != "jID")
{
TableCell tempcell = new TableCell();
tempcell.Text = row[col].ToString();
tableRow.Cells.Add(tempcell);
}
}
HyperLink link = new HyperLink();
link.Text = "View Details";
string temp = ConfigurationManager.AppSettings["domain"] + "HRViewJobPosting.aspx?id=" + HttpUtility.UrlEncode(tempTable.Rows[i]["jID"].ToString());
link.NavigateUrl = temp;
link.CssClass = "btn btn-primary";
TableCell cell = new TableCell();
cell.Controls.Add(link);
cell.CssClass = "no-search";
tableRow.Cells.Add(cell);
JobTable.Rows.Add(tableRow);
}
}
