protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["Person_Id"].ToString() == "" || Session["Person_Id"].ToString() == null)
{
Response.Redirect("LoginForm.aspx", false);
}
int Count = 0;
DataTable dt = CGeneralFunction.filldata("select count(*) from cdb..TRANSACTION_DETAILS where Attr1='1' and Forwarded_To='" + Session["Person_Id"].ToString() + "'");
foreach (DataRow ro in dt.Rows)
{
Count = int.Parse(ro[0].ToString());
}
if (Count > 0)
{
//imgRequest.ImageUrl = "~/Icons/notifcation-message.png";
//lblCount.Visible = true;
//div1.Visible = true;
//lblCount.Text = Count.ToString();
}
else
{
//imgRequest.ImageUrl = "~/Icons/notification-on.png";
//lblCount.Visible = false;
//div1.Visible = false;
}
}
catch
{
Response.Redirect("LoginForm.aspx", false);
}
}
private void populatebatchs()
{
if (!isalloweddatedate() && Session["RoleId"].ToString() != "9")
{
Response.Write("<script LANGUAGE='JavaScript' >alert('This facility is blocked by administration, Contact Admin!!.')</script>");
return;
}
if (Session["RoleId"] != null)
{
DataTable dt = new DataTable();
if (Session["RoleId"].ToString() == "1" || Session["RoleId"].ToString() == "9")
{
dt = CGeneralFunction.filldataattendance("select ClassSectionId as class_id,c.Code as ClassName,Sc.code as DivisionName,Isnull(f.FirstName,'')+' '+Isnull(f.MiddleName,'')+' '+Isnull(f.LastName,'') as ClassRoom,COUNT(*) as TotalStudent, case [dbo].[CheckAttendanceStatuswithdate](s.ClassSectionId,'" + txtDate.Text.Trim() + "') when 0 then '../Icons/Red.png' else '../Icons/Green.png' end as AttStatus from tblStudent as s inner join tblClassSection as cs on cs.Id=s.ClassSectionId inner join tblClassMaster as c on c.Id=cs.ClassId inner join tblSection as sc on sc.Id=cs.SectionId inner join tblFaculty as f on f.Id=cs.TeacherId where S.Attr2 ='A' and S.Status=1 and CS.Status =1 group by c.Code,Sc.code,ClassSectionId,Isnull(f.FirstName,'')+' '+Isnull(f.MiddleName,'')+' '+Isnull(f.LastName,'') order by AttStatus");
}
else if (Session["RoleId"].ToString() == "7")
{
dt = CGeneralFunction.filldataattendance("select ClassSectionId as class_id,c.Code as ClassName,Sc.code as DivisionName,CD.Cdd_Description as ClassRoom,COUNT(*) as TotalStudent, case [dbo].[CheckAttendanceStatuswithdate](s.ClassSectionId,'" + txtDate.Text.Trim() + "') when 0 then '../Icons/Red.png' else '../Icons/Green.png' end as AttStatus from tblStudent as s inner join tblClassSection as cs on cs.Id=s.ClassSectionId inner join tblClassMaster as c on c.Id=cs.ClassId inner join tblSection as sc on sc.Id=cs.SectionId inner join tblFaculty as f on f.Id=cs.TeacherId inner join AdminExam ..tbl_Batch B on B.Batch_Id =C.Attr1 inner join AdminExam ..Course_def_Master CD on CD.Cdd_ID =B.Cdd_id where S.Attr2 ='A' and S.Status=1 and TeacherId='" + Session["EMPID"].ToString() + "' and CS.Status =1 group by c.Code,Sc.code,ClassSectionId,Isnull(f.FirstName,'')+' '+Isnull(f.MiddleName,'')+' '+Isnull(f.LastName,''),CD.Cdd_Description order by AttStatus");
}
else if (Session["RoleId"].ToString() == "3" || Session["RoleId"].ToString() == "4" || Session["RoleId"].ToString() == "5" || Session["RoleId"].ToString() == "6")
{
dt = CGeneralFunction.filldataattendance("select ClassSectionId as class_id,c.Code as ClassName,Sc.code as DivisionName,Isnull(f.FirstName,'')+' '+Isnull(f.MiddleName,'')+' '+Isnull(f.LastName,'') as ClassRoom,COUNT(*) as TotalStudent, case [dbo].[CheckAttendanceStatuswithdate](s.ClassSectionId,'" + txtDate.Text.Trim() + "') when 0 then '../Icons/Red.png' else '../Icons/Green.png' end as AttStatus from tblStudent as s inner join tblClassSection as cs on cs.Id=s.ClassSectionId inner join tblClassMaster as c on c.Id=cs.ClassId inner join tblSection as sc on sc.Id=cs.SectionId inner join tblFaculty as f on f.Id=cs.TeacherId where cs.Id in (select ClassSectionId from tblDesignationAllocation where S.Attr2 ='A' and S.Status=1 and FacultyId='" + Session["EMPID"].ToString() + "') and CS.Status =1 group by c.Code,Sc.code,ClassSectionId,Isnull(f.FirstName,'')+' '+Isnull(f.MiddleName,'')+' '+Isnull(f.LastName,'') order by AttStatus");
}
if (dt.Rows.Count != 0)
{
gvStayBackReason.DataSource = dt;
}
else
{
gvStayBackReason.DataSource = null;
}
gvStayBackReason.DataBind();
pnlMyClass.Visible = true;
}
}
protected void ddlFaculty_SelectedIndexChanged(object sender, EventArgs e)
{
ddlClass.DataSource = CGeneralFunction.filldataattendance("select 0 as SN,0 as Id,'<Select>' as Description union all select Distinct 1 as SN,CS.Id ,CM.Description from tblStudent S inner join tblClassSection CS on S.ClasssectionId = CS.Id inner join tblClassMaster CM on CS.ClassId =CM.Id where CS.Status =1 and S.Status = 1 and CS.TeacherId =" + ddlFaculty.SelectedValue + " and CS.AcademicYearId = " + ddlSem.SelectedValue);
ddlClass.DataTextField = "Description";
ddlClass.DataValueField = "Id";
ddlClass.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//if (Session["Person_Id"].ToString() == "" || Session["Person_Id"].ToString() == null)
// Response.Redirect("../Pages/LoginForm.aspx", false);
//if (Session["Person_Id"].ToString() != "83")
//{
// Response.Redirect("../Pages/LoginForm.aspx", false);
//}
int Count = 0;
//DataTable dt = CGeneralFunction.filldata("select count(*) from cdb..TRANSACTION_DETAILS where Attr1='1' and Forwarded_To='" + Session["Person_Id"].ToString() + "'");
//foreach (DataRow ro in dt.Rows)
//{
// Count = int.Parse(ro[0].ToString());
//}
if (Count > 0)
{
//imgRequest.ImageUrl = "~/Icons/notifcation-message.png";
//lblCount.Visible = true;
//div1.Visible = true;
//lblCount.Text = Count.ToString();
LblNotification.Text = Count.ToString();
}
else
{
//imgRequest.ImageUrl = "~/Icons/notification-on.png";
//lblCount.Visible = false;
//div1.Visible = false;
}
// LblPageName.Text = Session["PageName"].ToString();
StringBuilder str = new StringBuilder();
DataTable dtt = CGeneralFunction.filldata("exec SP_Menu");
for (int i = 0; i <= dtt.Rows.Count - 1; i++)
{
str.Append(dtt.Rows[i][0].ToString());
}
ltrlMenu.Text = str.ToString();
}
catch (Exception Ex)
{
// throw Ex;
Response.Redirect("../Pages/LoginForm.aspx", false);
}
}
private void ToolStripMenuItemRegister_Click(object sender, EventArgs e)
{
FormRegister dlg = new FormRegister();
string strMac = CGeneralFunction.GetMACaddressOne();
SimpleScrypt SScrypt = new SimpleScrypt();
dlg.CodeNO = SScrypt.Encrypt(strMac);
if (dlg.ShowDialog() == DialogResult.OK)
{
//实现注册代码，有待修改
MessageBox.Show("程序必须重新启动！");
CAppOption.RegKeyNO = dlg.KeyNO;
CAppOption.SaveData();
CAppOption.SaveKeyNO();
Application.Exit();
}
}
protected void gvStayBackReason_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (!isalloweddatedate() && Session["RoleId"].ToString() != "9")
{
Response.Write("<script LANGUAGE='JavaScript' >alert('This facility is blocked by administration, Contact Admin!!.')</script>");
return;
}
try
{
if (e.CommandName == "View")
{
DataTable dt;
string csId = Convert.ToString(e.CommandArgument);
dt = CGeneralFunction.filldata("Usp_BatchwiseStatus " + csId);
if (dt.Rows.Count != 0)
{
gridView.DataSource = dt;
}
else
{
gridView.DataSource = null;
}
gridView.DataBind();
ME1.Show();
}
else
{
int ClassSectionId = Convert.ToInt32(e.CommandArgument.ToString());
DataTable dt = CGeneralFunction.filldataattendance("select ClassId,SectionId from tblClassSection where Id='" + ClassSectionId + "'");
Session["Class_Id"] = dt.Rows[0]["ClassId"].ToString();
Session["Div_Id"] = dt.Rows[0]["SectionId"].ToString();
Session["ClassSectionId"] = ClassSectionId;
Response.Redirect("Attendance.aspx?CId=" + ClassSectionId + "&&DDate=" + txtDate.Text.Trim(), false);
}
}
catch
{
}
}
/// <summary>
/// 加载数据
/// </summary>
public static void LoadData()
{
string szOptionFile;
szOptionFile = System.Windows.Forms.Application.StartupPath + "\\Option.dat";
if (System.IO.File.Exists(szOptionFile))
{
System.Text.StringBuilder szValue = new System.Text.StringBuilder("", 256);
int iRet;
iRet = PlatformInvokeKernel32.GetPrivateProfileString("App", "AppStyle", iAppStyle.ToString(), szValue, 256, szOptionFile);
try
{
iAppStyle = Convert.ToInt32(szValue.ToString());
}
catch
{
}
iRet = PlatformInvokeKernel32.GetPrivateProfileString("Windows", "Style", iFormStyle.ToString(), szValue, 256, szOptionFile);
try
{
iFormStyle = Convert.ToInt32(szValue.ToString());
}
catch
{
}
iRet = PlatformInvokeKernel32.GetPrivateProfileString("Windows", "SortStyle", iSortStyle.ToString(), szValue, 256, szOptionFile);
try
{
iSortStyle = Convert.ToInt32(szValue.ToString());
}
catch
{
}
iRet = PlatformInvokeKernel32.GetPrivateProfileString("Windows", "NumberFormat", NumberFormat, szValue, 256, szOptionFile);
NumberFormat = szValue.ToString();
if (NumberFormat == "")
{
NumberFormat = "0.00";
}
iRet = PlatformInvokeKernel32.GetPrivateProfileString("Windows", "MoneyFormat", MoneyFormat, szValue, 256, szOptionFile);
MoneyFormat = szValue.ToString();
if (MoneyFormat == "")
{
MoneyFormat = "0.00";
}
iRet = PlatformInvokeKernel32.GetPrivateProfileString("Windows", "PageRowCount", PageRowCount.ToString(), szValue, 256, szOptionFile);
try
{
PageRowCount = Convert.ToInt32(szValue.ToString());
if (PageRowCount < 10)
{
PageRowCount = 22;
}
}
catch
{
PageRowCount = 22;
}
iRet = PlatformInvokeKernel32.GetPrivateProfileString("App", "Idiograph", "", szValue, 256, szOptionFile);
Idiograph = szValue.ToString();
//注册码
iRet = PlatformInvokeKernel32.GetPrivateProfileString("Register", "Code", "", szValue, 256, szOptionFile);
RegisterCode = szValue.ToString();
iRet = PlatformInvokeKernel32.GetPrivateProfileString("Register", "User", "", szValue, 256, szOptionFile);
RegisterUser = szValue.ToString();
string[] MacList = CGeneralFunction.GetMac();
ChefMonitor.CGlobalInstance.Instance.FileLogger.WriteLog(YyLogger.LogSeverity.info, "配置加载", string.Format("Mac:{0}", MacList[0]));
if (MacList.Length > 0)
{
SimpleScrypt SScrypt = new SimpleScrypt();
if (SScrypt.Encrypt(MacList[0]) == RegisterCode)
{
bRegister = true;
}
if (!string.IsNullOrEmpty(RegisterUser) && SScrypt.Encrypt(RegisterUser) == RegisterCode)
{
bRegister = true;
}
#if DEBUG
if (bRegister == false)
{
ChefMonitor.CGlobalInstance.Instance.FileLogger.WriteLog(YyLogger.LogSeverity.info, "配置加载", string.Format("RegisterCode:{0}", SScrypt.Encrypt(MacList[0])));
ChefMonitor.CGlobalInstance.Instance.FileLogger.WriteLog(YyLogger.LogSeverity.info, "配置加载", string.Format("RegisterCode:{0}", SScrypt.Encrypt(RegisterUser)));
}
#endif
}
}
WindowStyleMan.LoadData();
RegistryKey oRegSoft;
oRegSoft = Registry.LocalMachine.OpenSubKey("SOFTWARE", true);
if (oRegSoft == null)
{
//建立
oRegSoft = Registry.LocalMachine.CreateSubKey("SOFTWARE");
}
RegistryKey oRegTemp = oRegSoft.OpenSubKey(Application.ProductName, true);
if (oRegTemp == null)
{
oRegTemp = oRegSoft.CreateSubKey(Application.ProductName);
}
m_sUser = (string)oRegTemp.GetValue("User", "Admin");
m_sPwd = ""; //20090110修改，不再
//m_sPwd=Decrypt((string)oRegTemp.GetValue("Pwd",""));
m_sDbConnectString = CYyScrypt.Decrypt((string)oRegTemp.GetValue("DbConnect", CYyScrypt.Encrypt(m_sDbConnectString)));
m_bSavePwd = Convert.ToBoolean(oRegTemp.GetValue("SavePwd", true));
}
/// <summary>
/// 加载数据
/// </summary>
public static void LoadData()
{
string szOptionFile;
szOptionFile = System.Windows.Forms.Application.StartupPath + "\\Option.dat";
if (System.IO.File.Exists(szOptionFile))
{
System.Text.StringBuilder szValue = new System.Text.StringBuilder("", 256);
int iRet;
iRet = PlatformInvokeKernel32.GetPrivateProfileString("App", "AppStyle", iAppStyle.ToString(), szValue, 256, szOptionFile);
try
{
iAppStyle = Convert.ToInt32(szValue.ToString());
}
catch
{
}
iRet = PlatformInvokeKernel32.GetPrivateProfileString("Windows", "Style", iFormStyle.ToString(), szValue, 256, szOptionFile);
try
{
iFormStyle = Convert.ToInt32(szValue.ToString());
}
catch
{
}
iRet = PlatformInvokeKernel32.GetPrivateProfileString("Windows", "SortStyle", iSortStyle.ToString(), szValue, 256, szOptionFile);
try
{
iSortStyle = Convert.ToInt32(szValue.ToString());
}
catch
{
}
iRet = PlatformInvokeKernel32.GetPrivateProfileString("Windows", "NumberFormat", NumberFormat, szValue, 256, szOptionFile);
NumberFormat = szValue.ToString();
if (NumberFormat == "")
{
NumberFormat = "0.00";
}
iRet = PlatformInvokeKernel32.GetPrivateProfileString("Windows", "MoneyFormat", MoneyFormat, szValue, 256, szOptionFile);
MoneyFormat = szValue.ToString();
if (MoneyFormat == "")
{
MoneyFormat = "0.00";
}
iRet = PlatformInvokeKernel32.GetPrivateProfileString("Windows", "PageRowCount", PageRowCount.ToString(), szValue, 256, szOptionFile);
try
{
PageRowCount = Convert.ToInt32(szValue.ToString());
if (PageRowCount < 10)
{
PageRowCount = 22;
}
}
catch
{
PageRowCount = 22;
}
iRet = PlatformInvokeKernel32.GetPrivateProfileString("App", "Idiograph", "", szValue, 256, szOptionFile);
Idiograph = szValue.ToString();
//注册码
iRet = PlatformInvokeKernel32.GetPrivateProfileString("Register", "Code", "", szValue, 256, szOptionFile);
RegisterCode = szValue.ToString();
iRet = PlatformInvokeKernel32.GetPrivateProfileString("Register", "User", "", szValue, 256, szOptionFile);
RegisterUser = szValue.ToString();
string strMac = CGeneralFunction.GetMACaddressOne();
Restaurant.CGlobalInstance.Instance.FileLogger.WriteLog(YyLogger.LogSeverity.info, "配置加载", string.Format("Mac:{0}", strMac));
if (strMac.Length > 0)
{
SimpleScrypt SScrypt = new SimpleScrypt();
if (SScrypt.Encrypt(strMac) == RegisterCode)
{
bRegister = true;
}
if (!string.IsNullOrEmpty(RegisterUser) && SScrypt.Encrypt(RegisterUser) == RegisterCode)
{
bRegister = true;
}
#if DEBUG
if (bRegister == false)
{
Restaurant.CGlobalInstance.Instance.FileLogger.WriteLog(YyLogger.LogSeverity.info, "配置加载", string.Format("RegisterCode:{0}", SScrypt.Encrypt(strMac)));
Restaurant.CGlobalInstance.Instance.FileLogger.WriteLog(YyLogger.LogSeverity.info, "配置加载", string.Format("RegisterCode:{0}", SScrypt.Encrypt(RegisterUser)));
}
#endif
}
}
WindowStyleMan.LoadData();
RegistryKey oRegSoft;
oRegSoft = Registry.LocalMachine.OpenSubKey("SOFTWARE", true);
if (oRegSoft == null)
{
//建立
oRegSoft = Registry.LocalMachine.CreateSubKey("SOFTWARE");
}
RegistryKey oRegTemp = oRegSoft.OpenSubKey(Application.ProductName, true);
if (oRegTemp == null)
{
oRegTemp = oRegSoft.CreateSubKey(Application.ProductName);
}
m_sUser = (string)oRegTemp.GetValue("User", "Admin");
m_sPwd = ""; //20090110修改，不再
//m_sPwd=Decrypt((string)oRegTemp.GetValue("Pwd",""));
//Jet的开发已经停止了，所以没有64位的版本。
//Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\DB\Restaurant.mdb;Persist Security Info=False;Jet OLEDB:DataBase Password=legahero123
//Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\DB\Restaurant.accdb;Persist Security Info=False;Jet OLEDB:DataBase Password=legahero123
string strAcc = "";//CYyScrypt.Encrypt(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Restaurant.mdb;Persist Security Info=False;Jet OLEDB:DataBase Password=legahero123");
strAcc = "501D3F1847F9C54142AA6F0AF66D6F44C616C01EE400418CDAC8F89571A22E17D16E33A09E861EB9B253E258914D771FFDFDD75238B3085A49A885C62DFDF07D28F5DB62128B2D2D56D99B6571A27D9997C8EC446A5486366356281FBA2054D696DB7FA70E84BE91652FD7E333AA30A4DCEF7FE9D96538F2A43E3AA1777167209D4FE216F3A74373F152199CF089A987E707D7313E695522A798E4F5CAB316C1D1F72C51761BA18CA5BA726083D45D667DCA404A0CB8A5152BDCC50131A32A2BF554FCFF4FCE7AD9CC98DD954F54B177ED27D8D45E46078D704C8A83E3C4F0A8ED4E069B18936EB1998A7C72599628214665452AE7F5E217D98DD2674884";
#if TMPRELEASE
//单机版
m_sDbConnectString = CYyScrypt.Decrypt(strAcc);
#else
m_sDbConnectString = CYyScrypt.Decrypt((string)oRegTemp.GetValue("DbConnect", CYyScrypt.Encrypt(m_sDbConnectString)));
#endif
m_bSavePwd = Convert.ToBoolean(oRegTemp.GetValue("SavePwd", true));
}