protected override void LoadControls()
{
// Outer master Page
Outer_CP = (ContentPlaceHolder)_page.Form.FindControl("ContentPlaceHolder1");
// Inner Master Page
Inner_CP = (ContentPlaceHolder)Outer_CP.FindControl("ContentPlaceHolder1_Menu");
}
private void QueryList()
{
Database db = new Database();
try {
db.DBConnect();
str_hidInsertKey = MIPUtil.getFILE_INDEX_SEQ(db.getOcnn()).ToString();
} catch (Exception ex) {
throw ex;
} finally {
db.getOcnn().Close();
db.DBDisconnect();
}
if (oListView == null)
{
ContentPlaceHolder MySecondContent = (ContentPlaceHolder)this.Master.FindControl("ContentPlaceHolder1");
oListView = MySecondContent.FindControl("oListView") as ASP.dmscontrol_olistview_ascx;
//StrSearch = MySecondContent.FindControl("StrSearch") as System.Web.UI.HtmlControls.HtmlInputText;
}
if (oListView != null)
{
//加入欄位Start
oListView.AddCol("表單類別", "d_note", "CENTER", "auto");
oListView.AddCol("表單名稱", "cont", "LEFT", "40%");
oListView.AddCol("最後更新日期", " aldate", "CENTER", "auto");
oListView.AddCol("排序", " Corder", "CENTER", "auto");
oListView.AddCol("狀態", "cstatus", "CENTER", "auto");
//加入欄位End
//設定Key值欄位
oListView.DataKeyNames = "HAPPY_ID"; //Key以,隔開
////設定是否顯示CheckBox(預設是true);
////BosomServiceList.IsUseCheckBox = false;
StringBuilder sbSQL = new StringBuilder();
//設定SQL
sbSQL.Append(@"SELECT
a.HAPPY_ID
, (CASE WHEN a.CSTATUS = 1 THEN '停用' WHEN a.CSTATUS = 0 THEN '啟用' ELSE '未定義'END) cstatus
,a.Corder
,b.CNAME as b_note
,c.CNAME as c_note
,d.CNAME as d_note
,d.CNOTE as Cnote
,(CASE WHEN a.FILE_KIND = 0 THEN '標題：'+a.TITLE+' 檔名：'+ a.F_NAME WHEN a.FILE_KIND = 1 THEN '標題：'+ a.TITLE +' 網址：'+ a.URL ELSE '尋寶圖 URL：' +a.url END) cont
,a.LDATE as aldate
,a.LUSER
,(CASE WHEN a.ISTESTER = 1 THEN '否' WHEN a.ISTESTER = 0 THEN '是' ELSE '未定義' END) as ISTESTER
FROM MIP_HAPPY a, MIP_CODES b ,MIP_CODES c, MIP_CODES D
where
b.CKEY = a.CKEY1
and c.CKEY = a.CKEY2
and D.CKEY = a.CKEY3
and a.CKEY2 != 'B2020'
and d.Cnote = '0' ");
if (!string.IsNullOrEmpty(MDS.Utility.NUtility.trimBad(Request.QueryString["_dlType"])))
{
if (MDS.Utility.NUtility.trimBad(Request.QueryString["_dlType"]) != "請選擇")
{
str_dlType = MDS.Utility.NUtility.trimBad(Request.QueryString["_dlType"]);
string[] str_dlTypes = str_dlType.Split(new String[] { "-" }, StringSplitOptions.RemoveEmptyEntries);
//sbSQL.Append(" and b.CNAME=@b_note ");
//oListView.putQueryParameter("b_note", str_dlTypes[0]);
//sbSQL.Append(" and c.CNAME=@c_note ");
//oListView.putQueryParameter("Cnote", str_dlTypes[1]);
if (str_dlTypes.Length == 2)
{
sbSQL.Append(" and d.CNAME =@dCNAME ");
oListView.putQueryParameter("dCNAME", str_dlTypes[0]);
_dlType.SelectedValue = (MDS.Utility.NUtility.trimBad(str_dlTypes[1]));
}
}
}
if (!string.IsNullOrEmpty(MDS.Utility.NUtility.trimBad(Request.QueryString["_txtSrch"])))
{
str_txtSrch = MDS.Utility.NUtility.trimBad(Request.QueryString["_txtSrch"]);
sbSQL.Append(" and ( a.TITLE like '%'+@txtSrch+'%' or a.F_NAME like '%'+@txtSrch+'%') ");
oListView.putQueryParameter("txtSrch", str_txtSrch);
}
if (!string.IsNullOrEmpty(Request.QueryString["_chkIC"]) && string.IsNullOrEmpty(Request.QueryString["_chkRM"]))
{
sbSQL.Append("and exists(select * from MIP_HAPPY_TARGET e where e.HAPPY_ID=a.HAPPY_ID and e.DTYPE=0 and e.DEPT_ID='IC') ");
oListView.putQueryParameter("DEPT_ID", Request.QueryString["_chkIC"]);
}
else if (!string.IsNullOrEmpty(Request.QueryString["_chkRM"]) && string.IsNullOrEmpty(Request.QueryString["_chkIC"]))
{
sbSQL.Append("and exists(select * from MIP_HAPPY_TARGET e where e.HAPPY_ID=a.HAPPY_ID and e.DTYPE=0 and e.DEPT_ID='RM') ");
oListView.putQueryParameter("DEPT_ID", Request.QueryString["_chkRM"]);
}
sbSQL.Append(" order by a.CKEY1, a.CKEY2, a.CKEY3, a.CORDER, a.LDATE ");
//sbSQL.Append(" ORDER BY a.LDATA DESC,a.VDATE DESC ");
//取得SQL;
oListView.SelectString = sbSQL.ToString();
oListView.prepareStatement();
string showSql = sbSQL.ToString();
Debug.Write(showSql);
//設定每筆資料按下去的Javascript function
oListView.OnClickExecFunc = "DoEdt()";
//設定每頁筆數
oListView.PageSize = 26;
//接來自Request的排序欄位、排序方向、目前頁數
ListViewSortKey = Request.Params["ListViewSortKey"];
ListViewSortDirection = Request.Params["ListViewSortDirection"];
PageNo = Request.Params["PageNo"];
//設定排序欄位及方向
if (!string.IsNullOrEmpty(ListViewSortKey) && !string.IsNullOrEmpty(ListViewSortDirection))
{
oListView.ListViewSortKey = ListViewSortKey;
oListView.ListViewSortDirection = (SortDirection)Enum.Parse(typeof(SortDirection), ListViewSortDirection);
}
//設定目前頁數
if (!string.IsNullOrEmpty(PageNo))
{
oListView.PageNo = int.Parse(PageNo);
}
}
}
public void CreateReport()
{
LocalReport report = new LocalReport();
string mimeType, encoding, fileExtension;
string[] streams;
Warning[] warnings;
int year = Int32.Parse(Session["year"].ToString());
ReportDataSource rds = new ReportDataSource();
rds.Name = "SampleAnalize";
string username = User.Identity.Name;
UserInfos userinfos = UserInfos.getUserInfos(username);
int fermaid = GetFermaId(userinfos.UserCod);
if (fermaid != 0)
{
List <SampleAnalize> samples = SampleAnalize.GetSampleAnalize(fermaid, "", year);
if (samples.Count > 0)
{
string[] parIds = { "g", "p", "c", "l", "s", "h", "u", "n", "z" };
string[] chartLabelsName = { "Grasime (g/100g)", "Proteine (g/100g)", "Cazeina (g/100g)", "Lactoza (g/100g)", "SUN (g/100g)", "pH", "Uree (mg/dl)", "NCSx1000", "Cantitate lapte (l)" };
string[] chartTitles = { "Grasime", "Proteine", "Cazeina",
"Lactoza", "SUN", "Ph",
"Uree", "NCS", "Cantitate lapte" };
string[] um = { "g/100g", "g/100g", "g/100g", "g/100g", "g/100g", "pH", "mg/dl", "NCSx1000", "l" };
ContentPlaceHolder holder = (ContentPlaceHolder)Master.FindControl("MainContent");
for (int i = 0; i < parIds.Length; i++)
{
string endChar = parIds[i].ToUpper();
CheckBox chk = (CheckBox)holder.FindControl("chk" + endChar);
if (chk.Checked)
{
//set current param
foreach (SampleAnalize sample in samples)
{
switch (i)
{
case 0:
sample.Val = sample.Grasime; break;
case 1:
sample.Val = sample.Proteine; break;
case 2:
sample.Val = sample.Caseina; break;
case 3:
sample.Val = sample.Lactoza; break;
case 4:
sample.Val = sample.Solide; break;
case 5:
sample.Val = sample.Ph; break;
case 6:
sample.Val = sample.Urea; break;
case 7:
sample.Val = sample.Ncs; break;
case 8:
sample.Val = sample.Cantitate; break;
default: break;
}
sample.Val = Math.Round(sample.Val, 2);
}
// create samplescontrol from samples
// set reports datasource
rds.Value = samples;
report.DataSources.Clear();
report.DataSources.Add(rds);
//
ReportDataSource rdsc = new ReportDataSource();
rdsc.Name = "SampleAnalizeControl";
List <SampleAnalizeControl> samplescontrol = SampleAnalize.getSampleAnalizeControl(samples, year);
rdsc.Value = samplescontrol;
report.DataSources.Add(rdsc);
// detaliu
ReportDataSource rdscrot = new ReportDataSource();
rdscrot.Name = "SampleAnalizeCrotalia";
List <SampleAnalizeCrotalia> samplescrot = SampleAnalize.getSampleAnalizeCrotalia(fermaid, i, year);
rdscrot.Value = samplescrot;
report.DataSources.Add(rdscrot);
report.ReportPath = "ControlsSummary.rdlc";
string datatestare = "Data: " + DateTime.Now.ToString("dd/MM/yyyy");
// set reports parameters
string title = userinfos.NumeFerma + " - " + "Cod exploatatie " + userinfos.UserCod;
ReportParameter pCod = new ReportParameter("CodExpl", title);
ReportParameter pData = new ReportParameter("DataExec", datatestare);
ReportParameter pChartTitle = new ReportParameter("ChartTitle", chartTitles[i]);
ReportParameter pChartLabelsName = new ReportParameter("ChartLabelsName", chartLabelsName[i]);
ReportParameter pUm = new ReportParameter("Um", um[i]);
ReportParameter[] p = { pCod, pData, pChartTitle, pChartLabelsName, pUm };
report.SetParameters(p);
report.Refresh();
// write xls
string httppath = ConfigurationManager.AppSettings["httppath"];
//"/Downloads/";
string filepath = ConfigurationManager.AppSettings["filepath"];
//"D:\\portal\\Downloads\\";
string path_raport_http = "http://" + Request.ServerVariables.Get("HTTP_HOST") + "/" + httppath;
string fileid = chartTitles[i];
if (i == 8)
{
fileid = fileid.Substring(0, 4);
}
string raport_excel = "Grafic" + fileid + "_" + userinfos.UserCod + "_" + (DateTime.Now).ToString("ddMMyyyy") + ".xls";
string excel_file = filepath + raport_excel;
string excel_link = path_raport_http + raport_excel;
byte[] xls_content = report.Render("EXCEL", deviceInfoXls, out mimeType, out encoding, out fileExtension, out streams, out warnings);
File.WriteAllBytes(excel_file, xls_content);
//rename sheets
using (StreamReader input = new StreamReader(excel_file))
{
HSSFWorkbook workbook = new HSSFWorkbook(new POIFSFileSystem(input.BaseStream));
if (workbook != null)
{
workbook.SetSheetName(0, "Grafic");
workbook.SetSheetName(1, "Detaliu date");
WriteExcel(excel_file, workbook);
}
}
//
// HyperLink hyper = (HyperLink)holder.FindControl("xlslink" + parIds[i]);
// hyper.Visible = true;
//hyper.NavigateUrl = excel_link;
//hyper.Text = raport_excel;
ErrorMessage.Text = "";
} //checked
} //for
} //samplecount >0
} //fermaid >0
else
{
// ErrorMessage.Text = "Nu exista date pentru codul "+ userinfos.UserCod;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//btnAcYr.Attributes.Add("onclick", "return callvaliadteAcademic();");
user = (clsUser)Session["User"];
if (user != null && user.Exist)
{
sUser = user.User_ID;
}
else
{
Response.Redirect(Classes.clsGetSettings.SitePath.ToString() + "Logout.aspx");
}
if (user.UserTypeCode == "2")
{
instIDs = user.UserReferenceID;
hidInstID.Value = instIDs.ToString();
//divAcademicYr.Style.Add("display", "block");
divWaitMsg.Style.Add("display", "none");
}
if (IsPostBack)
{
flag = 1;
}
if (!IsPostBack)
{
if (PreviousPage != null)
{
ContentPlaceHolder Cntp = (ContentPlaceHolder)Page.Master.FindControl("ContentPlaceHolder1");
if (((HtmlInputHidden)Cntp.FindControl("hidInstID")).Value != null || ((HtmlInputHidden)Cntp.FindControl("hidInstID")).Value != "")
{
hidInstID.Value = ((HtmlInputHidden)Cntp.FindControl("hidInstID")).Value;
}
}
instIDs = "";
//DataTable dt = clsCollegeAdmissionReports.GetAcademicYear();
//Common.fillDropDown(ddlAcademicYr, dt, "", "Year", "pk_AcademicYear_ID", "--- Select ---");
//ddlAcademicYr.SelectedIndex = 0;
Session.Remove("dtdata");
hidUniID.Value = Classes.clsGetSettings.UniversityID.ToString();
}
ContentPlaceHolder Cntph = (ContentPlaceHolder)Page.Master.FindControl("ContentPlaceHolder1");
hid_AcademicYear.Value = ((DropDownList)YCMOU.FindControl("ddlAcadYear")).SelectedItem.Text;
hid_fk_AcademicYr_ID.Value = ((DropDownList)YCMOU.FindControl("ddlAcadYear")).SelectedValue;
YCMOU.IsInstituteDisplay = false;
YCMOU.IsFacultyDisplay = false;
YCMOU.IsCourseDisply = false;
YCMOU.IsCoursePartDisply = false;
YCMOU.IsCourseTermDisply = false;
YCMOU.IsBranchDisply = false;
YCMOU.IsReportUserAndDateDisplay = false;
YCMOU.isMISRpt.Value = "Yes";
YCMOU.OnProceedClick += btnAcYr_Click;
}
protected void Page_Load(object sender, System.EventArgs e)
{
clsCache.NoCache();
// Put user code to initialize the page here
if (!IsPostBack)
{
HtmlInputHidden[] hid = new HtmlInputHidden[22];
hid[0] = hidInstID;
hid[1] = hidUniID;
hid[2] = hidElgFormNo;
hid[3] = hidpkFacID;
hid[4] = hidpkYear;
hid[5] = hidpkStudentID;
hid[6] = hidpkCrID;
hid[7] = hidpkMoLrnID;
hid[8] = hidpkPtrnID;
hid[9] = hidpkBrnID;
hid[10] = hidpkCrPrDetailsID;
hid[11] = hidPRN;
hid[12] = hidIsBlank;
hid[13] = hidAcademicYr;
hid[14] = hid_fk_AcademicYr_ID;
hid[15] = hidAcademicYrText;
hid[16] = hidFacName;
hid[17] = hidCrName;
hid[18] = hidMOLName;
hid[19] = hidPattern;
hid[20] = hidBrName;
hid[21] = hidSearchType;
Common.setHiddenVariables(ref hid);
}
if (hidInstID.Value != "" && hidInstID.Value != null)
{
// hidInstID.Value = Request.QueryString["InstituteID"].ToString().Trim();
lblPageHead.Text = "Resolve Pending Eligibility";
lblSubHeader.Text = " for " + InstRep.InstituteName(hidUniID.Value, hidInstID.Value);
//lblInstitute.Text = " for " + clsInstitute.InstituteName(hidUniID.Value, hidInstID.Value);
}
rbEligible.Attributes.Add("onclick", "fnDisplayDiv();");
rbProvisional.Attributes.Add("onclick", "fnDisplayDiv();");
rbDefaulter.Attributes.Add("onclick", "fnDisplayDiv();");
rbPending.Attributes.Add("onclick", "fnDisplayDiv();");
btnSubmit.Attributes.Add("onclick", "return fnConfirm();");
userob = (clsUser)Session["User"];
userid = userob.User_ID.ToString();
if (Request.QueryString["Search"] == "Simple")
{
btnGoTo.Text = "Go To Search";
}
else // Search == "Adv"
{
btnGoTo.Text = "Go To Student List";
}
if (!IsPostBack)
{
//ELGV2_ResolvePending_reg_Students__1 ob = (ELGV2_ResolvePending_reg_Students__1)System.Web.HttpContext.Current.Handler;
//WebCtrl.StudentAdvanceSearchForConfigure_reg_Students tempHidden = (WebCtrl.StudentAdvanceSearchForConfigure_reg_Students)ob.FindControl("StudentAdvanceSeachForConfigure1");
ContentPlaceHolder Cntph = (ContentPlaceHolder)Page.PreviousPage.Master.FindControl("ContentPlaceHolder1");
WebCtrl.StudentAdvanceSearchForConfigure_reg_Students tempHidden = (WebCtrl.StudentAdvanceSearchForConfigure_reg_Students)Cntph.FindControl("StudentAdvanceSeachForConfigure1");
if (Request.QueryString["Search"] == "Adv")
{
hidElgFormNo.Value = ((HtmlInputHidden)tempHidden.FindControl("hidElgFormNo")).Value;
hidpkYear.Value = ((HtmlInputHidden)tempHidden.FindControl("hidpkYear")).Value;
hidpkStudentID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidpkStudentID")).Value;
hidpkFacID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidFacID")).Value;
hidpkCrID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidCrID")).Value;
hidpkMoLrnID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidMoLrnID")).Value;
hidpkPtrnID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidPtrnID")).Value;
hidpkBrnID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidBrnID")).Value;
hidpkCrPrDetailsID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidCrPrDetailsID")).Value;
hid_fk_AcademicYr_ID.Value = ((HtmlInputHidden)tempHidden.FindControl("hid_fk_AcademicYr_ID")).Value;
hidAcademicYrText.Value = ((HtmlInputHidden)tempHidden.FindControl("hidAcademicYrText")).Value;
hidInstID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidInstID")).Value;
hidFacName.Value = ((HtmlInputHidden)tempHidden.FindControl("hidFacName")).Value;
hidCrName.Value = ((HtmlInputHidden)tempHidden.FindControl("hidCrName")).Value;
hidMOLName.Value = ((HtmlInputHidden)tempHidden.FindControl("hidMOLName")).Value;
hidPattern.Value = ((HtmlInputHidden)tempHidden.FindControl("hidPattern")).Value;
hidBrName.Value = ((HtmlInputHidden)tempHidden.FindControl("hidBrName")).Value;
hidInstID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidInstID")).Value;
hidAcYrName.Value = ((HtmlInputHidden)tempHidden.FindControl("hidAcYrName")).Value;
hidSearchType.Value = ((HtmlInputHidden)tempHidden.FindControl("hidSearchType")).Value;
hidBranchName.Value = ((HtmlInputHidden)tempHidden.FindControl("hidBranchName")).Value;
}
if (Request.QueryString["Search"] == "Simple")
{
hidElgFormNo.Value = ((HtmlInputHidden)tempHidden.FindControl("hidElgFormNo")).Value;
hidPRN.Value = ((HtmlInputHidden)tempHidden.FindControl("hidPRN")).Value;
hidpkYear.Value = ((HtmlInputHidden)tempHidden.FindControl("hidpkYear")).Value;
hidpkStudentID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidpkStudentID")).Value;
hidpkFacID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidFacID")).Value;
hidpkCrID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidCrID")).Value;
hidpkMoLrnID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidMoLrnID")).Value;
hidpkPtrnID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidPtrnID")).Value;
hidpkBrnID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidBrnID")).Value;
hidpkCrPrDetailsID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidCrPrDetailsID")).Value;
hidIsBlank.Value = ((HtmlInputHidden)tempHidden.FindControl("hidIsBlank")).Value;
hidInstID.Value = ((HtmlInputHidden)tempHidden.FindControl("hidInstID")).Value;
hid_fk_AcademicYr_ID.Value = ((HtmlInputHidden)tempHidden.FindControl("hid_fk_AcademicYr_ID")).Value;
}
hidElgFlag.Value = "NotAssigned";
FetchStudentDetails();
divPRN.Style.Add("Display", "none");
GoToDataBase = 1;
Session["GoToDataBase"] = GoToDataBase;
}
else if (IsPostBack)
{
GoToDataBase = Convert.ToInt32(Session["GoToDataBase"].ToString());
}
}