private void UpdatePayInfo(M_T_PAYMENT ety) { CRUD dbiz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, true); try { dbiz.Update(ety, "paymentid"); dbiz.Commit(); } catch (Exception) { dbiz.Abort(); throw; } }
private void UpdateLoginAccount(DataRow dr) { CRUD biz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, true); try { biz.Update <Model.M_Sys_Login_Account>(dr, "UserId"); biz.Commit(); } catch (Exception err) { biz.Abort(); throw err; } }
private int UpdateLoginAcc(Model.M_Sys_Login_Account ety) { BLL.CRUD biz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, true); try { int cnt = biz.Update(ety, "UserId"); biz.Commit(); return(cnt); } catch (Exception) { biz.Abort(); throw; } }
public string InvokeRequest(string postStr) { Helper.LogWrite("SI31 Request:" + postStr); Model.Rsp31 rsp = new Model.Rsp31(); this.req = Common.Helper.JsonDeserialize <Model.Req31>(postStr); DataTable dtUser = this.GetUserInfo(); //取登录用户信息 if (dtUser.Rows.Count > 0) { string status = Helper.DbNull2Str(dtUser.Rows[0]["Status"]); string pwd = Helper.DbNull2Str(dtUser.Rows[0]["PASSWORD"]); if (this.req.data.password == pwd) // 如果密码正确 { rsp.data.result = "100"; rsp.data.message = "验证成功"; rsp.data.lastlogin = dtUser.Rows[0]["updatedate"].ToString(); //上次登录 Common.Runtime.CurrentUser = this.req.data.username; if (this.req.data.logintype == "C" || this.req.data.logintype == "E") { //取租约信息 rsp.data.leaseinfo = this.GetGroupLease(int.Parse(dtUser.Rows[0]["userid"].ToString())); rsp.data.leasecount = rsp.data.leaseinfo.Count; } //更新最后登录时间 dtUser.Rows[0]["UpdateDate"] = DateTime.Now.ToString(); //本次登录更新 if (this.req.data.logintype != "E") { CRUD biz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, true); int cnt = biz.Update <Model.M_Sys_Login_Account>(dtUser.Rows[0], "UserId"); biz.Commit(); } } else { rsp.data.result = "200"; rsp.data.message = "Wrong password!"; } rsp.data.userid = Helper.DbNull2Int(dtUser.Rows[0]["UserId"]); rsp.data.status = Helper.DbNull2Str(dtUser.Rows[0]["Status"]); /// 判断用户状态 switch (status) { case "A": case "F": case "C": break; case "I": rsp.data.result = "200"; rsp.data.message = "Forbidden User!"; break; case "T": if (this.req.data.password == Helper.DbNull2Str(dtUser.Rows[0]["TempPsw"])) { rsp.data.result = "100"; rsp.data.message = "Success!"; Runtime.CurrentUser = this.req.data.username; dtUser.Rows[0]["TempPsw"] = ""; dtUser.Rows[0]["Status"] = "A"; UpdateLoginAccount(dtUser.Rows[0]); } break; } } else { rsp.data.result = "200"; rsp.data.message = "User not exist!"; } return(Common.Helper.JsonSerialize(rsp)); }