protected void Page_Load(object sender, EventArgs e)
{
base.AllowHttpMethod("GET", "POST");
base.DisableTop(true);
base.BodyClass = "class='bodybg'";
user = AuthServer.GetLoginUser();
if (this.IsPostBack == false)
{
if (SystemCode.GetDict("RecordM_StudentRecord_VaccineCate").Count > 0)
{
tbAry = JsonConvert.SerializeObject(SystemCode.GetDict("RecordM_StudentRecord_VaccineCate"));
}
int nowYear = DateTime.Now.Year - 1911;
ddlYear.Items.Add(new ListItem(nowYear.ToString() + "年", nowYear.ToString()));
ddlYear.Items.Add(new ListItem((nowYear + 1).ToString() + "年", (nowYear + 1).ToString()));
//if (SystemElementarySchool.list.Count > 0)
//{
// ddlSchool.Items.Add(new ListItem("0", "請選擇學校名稱"));
// foreach(var item in SystemElementarySchool.list)
// {
// ddlSchool.Items.Add(new ListItem(item.ElementarySchoolID.ToString(), item.SchoolName));
// }
//}
if (SystemElementarySchool.list.Count > 0)
{
sAry = JsonConvert.SerializeObject(SystemElementarySchool.list);
}
}
}
/// <summary>
/// 根据ID获取系统参数表实体
/// </summary>
/// <param name="guid">主键ID</param>
/// <returns>返回系统参数表实体</returns>
public SystemCode GetItemById(Guid guid)
{
SystemCode tem = new SystemCode();
tem = Dal.Find <SystemCode>(SystemCode._.ID == guid);
return(tem);
}
public List <FunctionPower> GetPowers(int userAuthorizationID, SystemCode systemCode)
{
string sql = @"
Select FunctionPower.* from FunctionPower
Join RoleFunctionPower on RoleFunctionPower.FunctionPowerID=FunctionPower.ID
join [Role] on [Role].ID = RoleFunctionPower.RoleID
join UserPower on UserPower.RoleID = [Role].ID
join UserAuthorization on UserAuthorization.ID = UserPower.UserAuthorizationID
where UserAuthorization.ID=@UserAuthorizationID and FunctionPower.AppInfoID = @SystemCode
union
select FunctionPower.* from FunctionPower
join DepartmentFunctionPower on DepartmentFunctionPower.FunctionPowerID = FunctionPower.ID
join Department on Department.ID = DepartmentFunctionPower.DepartmentID
join [Role] on [Role].DepartmentID = Department.ID
join UserPower on UserPower.RoleID = [Role].ID
join UserAuthorization on UserAuthorization.ID = UserPower.UserAuthorizationID
where UserAuthorization.ID=@UserAuthorizationID and FunctionPower.AppInfoID = @SystemCode
";
return(_dbHelper.GetModelList <FunctionPower>(sql, new { UserAuthorizationID = userAuthorizationID, SystemCode = (int)systemCode },
new PagerParameter
{
PageIndex = 1,
PageSize = 99999999,
OrderBy = "ID"
}).Rows);
}
protected new void Page_Load(object sender, EventArgs e)
{
base.AllowHttpMethod("GET", "POST");
base.DisableTop(true);
user = AuthServer.GetLoginUser();
if (this.IsPostBack == false)
{
List <int> list = new List <int>()
{
1, 2, 3, 4, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24
};
var dict = SystemCode.GetDict("RecordM_StudentRecord_VaccineCate");
if (dict.Count > 0)
{
var query = dict.Where(item => list.Contains(item.EnumValue));
tbAry = JsonConvert.SerializeObject(query);
}
int nowYear = DateTime.Now.Year - 1911;
for (int i = 0; i < 5; i++)
{
ddlYear.Items.Add(new ListItem((nowYear - i).ToString() + "年", nowYear.ToString()));
}
if (SystemElementarySchool.list.Count > 0)
{
sAry = JsonConvert.SerializeObject(SystemElementarySchool.list.Where(item => item.OrgID == user.OrgID));
}
}
}
/// <summary>
/// 取得1.0协议的sn
/// </summary>
/// <param name="msg"></param>
/// <returns></returns>
public static string getSn(string msg)
{
if (msg.StartsWith("6969"))
{
return(""); //2.0协议返回空
}
string _CollectorCode;
string sbUnitID = "";
bool isNormal = false;
string tmpchar;
//将后面是00的抛弃
for (int i = 18; i >= 4; i--)
{
tmpchar = msg.Substring(i * 2, 2);
if (!isNormal && !tmpchar.Equals("00"))
{
isNormal = true;
}
if (isNormal)
{
sbUnitID = ASCII.Chr((int)SystemCode.HexNumberToDenary(tmpchar, false, 8, 'u')) + sbUnitID;
}
}
_CollectorCode = sbUnitID.ToString();
_CollectorCode = _CollectorCode.Replace("\0", "0");//临时处理非法测试数据
return(_CollectorCode);
}
public async Task <IActionResult> Edit(string id, [Bind("Category,Code,DisplayOrder,DisplayName,Description,CreateDatetime,CreateUserId,UpdateDatetime,UpdateUserId")] SystemCode systemCode)
{
if (id != systemCode.Category)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(systemCode);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SystemCodeExists(systemCode.Category))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(systemCode));
}
/// <summary>
/// 根据证书中的appendDetail和客户端配置的WcfClientInvokeAttribute -> SystemCode
/// 来解析出关联系统的服务连接
/// </summary>
/// <param name="code">客户端的配置System Code</param>
/// <param name="appendDetail">证书中的appendDetail信息以分号分隔</param>
/// <returns>关联系统的服务的信息</returns>
private static WcfCredentialInfo resolveSubSystemCredentialInfo(SystemCode code, string appendDetail, WcfCredentialInfo mainCredentialInfo)
{
if (!string.IsNullOrEmpty(appendDetail))
{
string[] subServices = appendDetail.Split(';');
if (subServices.Length > 0)
{
foreach (string subService in subServices)
{
string[] subServiceAttribute = subService.Split(',');
if (subServiceAttribute.Length > 0 && subServiceAttribute.Length == 5)
{
string systemCode = subServiceAttribute[0].Substring(
subServiceAttribute[0].IndexOf("CfgName=") + "CfgName=".Length);
if (string.Compare(code.ToString(), systemCode, true) == 0)
{
WcfCredentialInfo subCredetialInfo = MB.Util.MyReflection.Instance.FillModelObject <WcfCredentialInfo>(mainCredentialInfo);
string uri = subServiceAttribute[1].Substring("URL=".Length);
subCredetialInfo.EndpointFormatString = uri;
subCredetialInfo.BaseAddress = uri.Substring(0, uri.Length - "{0}.svc".Length - 1);
subCredetialInfo.Domain = subServiceAttribute[2].Substring("Domain=".Length);
subCredetialInfo.UserName = subServiceAttribute[3].Substring("LoginName=".Length);
subCredetialInfo.Password = subServiceAttribute[4].Substring("LoginPassword=".Length);
return(subCredetialInfo);
}
}
}
}
}
return(null);
}
/// <summary>
/// Creates a ImmunizationEvent object from a PHSA model.
/// </summary>
/// <param name="model">The immunization view object to convert.</param>
/// <returns>The newly created ImmunizationEvent object.</returns>
private static TargetDisease FromPHSAModel(SystemCode model)
{
return(new TargetDisease()
{
Code = model.Code,
Name = model.Display,
});
}
protected new void Page_Load(object sender, EventArgs e)
{
base.AllowHttpMethod("GET", "POST");
base.DisableTop(true);
ElementaryRecordID = GetNumber <int>("i");
if (ElementaryRecordID == 0)
{
IsValid = false;
string script = "<style>body{display:none;}</style><script>alert('資料取得失敗');history.go(-1);</script>";
Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false);
return;
}
user = AuthServer.GetLoginUser();
if (this.IsPostBack == false)
{
DataSet ds = MSDB.GetDataSet("ConnDB", "dbo.usp_RecordM_xGetElementaryRecordByID"
, new Dictionary <string, object>()
{
{ "@ElementaryRecordID", ElementaryRecordID }
});
ElementaryRecordVM VM = new ElementaryRecordVM();
EntityS.FillModel(VM, ds.Tables[0]);
List <ElementaryRecordDataVM> list = new List <ElementaryRecordDataVM>();
EntityS.FillModel(list, ds.Tables[1]);
for (int i = VM.AdmissionYear; i <= DateTime.Now.Year - 1911; i++)
{
ddlYear.Items.Add(new ListItem(i.ToString() + "年", i.ToString()));
}
var dict = SystemCode.GetDict("RecordM_StudentRecord_VaccineCate");
if (dict.Count > 0)
{
tbAry = JsonConvert.SerializeObject(dict);
}
if (list.Count > 0)
{
tbAry2 = JsonConvert.SerializeObject(list);
}
ddlST.SelectedValue = VM.StudentYear.ToString();
var slist = SystemElementarySchool.list.Where(item => item.OrgID == user.OrgID);
ddlSchool.Items.Add(new ListItem("請選擇學校名稱", "0"));
foreach (var item in slist)
{
ddlSchool.Items.Add(new ListItem(item.SchoolName, item.ElementarySchoolID.ToString()));
}
ddlSchool.SelectedValue = VM.ElementarySchoolID.ToString();
}
}
/// <summary>
/// 新增数据
/// </summary>
/// Author :Napoleon
/// Created :2015-06-06 02:02:41
public int InsertSystemCode(SystemCode model)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("insert into System_Code(Id,ParentId,CodeName,OrderBy) values(@Id,@ParentId,@CodeName,@OrderBy)");
int i = DbHelper.ExecuteSql(sql.ToString(), model);
return(i);
}
/// <summary>
/// 更新数据
/// </summary>
/// Author :Napoleon
/// Created :2015-06-06 02:02:41
public int UpdateSystemCode(SystemCode model)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("update System_Code set Id=@Id,ParentId=@ParentId,CodeName=@CodeName,OrderBy=@OrderBy where Id=@Id");
int i = DbHelper.ExecuteSql(sql.ToString(), model);
return(i);
}
public static void ServerSelect(ref DropDownList ddl, string SystemCateName)
{
List <SystemCodeVM> SystemCodeList = SystemCode.GetDict(SystemCateName);
foreach (SystemCodeVM sc in SystemCodeList)
{
ddl.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString()));
}
}
public static void ServerCheckBox(ref CheckBoxList cbl, string SystemCateName)
{
List <SystemCodeVM> SystemCodeList = SystemCode.GetDict(SystemCateName);
foreach (SystemCodeVM sc in SystemCodeList)
{
cbl.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString()));
}
}
/// <summary>
/// 取得当个信息地址的值，字符串表示
/// </summary>
/// <param name="valuestr"></param>
/// <param name="infounitAddress"></param>
/// <param name="bytetype"></param>
/// <returns></returns>
private static string getValue(string valuestr, InfoUnitAddress infounitAddress, int bytetype)
{
double value = (double)SystemCode.HexNumberToDenary(valuestr, infounitAddress.reversionType, bytetype, infounitAddress.signtype);
if (infounitAddress.dotnum > 0)
{
value = Math.Round(value / Math.Pow(10, infounitAddress.dotnum), 1);
}
return(value.ToString());
}
/// <summary>
/// 解析单个信息体
/// </summary>
/// <param name="body"></param>
/// <returns></returns>
public static string[] analyze(string body, int infoType, InfoUnitAddress infounitAddress)
{
string valuestr = "", value = "";
switch (infoType)
{
case DataType.yaoce:
valuestr = body.Substring(3 * 2, 4 * 2);
value = getValue(valuestr, infounitAddress, 32);
break;
case DataType.yaoxin: //对于遥信的信息体，放回值和时间
valuestr = body.Substring(3 * 2, 1 * 2);
value = getValue(valuestr, infounitAddress, 8);
//再取得故障时间
valuestr = body.Substring(5 * 2, 7 * 2);
int year = 2000 + (int)SystemCode.HexNumberToDenary(valuestr.Substring(12, 2), false, 8, 'u') % 99;
int moth = (int)SystemCode.HexNumberToDenary(valuestr.Substring(10, 2), false, 8, 'u');
if (moth > 12)
{
moth = 12;
}
int day = (int)SystemCode.HexNumberToDenary(valuestr.Substring(8, 2), false, 8, 'u');
if (day > 31)
{
day = 28;
}
int hh = (int)SystemCode.HexNumberToDenary(valuestr.Substring(6, 2), false, 8, 'u');
if (hh > 23)
{
hh = 23;
}
int mm = (int)SystemCode.HexNumberToDenary(valuestr.Substring(4, 2), false, 8, 'u');
if (mm > 60)
{
mm = 59;
}
int ss = (int)SystemCode.HexNumberToDenary(valuestr.Substring(2, 2), false, 8, 'u');
if (ss > 60)
{
ss = 59;
}
value += ":" + new DateTime(year, moth, day, hh, mm, ss).ToString("yyyy-mm-dd HH:mm:ss");
break;
case DataType.yaomai:
valuestr = body.Substring(3 * 2, 4 * 2);
value = getValue(valuestr, infounitAddress, 32);
break;
default:
break;
}
return((infounitAddress.address + ":" + value).Split(':'));
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (IsValid == false)
{
return;
}
int EnumValue = 0;
string EnumName = PureString(tbName.Text);
int OrderNumber = 0;
int.TryParse(tbValue.Text, out EnumValue);
int.TryParse(tbSort.Text, out OrderNumber);
UserVM user = AuthServer.GetLoginUser();
int Chk = 0;
Dictionary <string, object> OutDict = new Dictionary <string, object>()
{
{ "@Chk", Chk }
};
MSDB.ExecuteNonQuery("ConnDB", "dbo.usp_CodeM_xAddSystemCode"
, ref OutDict
, new Dictionary <string, object>()
{
{ "@SystemCodeCateID", ID },
{ "@EnumValue", EnumValue },
{ "@EnumName", EnumName },
{ "@CanEdit", 0 },
{ "@OrderNumber", OrderNumber },
{ "@CreatedUserID", user.ID }
});
Chk = (int)OutDict["@Chk"];
string script = "";
if (Chk > 0)
{
script = string.Format("{0}<script>alert('儲存成功');location.href='{1}#{2}';</script>",
"<style>body{display:none;}</style>"
, "/System/CodeM/CodeSetting.aspx"
, HttpUtility.HtmlDecode(GetString("hash") ?? "")
);
SystemCode.Update();
}
else
{
script = "<script>alert('儲存失敗');</script>";
}
Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false);
}
public async Task <IActionResult> Create([Bind("Category,Code,DisplayOrder,DisplayName,Description,CreateDatetime,CreateUserId,UpdateDatetime,UpdateUserId")] SystemCode systemCode)
{
if (ModelState.IsValid)
{
_context.Add(systemCode);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(systemCode));
}
protected void Page_Load(object sender, EventArgs e)
{
//base.AllowHttpMethod("POST");
//base.DisableTop(true);
int pgNow;
int pgSize;
//int UrgeType=0;
//int UrgeStatus=0;
//string CreateDateS;
string IdNo;
IdNo = Request.Form["IdNo"] ?? "";
//CreateDateE = Request.Form["CreateDateE"] ?? "";
//if (CreateDateS != "") CreateDateS = (Convert.ToInt32(CreateDateS.Substring(0, 3)) + 1911).ToString() + "/" + CreateDateS.Substring(3, 2) + "/" + CreateDateS.Substring(5, 2);
//if (CreateDateE != "") CreateDateE = (Convert.ToInt32(CreateDateE.Substring(0, 3)) + 1911).ToString() + "/" + CreateDateE.Substring(3, 2) + "/" + CreateDateE.Substring(5, 2);
int.TryParse(Request.Form["pgNow"], out pgNow);
int.TryParse(Request.Form["pgSize"], out pgSize);
//int.TryParse(Request.Form["UrgeType"], out UrgeType);
//int.TryParse(Request.Form["UrgeStatus"], out UrgeStatus);
SystemCode.Update();
DataSet ds = new DataSet();
using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString()))
{
using (SqlCommand cmd = new SqlCommand("dbo.usp_Log_xLogIdFilterList", sc))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pgNow", pgNow == 0 ? 1 : pgNow);
cmd.Parameters.AddWithValue("@pgSize", pgSize == 0 ? 10 : pgSize);
cmd.Parameters.AddWithValue("@IdNo", IdNo);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
sc.Open();
da.Fill(ds);
}
}
}
List <LogListVM> list = new List <LogListVM>();
PageVM rtn = new PageVM();
EntityS.FillModel(list, ds.Tables[0]);
EntityS.FillModel(rtn, ds.Tables[1]);
rtn.message = list;
Response.ContentType = "application/json; charset=utf-8";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn));
Response.End();
}
protected void dllInit()
{
SystemCode.Update();
if (SystemCode.dict.ContainsKey("CaseUser_ContactRelationShip"))
{
List <SystemCodeVM> SystemCodeList = SystemCode.dict["CaseUser_ContactRelationShip"];
foreach (SystemCodeVM sc in SystemCodeList)
{
ddlRS.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString()));
}
}
}
public static string HtmlSelect(string inputid, string inputname, string SystemCodeCate, string SelectVal)
{
string select = "<select {2} {0} >{1}</select>";
string options = "";
List <SystemCodeVM> SystemCodeList = SystemCode.GetDict(SystemCodeCate);
foreach (SystemCodeVM sc in SystemCodeList)
{
options += string.Format("<option value=\"{1}\" {2} >{0}</option>", sc.EnumName, sc.EnumValue.ToString(), (sc.EnumValue.ToString() == SelectVal ? "selected" : ""));
}
return(string.Format(select, (inputid != "" ? " id=\"" + inputid + "\"" : ""), options, (inputname != "" ? " name=\"" + inputname + "\"" : "")));
}
public async Task <bool> AddSystem(SystemCode entity)
{
await _context.SystemCodes.AddAsync(entity);
try
{
await _context.SaveChangesAsync();
return(true);
}
catch (Exception)
{
return(false);
}
}
public void SaveChanges(SystemCode system = SystemCode.Identity)
{
try { GetContext(system).SaveChanges(); }
catch (DbEntityValidationException e) {
var sb = new StringBuilder();
foreach (var eve in e.EntityValidationErrors)
{
sb.AppendLine(string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State));
foreach (var ve in eve.ValidationErrors)
{
sb.AppendLine(string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage));
}
}
throw new Exception(sb.ToString());
}
}
private void ShowFiles(int VisitID, bool bDownload)
{
DataTable dt = (DataTable)DBUtil.DBOp("ConnDB", "SELECT isnull(C_CaseVisitFile.Filetype,0) Filetype,C_CaseVisitFile.ID,[FileID] ,F_FileInfo.DisplayFileName FROM [dbo].[C_CaseVisitFile] inner join F_FileInfo on F_FileInfo.ID = [C_CaseVisitFile].FileID and [C_CaseVisitFile].VisitID={0} and C_CaseVisitFile.LogicDel=0", new string[] { VisitID.ToString() }, NSDBUtil.CmdOpType.ExecuteReaderReturnDataTable);
foreach (DataRow r in dt.Rows)
{
string filetype = SystemCode.GetName("CaseVisit_VisitFileType", Convert.ToInt32(r["Filetype"]));
if (bDownload)
{
ltFiles.Text += string.Format("<div id=\"FileDIV_{2}\"><a href=\"DownloadFileOP.aspx?i={1}\">{3} : {0}</a> <img src=\"/images/icon_del01.gif\" class=\"delFile\" id=\"img_del_{2}\" />;</div>", Server.HtmlEncode(r["DisplayFileName"].ToString()), Server.HtmlEncode(r["FileID"].ToString()), Server.HtmlEncode(r["ID"].ToString()), filetype);
}
else
{
ltFiles.Text += filetype + ":" + Server.HtmlEncode(r["DisplayFileName"].ToString()) + ";";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//base.DisableTop(true);
int r = 0;
int.TryParse(Request["r"], out r);
//SystemCode.Update();
if (r > 0)
{
string ResultCatKey = "CaseVisit_VisitResult_Reason_" + r.ToString();
List <SystemCodeVM> SystemCodeList = SystemCode.GetDict(ResultCatKey);
VisitResultData = JsonConvert.SerializeObject(SystemCodeList);
}
Response.ContentType = "application/json; charset=utf-8";
Response.Write(VisitResultData);
Response.End();
}
/// <summary>
/// 取得单个信息体的解析规则
/// </summary>
/// <param name="body"></param>
/// <returns></returns>
public static InfoUnitAddress getInfoUnitAddress(string body)
{
try
{
//取出测点
int address = (int)SystemCode.HexNumberToDenary(body.Substring(1 * 2, 2 * 2), true, 16, 'u');
//取得不同信息单元地址对应的解析规则
DataType dy = new DataType();
if (DataType.deviceTypeMap.ContainsKey(address))
{
return((InfoUnitAddress)DataType.deviceTypeMap[address]);
}
}
catch (Exception ee)
{
Console.WriteLine(ee.StackTrace);
}
return(null);
}
protected void btnRemove_Click(object sender, EventArgs e)
{
if (IsValid == false)
{
return;
}
int Chk = 0;
Dictionary <string, object> OutDict = new Dictionary <string, object>()
{
{ "@Chk", Chk }
};
MSDB.ExecuteNonQuery("ConnDB", "dbo.usp_CodeM_xDeleteSystemCodeByID"
, ref OutDict
, new Dictionary <string, object>()
{
{ "@SystemCodeID", ID }
});
Chk = (int)OutDict["@Chk"];
string script = "";
if (Chk > 0)
{
script = string.Format("{0}<script>alert('儲存成功');location.href='{1}#{2}';</script>",
"<style>body{display:none;}</style>"
, "/System/CodeM/CodeSetting_Detail.aspx?i=" + CateID
, HttpUtility.HtmlDecode(GetString("hash") ?? "")
);
SystemCode.Update();
}
else
{
script = "<script>alert('儲存失敗');</script>";
}
Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false);
}
public async Task <bool> UpdateSystem(SystemCode entity)
{
try
{
var item = await _context.SystemCodes.AnyAsync(x => x.ID == entity.ID);
if (item == false)
{
return(false);
}
_context.SystemCodes.Update(entity);
await _context.SaveChangesAsync();
return(true);
}
catch (Exception)
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
base.AllowHttpMethod("GET", "POST");
base.DisableTop(true);
base.BodyClass = "class='bodybg'";
user = AuthServer.GetLoginUser();
if (this.IsPostBack == false)
{
List <int> list = new List <int>()
{
1, 2, 3, 4, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24
};
var dict = SystemCode.GetDict("RecordM_StudentRecord_VaccineCate");
if (dict.Count > 0)
{
var query = dict.Where(item => list.Contains(item.EnumValue));
tbAry = JsonConvert.SerializeObject(query);
}
int nowYear = DateTime.Now.Year - 1911;
ddlYear.Items.Add(new ListItem(nowYear.ToString() + "年", nowYear.ToString()));
ddlYear.Items.Add(new ListItem((nowYear + 1).ToString() + "年", (nowYear + 1).ToString()));
//if (SystemElementarySchool.list.Count > 0)
//{
// ddlSchool.Items.Add(new ListItem("0", "請選擇學校名稱"));
// foreach(var item in SystemElementarySchool.list)
// {
// ddlSchool.Items.Add(new ListItem(item.ElementarySchoolID.ToString(), item.SchoolName));
// }
//}
if (SystemElementarySchool.list.Count > 0)
{
sAry = JsonConvert.SerializeObject(SystemElementarySchool.list);
}
}
}
private string GenerateToken(UserAuthorization user, DateTime expires, SystemCode SystemCode)
{
var handler = new JwtSecurityTokenHandler();
ClaimsIdentity identity = new ClaimsIdentity(
new GenericIdentity(user.LoginID, "TokenAuth"),
new[] {
new Claim("ID", user.ID.ToString()),
new Claim("SystemCode", ((int)SystemCode).ToString())
}
);
var securityToken = handler.CreateToken(new SecurityTokenDescriptor
{
Issuer = TokenAuthOption.Issuer,
Audience = TokenAuthOption.Audience,
SigningCredentials = TokenAuthOption.SigningCredentials,
Subject = identity,
Expires = expires
});
return(handler.WriteToken(securityToken));
}
private string ShowFiles(int VisitID, bool bDownload)
{
StringBuilder sb = new StringBuilder("");
DataTable dt = (DataTable)DBUtil.DBOp("ConnDB", "SELECT isnull(C_CaseVisitFile.Filetype,0) Filetype,C_CaseVisitFile.ID,[FileID] ,F_FileInfo.DisplayFileName FROM [dbo].[C_CaseVisitFile] inner join F_FileInfo on F_FileInfo.ID = [C_CaseVisitFile].FileID and [C_CaseVisitFile].VisitID={0} and C_CaseVisitFile.LogicDel=0", new string[] { VisitID.ToString() }, NSDBUtil.CmdOpType.ExecuteReaderReturnDataTable);
foreach (DataRow r in dt.Rows)
{
string filetype = SystemCode.GetName("CaseVisit_VisitFileType", Convert.ToInt32(r["Filetype"]));
if (bDownload)
{
sb.AppendFormat("<div id=\"FileDIV_{2}\"><a href=\"DownloadFileOP.aspx?i={1}\">{3} : {0}</a> ;</div>", Server.HtmlEncode(r["DisplayFileName"].ToString()), Server.HtmlEncode(r["FileID"].ToString()), Server.HtmlEncode(r["ID"].ToString()), filetype);
}
else
{
sb.Append(filetype + ":" + Server.HtmlEncode(r["DisplayFileName"].ToString()) + ";");
}
}
return(sb.ToString());
}
