protected void btn_changePsw_Click(object sender, EventArgs e)
{
try
{
UserPower user = Session["user"] as UserPower;
if (user == null)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "javascript", "<script>alert('没有登录或会话过期！请重新登录');window.location.href='../../Admin_login.aspx';</script>");
return;
}
if (!user.Psw.Equals(tbox_oldPassword.Value))
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "javascript", "<script>alert('原始密码不正确！');</script>");
return;
}
bool bRet = false;
string newPsw = tbox_newPassword1.Value;
bRet = user.ChangePsw(user, newPsw);
if (bRet)
{
user.Psw = newPsw;
Session["user"] = user;
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "javascript", "<script>alert('密码修改成功！');window.location.href='Default.aspx';</script>");
return;
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
private void PowerManage(UserPower user)
{
if (user.IsAdmin())
{
//do nothing
btn_insert.Visible = true;
}
else if (user.IsSuperuser())
{
//ddl_dept.Visible = false;
//lbl_dept.Text = user.UserDeptName;
//p_floor.Visible = false;
}
else if (user.IsUser())
{
ddl_dept.Visible = false;
lbl_dept.Text = user.UserDeptName;
p_floor.Visible = false;
ddl_floor.Visible = false;
p_catigory2.Visible = false;
ddl_category2.Visible = false;
btn_export_floor.Visible = false;
div_operation.Visible = false;
}
else
{
//default
}
}
public static int AddUserData(All userData)
{
UserBuild ub = new UserBuild();
userData.Time = Function.GetUTCTime();
SamgoModels.UserInfo ui = new SamgoModels.UserInfo();
UserValue uLord = new UserValue();
UserValue uProsperity = new UserValue();
UserPower up = new UserPower();
UserTechnique ut = new UserTechnique();
UserOrdnance uo = new UserOrdnance();
var userInfo = new SamgoModels.UserInfo();
userData.SeqNo = DapperHelper.Search<int>(
connectionString, " exec [samgo_add_user_and_group] N'" +
userData.Role + "' , N'" + userData.Legion + "'").FirstOrDefault();
ConvertDataToModels(ref ub, ref ui, ref uLord, ref uProsperity, ref up, userData);
DapperHelper.InsertSQLNormal<UserBuild>(connectionString, "Build", ub);
//DapperHelper.InsertSQL<SamgoModels.UserInfo>(connectionString, "SamgoGame", ui);
DapperHelper.InsertSQLNormal<UserValue>(connectionString, "Lord", uLord);
DapperHelper.InsertSQLNormal<UserValue>(connectionString, "Prosperity", uProsperity);
DapperHelper.InsertSQLNormal<UserPower>(connectionString, "SamgoGamePower", up);
ConvertDataToModels(ref ut, ref uo, userData);
DapperHelper.InsertSQLNormal<UserTechnique>(connectionString, "Technique", ut);
var response = DapperHelper.InsertSQLNormal<UserOrdnance>(connectionString, "Ordnance", uo);
return userData.SeqNo;
}
public HttpResponseMessage Post([FromBody] UserPower value)
{
var response = (int)DapperHelper.InsertSQL <UserPower>(connectionString, TableName, value);
value.SeqNo = response;
return(Request.CreateResponse(HttpStatusCode.OK, value));
}
protected void btn_Login_Click(object sender, EventArgs e)
{
try
{
//Alter table dbo.JCI_newEmp add psw varchar(16)
UserPower user = new UserPower();
user.UserId = tb_UserId.Text;
user.UserDept = tb_userDept.Text;
user.Psw = tb_UserPsw.Text;
user = user.Login(user);
if (user != null)
{
Session["user"] = user;
Response.Redirect("Patient/Manage/Default.aspx", false);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "javascript", "<script>alert('用户名或密码错误！');</script>");
return;
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
private void initUser()
{
if (Session["user"] == null)
{
Response.Redirect("../Admin_login.aspx");
return;
}
UserPower u = Session["user"] as UserPower;
if (u == null)
{
Response.Redirect("../Admin_login.aspx");
return;
}
if (u.IsAdmin())
{
hf_hidden_test.Value = "true";
btn_manage.Visible = true;
}
else
{
hf_hidden_test.Value = "false";
btn_manage.Visible = false;
}
}
private UserPower GetDummyUser()
{
UserPower user = new UserPower();
user.Power = "admin";
Session["user"] = user;
return(user);
}
public bool ChangePsw(UserPower user, string newPsw)
{
SqlConnect conn = new SqlConnect();
string sql = "update dbo.JCI_newEmp set psw='" + newPsw + "' where empId='" + user.UserId + "' and deptNum='" + user.UserDept + "'";
conn.ExcuteCmd(sql);
return(true);
}
private void PowerManage()
{
UserPower user = Session["user"] as UserPower;
if (user == null)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "javascript", "<script>alert('没有登录或会话失效，请登录！')</script>");
Response.Redirect("../../Admin_login.aspx");
}
}
public IActionResult Edit(int AccountID, int?UserID)
{
UserPower userPower = new UserPower();
if (UserID.HasValue)
{
userPower = userPowerDataService.Get(UserID.Value);
}
userPower.UserAuthorizationID = AccountID;
return(View(userPower));
}
//public float cooldown;
//public
// Use this for initialization
void Awake()
{
CombatHandler combatHandler = this.GetComponent <CombatHandler>();
powers = new UserPower[powerData.Length];
for (int x = 0; x < powerData.Length; x++)
{
UserPower userPower = new UserPower();
userPower.initialize(combatHandler, powerData[x]);
powers[x] = userPower;
}
}
public UserPower Login(UserPower u)
{
SqlConnect conn = new SqlConnect();
string sql = "select * from dbo.JCI_newEmp emp where 1=1 and emp.empId='" + u.UserId + "' and emp.deptNum='" + u.UserDept + "' and emp.psw='" + u.Psw + "'";
DataTable dt = conn.ExcuteSelect(sql);
if (dt.Rows.Count > 0)
{
u.Power = GetPower(dt.Rows[0]["power"].ToString());
u.UserDeptName = dt.Rows[0]["deptName"].ToString();
u.UserDept = dt.Rows[0]["deptNum"].ToString();
return(u);
}
return(null);
}
private void u_init_brifeInfo(string rdn)
{
SqlConnect conn = new SqlConnect();
string sql = "select * from dbo.JCI_patient_brifeInfo where rdn=" + rdn;
//if()
UserPower user = Session["user"] as UserPower;
if (user == null)
{
PowerManage();
}
else
{
if (user.IsUser())
{
sql += " and dept='" + user.UserDeptName + "'";
}
}
DataTable dt = conn.ExcuteSelect(sql);
DataRow dr = dt.Rows[0];
tbox_reportDate.Text = dr["regDept"].ToString();
tbox_fillPerson.Text = dr["fillPerson"].ToString();
tbox_once.Text = dr["isFirst"].ToString();
tbox_other1.Text = dr["other1"].ToString();
tbox_personSex.Text = dr["personSex"].ToString();
tbox_regDate.Text = Convert.ToDateTime(dr["regDate"]).ToString("yyy-MM-dd");
tbox_ddl_dept.Text = dr["dept"].ToString();
tbox_ddl_floor.Text = dr["floorName"].ToString();
tbox_job.Text = dr["job"].ToString();
tbox_pay.Text = dr["payType"].ToString();
string promote = dr["promote"].ToString();
string needImprove = dr["needImprove"].ToString();
string[] promotes = promote.Split(';');
string[] needImproves = needImprove.Split(';');
tbox_promote_yl.Text = promotes[0].Split(':')[1];
tbox_promote_hl.Text = promotes[1].Split(':')[1];
tbox_promote_yj.Text = promotes[2].Split(':')[1];
tbox_promote_hq.Text = promotes[3].Split(':')[1];
tbox_promote_zy.Text = promotes[4].Split(':')[1];
tbox_needImprove_yl.Text = needImproves[0].Split(':')[1];
tbox_needImprove_hl.Text = needImproves[1].Split(':')[1];
tbox_needImprove_yj.Text = needImproves[2].Split(':')[1];
tbox_needImprove_hq.Text = needImproves[3].Split(':')[1];
tbox_needImprove_zy.Text = needImproves[4].Split(':')[1];
}
private static void ConvertDataToModels(ref UserBuild ub,
ref SamgoModels.UserInfo ui,
ref UserValue uLord,
ref UserValue uProsperity,
ref UserPower up,
All userData)
{
//SamgoGame(主紀錄+編號)
ui.Legion = userData.Legion;
ui.Official = userData.Official;
ui.Role = userData.Role;
ui.SeqNo = userData.SeqNo;
//Lord(主公)
uLord.SeqNo = userData.SeqNo;
uLord.Time = userData.Time;
uLord.Value = userData.Lord;
//Prosperity(繁榮)
uProsperity.SeqNo = userData.SeqNo;
uProsperity.Time = userData.Time;
uProsperity.Value = userData.Prosperity;
//Build(大殿)
ub.SeqNo = userData.SeqNo;
ub.Time = userData.Time;
ub.Basilica = userData.Basilica;
ub.Technique = userData.Technique;
ub.Market = userData.Market;
ub.Horse = userData.Horse;
ub.School = userData.School;
ub.House = userData.House;
ub.Wood = userData.Wood;
ub.Stone = userData.Stone;
ub.Iron = userData.Iron;
ub.Farmland = userData.Farmland;
ub.Barracks = userData.Barracks;
ub.Soldier = userData.Soldier;
ub.Coin = userData.Coin;
ub.Treasure = userData.Treasure;
ub.Ordnance = userData.Ordnance;
ub.Wall = userData.Wall;
//戰力
up.Power = userData.Power;
up.SeqNo = userData.SeqNo;
up.Time = userData.Time;
}
public IActionResult Save(UserPower userPower)
{
try
{
if (userPower.ID != 0)
{
userPowerDataService.Update(userPower);
}
else
{
userPowerDataService.Insert(userPower);
}
return(Json(new APIResult <UserPower>(userPower)));
}
catch (Exception ex)
{
return(Json(new APIResult <UserPower>(errors: ex.Message)));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
UserPower user = Session["user"] as UserPower;
//user = GetDummyUser();
if (user == null)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "javascript", "<script>alert('没有登录或会话失效，请登录！')</script>");
Response.Redirect("../../Admin_login.aspx");
return;
}
string sqlWhere = GetPowerSqlWhere(user);
u_init(sqlWhere);
PowerManage(user);
}
/// <summary>
/// 默认的事务方法
/// </summary>
/// <param name="userPower"></param>
/// <returns></returns>
public UserPower Commit(UserPower userPower)
{
try
{
// 定义
UserPower result = new UserPower();
// 事务
transService.TransRegist(delegate {
result = base.Delete(userPower);
});
// 提交
transService.TransCommit();
// 返回
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
private string GetPowerSqlWhere(UserPower user)
{
string retValue = "";
if (user.IsAdmin())
{
//do nothing
}
else if (user.IsSuperuser())
{
}
else if (user.IsUser())
{
retValue = " and dept='" + user.UserDeptName + "' ";
}
else
{
//default
}
return(retValue);
}
protected void rpt_patient_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
//e.Item.DataItem
UserPower user = Session["user"] as UserPower;
//user = GetDummyUser();
if (user == null)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "javascript", "<script>没有登录或会话失效，请登录！</script>");
Response.Redirect("../../Admin_login.aspx");
}
object o = e.Item.DataItem;
Control Btndelete = e.Item.FindControl("btn_delete");
if (Btndelete != null)
{
if (!user.IsAdmin())
{
Btndelete.Visible = false;
}
}
}
public void setBound(UserPower power)
{
boundPower = power;
setEnabled(true);
}
protected void btn_export_dept_Click(object sender, EventArgs e)
{
PatientTable pt = new PatientTable();
DateTime beginDate, endDate;
beginDate = DateTime.Now.AddMonths(-1);
endDate = DateTime.Now.AddMonths(1);
beginDate = Convert.ToDateTime(tbox_beginDate.Text);
beginDate = beginDate.AddDays(-1);
endDate = Convert.ToDateTime(tbox_endDate.Text);
endDate = endDate.AddDays(1);
string deptName = ""; // ddl_dept.SelectedValue;
UserPower user = Session["user"] as UserPower;
if (user == null)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "javascript", "<script>alert('没有登录或会话失效，请登录！')</script>");
Response.Redirect("../../Admin_login.aspx");
}
else
{
deptName = user.GetPowerDept();
if (deptName.Equals(""))
{
//use selected dept
deptName = ddl_dept.SelectedValue;
}
}
//deptName = GetPowerDept()
string category = ddl_category1.SelectedValue;
string fileName = System.Configuration.ConfigurationManager.AppSettings["ExportPath"] + category + "_" + deptName + DateTime.Now.ToString("yyyyMMdd") + ".xls";
string sqlWhere = " and brifeInfo.dept ='" + deptName + "'";
string result = "";
switch (category)
{
case "医疗":
result = pt.Exportyl(fileName, beginDate, endDate, sqlWhere);
DownloadFile(result, Response, fileName, "医疗_" + category + "_" + deptName + ".xls");
break;
case "护理":
result = pt.Exporthl(fileName, beginDate, endDate, sqlWhere);
DownloadFile(result, Response, fileName, "护理_" + category + "_" + deptName + ".xls");
break;
case "医技":
result = pt.Exportyj(fileName, beginDate, endDate, sqlWhere);
DownloadFile(result, Response, fileName, "医技_" + category + "_" + deptName + ".xls");
break;
case "后勤":
result = pt.Exporthq(fileName, beginDate, endDate, sqlWhere);
DownloadFile(result, Response, fileName, "后勤_" + category + "_" + deptName + ".xls");
break;
case "行政-收费":
result = pt.Exportzy(fileName, beginDate, endDate, sqlWhere);
DownloadFile(result, Response, fileName, "行政-收费_" + category + "_" + deptName + ".xls");
break;
default:
break;
}
}
public HttpResponseMessage Put([FromBody] UserPower value)
{
var response = DapperHelper.UpdateSQL <UserPower>(connectionString, TableName, value);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
public HttpResponseMessage Delete([FromBody] UserPower value)
{
var response = DapperHelper.DeleteSQL(connectionString, TableName, value.SeqNo);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
public bool Update(UserPower userPower)
{
return(_dbHelper.Update <UserPower>(userPower));
}
public bool Insert(UserPower userPower)
{
return(_dbHelper.Insert <UserPower>(userPower));
}
public bool Delete(UserPower userPower)
{
return(_dbHelper.Delete <UserPower>(userPower));
}
