protected void Page_Load(object sender, EventArgs e)
{
SearchPower = base.AddPower(SearchPower);
string Para = "";
if (SearchPower.HasPower == true)
{
Para = Request.Form["Para"];
}
DataSet ds = new DataSet();
using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString()))
{
using (SqlCommand cmd = new SqlCommand("usp_SysParameter_xSearchTable", sc))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Para", Para);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
sc.Open();
da.Fill(ds);
}
}
}
List <SystemParametersVM> list = new List <SystemParametersVM>();
AnyDataVM rtn = new AnyDataVM();
EntityS.FillModel(list, ds.Tables[0]);
rtn.message = list;
Response.ContentType = "application/json; charset=utf-8";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn));
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
int BatchID;
int.TryParse(Request.Form["BatchID"], out BatchID);
DataSet ds = new DataSet();
using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString()))
{
using (SqlCommand cmd = new SqlCommand("usp_StockQuery_xGetStockQueryBatch", sc))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BatchID", BatchID);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
sc.Open();
da.Fill(ds);
}
}
}
AnyDataVM rtn = new AnyDataVM();
rtn.message = ds.Tables[0];
Response.ContentType = "application/json; charset=utf-8";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn));
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
UserVM user = AuthServer.GetLoginUser();
string PageType;
int ID;
int SelectID;
PageType = Request.Form["Page"];
int.TryParse(Request.Form["ID"], out ID);
int.TryParse(Request.Form["SelectID"], out SelectID);
DataSet ds = new DataSet();
using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString()))
{
using (SqlCommand cmd = new SqlCommand("usp_StockManagementM_xGetVaccineBatch", sc))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PageType", PageType);
cmd.Parameters.AddWithValue("@DataID", ID);
cmd.Parameters.AddWithValue("@VaccID", SelectID);
cmd.Parameters.AddWithValue("@OrgID", user.OrgID);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
sc.Open();
da.Fill(ds);
}
}
}
List <ChooseVaccineBatchVM> list = new List <ChooseVaccineBatchVM>();
AnyDataVM rtn = new AnyDataVM();
EntityS.FillModel(list, ds.Tables[0]);
rtn.message = list;
Response.ContentType = "application/json; charset=utf-8";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn));
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
int OrgID = 0;
int.TryParse(Request.Form["OrgID"], out OrgID);
if (OrgID == 0)
{
string script = "<script>alert('資料取得失敗');history.go(-1);</script>";
Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "alert", script, false);
}
EncryptDES enc = new EncryptDES();
DataSet ds = new DataSet();
using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString()))
{
using (SqlCommand cmd = new SqlCommand("usp_StMsgSet_xGetStMsgSetData", sc))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OrgID", OrgID);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
sc.Open();
da.Fill(ds);
}
}
}
AnyDataVM rtn = new AnyDataVM();
if (ds.Tables[0].Rows.Count > 0)
{
ds.Tables[0].Rows[0]["MsgPassWord"] = enc.ToDecryptDES(ds.Tables[0].Rows[0]["MsgPassWord"].ToString(), Convert.ToString(WebConfigurationManager.AppSettings["encryptKey"]));
}
rtn.message = ds.Tables[0];
Response.ContentType = "application/json; charset=utf-8";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn));
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
UserVM user = AuthServer.GetLoginUser();
int Status = 0;
if (SearchPower.HasPower == true)
{
int.TryParse(Request.Form["Status"], out Status);
}
DataSet ds = new DataSet();
using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString()))
{
using (SqlCommand cmd = new SqlCommand("usp_OrgVaccSet_xGetVaccine", sc))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OrgID", user.OrgID);
cmd.Parameters.AddWithValue("@Status", Status);
cmd.Parameters.AddWithValue("@CreateAccount", user.ID);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
sc.Open();
da.Fill(ds);
}
}
}
List <OrgVaccSet> list = new List <OrgVaccSet>();
AnyDataVM rtn = new AnyDataVM();
EntityS.FillModel(list, ds.Tables[0]);
rtn.message = list;
Response.ContentType = "application/json; charset=utf-8";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn));
Response.End();
}