/// <summary>
/// 新增個案出境紀錄
/// </summary>
/// <param name="FileData"></param>
/// <returns></returns>
protected int AddEmiData(string[] FileData)
{
int Status = 0;
string birthday = TaiwanYear.ToDateString(FileData[2]);
string EmiDate = TaiwanYear.ToDateString(FileData[3]);
if (birthday.Equals("") || EmiDate.Equals(""))
{
return(0);
}
DataSet ds = new DataSet();
using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString()))
{
DataTable dt = new DataTable();
//寫入入境資料
using (SqlCommand cmd = new SqlCommand("usp_CaseUser_xAddImmiData", sc))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IdNo", FileData[1]);
cmd.Parameters.AddWithValue("@ImmiStatus", 1);
cmd.Parameters.AddWithValue("@ImmiDate", EmiDate.Replace("/", ""));
cmd.Parameters.AddWithValue("@FlightNo", "");
cmd.Parameters.AddWithValue("@ArrivalLoc", "");
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
sc.Open();
da.Fill(dt);
}
}
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows[0]["bSuccess"].ToString().Equals("1"))
{
Status = 1;
}
}
}
return(Status);
}
protected void Page_Load(object sender, EventArgs e)
{
//base.AllowHttpMethod("POST");
string BirthDateS;
string BirthDateE;
int SearchKind = 1;
int OrgID = 0;
BirthDateS = Request.Form["BirthDateS"] ?? "";
BirthDateE = Request.Form["BirthDateE"] ?? "";
if (BirthDateS != "")
{
BirthDateS = TaiwanYear.ToDateString(BirthDateS);
}
if (BirthDateE != "")
{
BirthDateE = TaiwanYear.ToDateString(BirthDateE);
}
int.TryParse(Request["SearchKind"], out SearchKind);
int.TryParse(Request["OrgID"], out OrgID);
DataTable dt = (DataTable)DBUtil.DBOp("ConnDB", " exec dbo.usp_CaseUser_xGetMergeUserListToExport {0},{1},{2},{3} "
, new string[] {
BirthDateS, BirthDateE, OrgID.ToString(), SearchKind.ToString()
}, NSDBUtil.CmdOpType.ExecuteReaderReturnDataTable);
//DataTableToCSV.DownloadCSV(dt, "MyCsv.csv");
ExcelToolT t = new ExcelToolT();
Response.Clear();
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/download";
Response.AddHeader("content-disposition", "attachment;filename=" + Server.UrlEncode("99未歸戶個案維護.csv"));
Response.BinaryWrite(((MemoryStream)t.RenderDataTableToExcel(dt)).ToArray());
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
//base.AllowHttpMethod("POST");
//base.DisableTop(true);
int pgNow = 1, pgSize = 10;
int OrderCol = 0, OrderAsc = 1;//0出生日期1身份證號 //1ASC 0 DESC
int OrgID = 0;
int AddrKind = 0, CountyID = 0, TownID = 0;
int SearchNumberType = 0;
string BirthDateS = "", BirthDateE = "";
string CaseName = "", CaseIdNo = "", HouseNo = "";
string ContactName = "", ContactIdNo = "", ContactBirthDate = "";
#region QS()
BirthDateS = Request.Form["BirthDateS"] ?? "";
BirthDateE = Request.Form["BirthDateE"] ?? "";
ContactBirthDate = Request.Form["ContactBirthDate"] ?? "";
if (BirthDateS != "")
{
BirthDateS = TaiwanYear.ToDateString(BirthDateS);
}
if (BirthDateE != "")
{
BirthDateE = TaiwanYear.ToDateString(BirthDateE);
}
if (ContactBirthDate != "")
{
ContactBirthDate = TaiwanYear.ToDateString(ContactBirthDate);
}
CaseName = Request.Form["CaseName"] ?? "";
CaseIdNo = Request.Form["CaseIdNo"] ?? "";
HouseNo = Request.Form["HouseNo"] ?? "";
ContactName = Request.Form["ContactName"] ?? "";
ContactIdNo = Request.Form["ContactIdNo"] ?? "";
int.TryParse(Request.Form["pgNow"], out pgNow);
int.TryParse(Request.Form["pgSize"], out pgSize);
int.TryParse(Request.Form["AddrKind"], out AddrKind);
int.TryParse(Request.Form["OrgID"], out OrgID);
int.TryParse(Request.Form["CountyID"], out CountyID);
int.TryParse(Request.Form["TownID"], out TownID);
int.TryParse(Request.Form["NumberType"], out SearchNumberType);
int.TryParse(Request.Form["OrderCol"], out OrderCol);
int.TryParse(Request.Form["OrderAsc"], out OrderAsc);
#endregion
OrgID = AuthServer.GetLoginUser().OrgID;
DataTableCollection dtc = (DataTableCollection)DBUtil.DBOp("ConnDB"
, "exec dbo.usp_CaseUser_xGetUserList {0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16}"
, new string[] { pgNow.ToString()
, pgSize.ToString()
, OrderCol.ToString()
, OrderAsc.ToString()
, CaseName
, CaseIdNo
, BirthDateS
, BirthDateE
, HouseNo
, AddrKind.ToString()
, ContactName
, ContactIdNo
, ContactBirthDate
, OrgID.ToString() //請帶入想查看的ORG //若沒得選 請帶入目前登入user.org
, CountyID.ToString()
, TownID.ToString()
, SearchNumberType.ToString() }, NSDBUtil.CmdOpType.ExecuteReaderReturnDataTableCollection);
List <UserProfileListVM> list = new List <UserProfileListVM>();
PageVM rtn = new PageVM();
EntityS.FillModel(list, dtc[0]);
EntityS.FillModel(rtn, dtc[1]);
rtn.message = list;
Response.ContentType = "application/json; charset=utf-8";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn));
Response.End();
}
protected void btnSave_Click(object sender, EventArgs e)
{
List <string> RequestKeys = Request.Form.AllKeys.Where(key => key.Contains("ddlVaccineCode_") || key.Contains("ddlNotNeedOrRejectReason_") || key.Contains("tbPrDate_")).ToList();
UserVM user = AuthServer.GetLoginUser();
string VacIDs = hdVac.Value ?? "";
string[] Vac = VacIDs.Split(',');
string VisitResult = ddlVisitResult.SelectedValue;
string spName = (VisitID != 0 ? "usp_CaseVisit_xEdit" : "usp_CaseVisit_xAdd");
DataTable dt = (DataTable)DBUtil.DBOp("ConnDB",
"exec [dbo].[" + spName + "] {0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10} "
, new string[] {
TaiwanYear.ToDateString(tbVisitDate.Text)
, (VisitID != 0 ? VisitID.ToString() : CaseID.ToString())
, ddlVisitMan.SelectedValue
, ddlVisitType.SelectedValue
, ddlVisitReason.SelectedValue
, VisitResult
, tbVisitComment.Text
, user.ID.ToString()
, user.OrgID.ToString()
, TaiwanYear.ToDateString(tbPreBackDate.Text)
, ddlCountry.SelectedValue
}, NSDBUtil.CmdOpType.ExecuteReaderReturnDataTable);
int NewVisitID = 0;
if (dt.Rows.Count > 0)
{
NewVisitID = Convert.ToInt32(dt.Rows[0][0]);
CaseID = Convert.ToInt32(dt.Rows[0][1]);
handlefile(NewVisitID);
}
DBUtil.DBOp("ConnDB", " UPDATE [dbo].[C_CaseVisitDetail] SET [LogicDel] = 1 where VisitID={0} "
, new string[] { NewVisitID.ToString() }, NSDBUtil.CmdOpType.ExecuteNonQuery);
//Response.Write(VacIDs);
//Response.End();
foreach (string v in Vac)
{
string VacIDSeq = "", VisitResultDetailID = "0", PrejectDate = "", VacID = "", Seq = "";
VacIDSeq = Request.Form [RequestKeys.Find(r => r.Contains("ddlVaccineCode_" + v))] ?? "";
VacID = (VacIDSeq == "" ?v: VacIDSeq.Split('-')[0]);
Seq = (VacIDSeq.Split('-').Length > 1 ? VacIDSeq.Split('-')[1] :"");
VisitResultDetailID = Request.Form [RequestKeys.Find(r => r.Contains("ddlNotNeedOrRejectReason_" + v))] ?? "";
PrejectDate = TaiwanYear.ToDateString(Request.Form[RequestKeys.Find(r => r.Contains("tbPrDate_" + v))] ?? "");
DBUtil.DBOp("ConnDB", " exec [dbo].[usp_CaseVisit_xAddDetail] {0},{1},{2} ,{3},{4} "
, new string[] { NewVisitID.ToString(), VacID, Seq, VisitResultDetailID, PrejectDate }, NSDBUtil.CmdOpType.ExecuteNonQuery);
}
//更新個人紀錄
DBUtil.DBOp("ConnDB", " exec [dbo].[usp_CaseVisit_xUpdateRecordData] {0} "
, new string[] { NewVisitID.ToString() }, NSDBUtil.CmdOpType.ExecuteNonQuery);
Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "alert('成功!');location.href='VisitCaseList.aspx?i=" + CaseID.ToString() + "';", true);
}