protected override Apq.STReturn CheckLogin() { // 管理员检测 Apq.STReturn stReturn = new Apq.STReturn(); CheckAdmin(ref stReturn, ApqSession); return(stReturn); }
protected override Apq.STReturn CheckLogin() { // 密码过期 Apq.STReturn stReturn = new Apq.STReturn(); CheckPwdExpire(ref stReturn, ApqSession); return(stReturn); }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn dtxc_TaskVote_Log_List(string TaskName, string UserNameBegin) { Apq.STReturn stReturn = new Apq.STReturn(); DataSet ds = new DataSet(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { SqlDataAdapter sda = new SqlDataAdapter("dtxc.dtxc_TaskVote_Log_List", SqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("TaskName", TaskName); dch.AddParameter("UserNameBegin", UserNameBegin); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sda.Fill(ds); stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString(); stReturn.FNReturn = ds.Tables[0]; sda.Dispose(); SqlConn.Close(); } return(stReturn); }
public Apq.STReturn Login_LoginNameFromCookie(string LoginName, string SqlLoginPwd) { // 先清除已登录数据 Session.Clear(); Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (SqlLoginPwd.Length < 63) { stReturn.NReturn = -1; stReturn.ExMsg = "密码不允许为空"; return(stReturn); } byte[] binLoginPwd = Apq.Data.SqlClient.Common.ParseSqlON <byte[]>(System.Data.SqlDbType.VarBinary, SqlLoginPwd) as byte[]; stReturn = DBLogin(LoginName, binLoginPwd); // Session操作 if (stReturn.NReturn > 0) { ApqSession.User = stReturn.FNReturn as DataTable; } ApqSession.LoginTime = DateTime.Now; return(stReturn); }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn Dinner_Restaurant_List() { Apq.STReturn stReturn = new Apq.STReturn(); DinnerSession ApqSession = new DinnerSession(Session); if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession)) { return stReturn; } DataSet ds = new DataSet(); DbConnection SqlConn = null; using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn)) { Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn); DbDataAdapter sda = dbch.CreateAdapter(); sda.SelectCommand.CommandText = "dbo.Dinner_Restaurant_List"; sda.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand); dch.AddParameter("rtn", 0, DbType.Int32); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; SqlConn.Open(); sda.Fill(ds); stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); stReturn.FNReturn = ds.Tables[0]; sda.Dispose(); SqlConn.Close(); } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml)] public Apq.STReturn Login_LoginName(string LoginName, string LoginPwd) { // 先清除已登录数据 Session.Clear(); Apq.STReturn stReturn = new Apq.STReturn(); DinnerSession ApqSession = new DinnerSession(Session); if (LoginPwd.Length < 1) { stReturn.NReturn = -1; stReturn.ExMsg = "密码不允许为空"; return(stReturn); } System.Security.Cryptography.SHA512 SHA512 = System.Security.Cryptography.SHA512.Create(); byte[] binLoginPwd = SHA512.ComputeHash(System.Text.Encoding.Unicode.GetBytes(LoginPwd)); stReturn = DBLogin(LoginName, binLoginPwd); // Session操作 if (stReturn.NReturn > 0) { // 登录成功 DataTable dt = stReturn.FNReturn as DataTable; Login_Session(ApqSession, dt); } return(stReturn); }
protected virtual Apq.STReturn CheckLogin() { // 登录检测 Apq.STReturn stReturn = new Apq.STReturn(); CheckLogin(ref stReturn, ApqSession); return stReturn; }
public Apq.STReturn Login_LoginNameFromCookie(string LoginName, string SqlLoginPwd) { // 先清除已登录数据 Session.Clear(); Apq.STReturn stReturn = new Apq.STReturn(); DinnerSession ApqSession = new DinnerSession(Session); if (SqlLoginPwd.Length < 63) { stReturn.NReturn = -1; stReturn.ExMsg = "密码不允许为空"; return(stReturn); } byte[] binLoginPwd = Apq.Data.SqlClient.Common.ParseSqlON <byte[]>(System.Data.SqlDbType.VarBinary, SqlLoginPwd) as byte[]; stReturn = DBLogin(LoginName, binLoginPwd); // Session操作 if (stReturn.NReturn > 0) { DataTable dt = stReturn.FNReturn as DataTable; Login_Session(ApqSession, dt); } return(stReturn); }
/// <summary> /// 自有QueryString参数说明:无 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { // 参数解析 int Pager_PageSize = Apq.Convert.ChangeType <int>(Request.QueryString["ps"], 20); int Pager_Page = Apq.Convert.ChangeType <int>(Request.QueryString["p"], 1); long UserID = Apq.Convert.ChangeType <long>(Request.QueryString["UserID"], 0); // 设置分页相关值 txtPager_PageSize.Text = Pager_PageSize.ToString(); txtPager_Page.Text = Pager_Page.ToString(); WS.Admin.WS1 ws = new dtxc.WS.Admin.WS1(); Apq.STReturn stReturn = ws.PayoutList(Pager_Page, Pager_PageSize, UserID, 0); if (stReturn.NReturn == 1) { rpt.DataSource = stReturn.FNReturn; //绑定对象 rpt.DataBind(); // 设置当前页数 txtPager_Page.Text = stReturn.POuts[0].ToString(); txtPager_PageCount.InnerText = Math.Ceiling(System.Convert.ToDouble(stReturn.POuts[1]) / Pager_PageSize).ToString(); } //绑定对象 }
public Apq.STReturn ApqUser_Login(int UserSrc, string UserName) { Apq.STReturn stReturn = new Apq.STReturn(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlCommand sc = new SqlCommand("dbo.ApqUser_Login", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("UserSrc", UserSrc, DbType.Int32); dch.AddParameter("UserName", UserName); dch.AddParameter("UserID", 0, DbType.Int64); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sc.Parameters["UserID"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = Apq.Convert.ChangeType <string>(sc.Parameters["ExMsg"].Value); stReturn.POuts.Add(sc.Parameters["UserID"].Value); } return(stReturn); }
public Apq.STReturn ApqUser_Login(int UserSrc, string UserName) { Apq.STReturn stReturn = new Apq.STReturn(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlCommand sc = new SqlCommand("dbo.ApqUser_Login", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("UserSrc", UserSrc, DbType.Int32); dch.AddParameter("UserName", UserName); dch.AddParameter("UserID", 0, DbType.Int64); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sc.Parameters["UserID"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = Apq.Convert.ChangeType<string>(sc.Parameters["ExMsg"].Value); stReturn.POuts.Add(sc.Parameters["UserID"].Value); } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn UserEditLoginPwd(string LoginPwd_C, string LoginPwd) { Apq.STReturn stReturn = new Apq.STReturn(); DinnerSession ApqSession = new DinnerSession(Session); if (!CheckLoginPage.CheckLogin(ref stReturn, ApqSession)) { return(stReturn); } // 检测旧密码 System.Security.Cryptography.SHA512 SHA512 = System.Security.Cryptography.SHA512.Create(); byte[] binLoginPwd_C = SHA512.ComputeHash(System.Text.Encoding.Unicode.GetBytes(LoginPwd_C)); string SqlLoginPwd_C = Apq.Data.SqlClient.Common.ConvertToSqlON(binLoginPwd_C); string SqlLoginPwd_DB = Apq.Data.SqlClient.Common.ConvertToSqlON(ApqSession.ApqLogin.LoginPwd); if (SqlLoginPwd_C != SqlLoginPwd_DB) { stReturn.NReturn = -1; stReturn.ExMsg = "原密码输入错误"; return(stReturn); } byte[] binLoginPwd = SHA512.ComputeHash(System.Text.Encoding.Unicode.GetBytes(LoginPwd)); DbConnection SqlConn = null; using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn)) { Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn); DbCommand sc = SqlConn.CreateCommand(); sc.CommandText = "dbo.Dinner_User_UpdateLoginPwd"; sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("LoginID", ApqSession.ApqLogin.LoginID); dch.AddParameter("LoginPwd", binLoginPwd); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString(); sc.Dispose(); SqlConn.Close(); } // 更新Session中的密码信息 ApqSession.ApqLogin.LoginPwd = binLoginPwd; // 返回客户端 stReturn.FNReturn = Apq.Data.SqlClient.Common.ConvertToSqlON(binLoginPwd); return(stReturn); }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml)] public Apq.STReturn Login_LoginName(string LoginName, string LoginPwd) { // 先清除已登录数据 Session.Clear(); Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (LoginPwd.Length < 1) { stReturn.NReturn = -1; stReturn.ExMsg = "密码不允许为空"; return(stReturn); } System.Security.Cryptography.SHA512 SHA512 = System.Security.Cryptography.SHA512.Create(); byte[] binLoginPwd = SHA512.ComputeHash(System.Text.Encoding.Unicode.GetBytes(LoginPwd)); stReturn = DBLogin(LoginName, binLoginPwd); // Session操作 if (stReturn.NReturn > 0) { ApqSession.User = stReturn.FNReturn as DataTable; } ApqSession.LoginTime = DateTime.Now; return(stReturn); }
/// <summary> /// 自有QueryString参数说明: /// Status:{0:普通,1:已审核,2:已结算,3:已作废,10000:已删除} /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { // 参数解析 int Pager_PageSize = Apq.Convert.ChangeType <int>(Request.QueryString["ps"], 20); int Pager_Page = Apq.Convert.ChangeType <int>(Request.QueryString["p"], 1); int[] Status = { 0, 1, 2, 3 }; if (Request.QueryString["Status"] != null && Request.QueryString["Status"].Length > 0) { string[] aryStatus = Request.QueryString["Status"].Split(','); Status = new int[aryStatus.Length]; for (int i = 0; i < Status.Length; i++) { Status[i] = Apq.Convert.ChangeType <int>(aryStatus[i], 1); } } // 设置分页相关值 txtPager_PageSize.Text = Pager_PageSize.ToString(); txtPager_Page.Text = Pager_Page.ToString(); WS.Admin.WS1 ws = new dtxc.WS.Admin.WS1(); Apq.STReturn stReturn = ws.TaskList(Pager_Page, Pager_PageSize, Status); if (stReturn.NReturn == 1) { rpt.DataSource = stReturn.FNReturn; //绑定对象 rpt.DataBind(); // 设置当前页数 txtPager_Page.Text = stReturn.POuts[0].ToString(); txtPager_PageCount.InnerText = Math.Ceiling(System.Convert.ToDouble(stReturn.POuts[1]) / Pager_PageSize).ToString(); } }
protected override Apq.STReturn CheckLogin() { // 密码过期 Apq.STReturn stReturn = new Apq.STReturn(); CheckPwdExpire(ref stReturn, ApqSession); return stReturn; }
protected virtual Apq.STReturn CheckLogin() { // 登录检测 Apq.STReturn stReturn = new Apq.STReturn(); CheckLogin(ref stReturn, ApqSession); return(stReturn); }
protected override Apq.STReturn CheckLogin() { // 管理员检测 Apq.STReturn stReturn = new Apq.STReturn(); CheckAdmin(ref stReturn, ApqSession); return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn TaskAdd(string TaskName, string TaskContent, DateTime BTime, DateTime ETime, long AddinID, decimal Price, decimal ParentPrice , bool NeedChangeIP, bool IsAutoStart, decimal TaskMoney) { Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckPwdExpire(ref stReturn, ApqSession)) { return(stReturn); } long UserID = System.Convert.ToInt64(ApqSession.User.Rows[0]["UserID"]); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { SqlCommand sc = new SqlCommand("dtxc.Apq_Task_Insert", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("_OperID", UserID); dch.AddParameter("_OpTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); IPAddress ipa; if (IPAddress.TryParse(HttpContext.Current.Request.UserHostAddress, out ipa)) { dch.AddParameter("_OperIP", ipa.GetAddressBytes()); } dch.AddParameter("TaskName", TaskName); dch.AddParameter("TaskContent", TaskContent); dch.AddParameter("BTime", BTime); dch.AddParameter("ETime", ETime); dch.AddParameter("AddinID", AddinID); dch.AddParameter("Price", Price); dch.AddParameter("ParentPrice", ParentPrice); dch.AddParameter("NeedChangeIP", NeedChangeIP); dch.AddParameter("IsAutoStart", IsAutoStart); dch.AddParameter("TaskMoney", TaskMoney); dch.AddParameter("TaskID", 0); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sc.Parameters["TaskID"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString(); stReturn.POuts = new object[] { sc.Parameters["TaskID"].Value }; sc.Dispose(); SqlConn.Close(); } return(stReturn); }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn TaskListSelf(int start, int limit, int[] Status) { Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckPwdExpire(ref stReturn, ApqSession)) { return(stReturn); } DataSet ds = new DataSet(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { DataTable dtStatus = new DataTable(); dtStatus.Columns.Add("ID", typeof(int)); foreach (int i in Status) { dtStatus.Rows.Add(i); } SqlDataAdapter sda = new SqlDataAdapter("dtxc.Apq_Task_ListSelf", SqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("Pager_Page", start / limit + 1, DbType.Int32); dch.AddParameter("Pager_PageSize", limit); dch.AddParameter("Pager_RowCount", 0, DbType.Int32); dch.AddParameter("UserID", ApqSession.UserID); sda.SelectCommand.Parameters.Add("Status", SqlDbType.Structured); sda.SelectCommand.Parameters["Status"].TypeName = "tvp:t_int"; sda.SelectCommand.Parameters["Status"].Value = dtStatus; sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sda.SelectCommand.Parameters["Pager_Page"].Direction = ParameterDirection.InputOutput; sda.SelectCommand.Parameters["Pager_RowCount"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sda.Fill(ds); stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString(); stReturn.FNReturn = ds.Tables[0]; stReturn.POuts = new object[] { sda.SelectCommand.Parameters["Pager_Page"].Value, sda.SelectCommand.Parameters["Pager_RowCount"].Value }; sda.Dispose(); SqlConn.Close(); } return(stReturn); }
/// <summary> /// 获取菜单 /// </summary> //[WebMethod(EnableSession = true, Description = "获取Xml表示的菜单")] //[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn GetXmlMenu() { Apq.STReturn stReturn = new Apq.STReturn(); stReturn.NReturn = 1; stReturn.ExMsg = "登出成功"; return stReturn; }
/// <summary> /// 获取菜单 /// </summary> //[WebMethod(EnableSession = true, Description = "获取Xml表示的菜单")] //[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn GetXmlMenu() { Apq.STReturn stReturn = new Apq.STReturn(); stReturn.NReturn = 1; stReturn.ExMsg = "登出成功"; return(stReturn); }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn UserEditSelf(long UserID, string Name, short Sex, string PhotoUrl, DateTime Birthday , string IDCard, string Alipay) { Apq.STReturn stReturn = new Apq.STReturn(); DinnerSession ApqSession = new DinnerSession(Session); if (!CheckLoginPage.CheckPwdExpire(ref stReturn, ApqSession)) { return(stReturn); } DbConnection SqlConn = null; using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn)) { Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn); DbCommand sc = SqlConn.CreateCommand(); sc.CommandText = "Dinner.Dinner_User_UpdateSelf"; sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("_OperID", ApqSession); dch.AddParameter("_OpTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); IPAddress ipa; if (IPAddress.TryParse(HttpContext.Current.Request.UserHostAddress, out ipa)) { dch.AddParameter("_OperIP", ipa.GetAddressBytes()); } dch.AddParameter("UserID", UserID); dch.AddParameter("Name", Name); dch.AddParameter("Sex", Sex); dch.AddParameter("PhotoUrl", PhotoUrl); //dch.AddParameter("Expire", Expire.ToString("yyyy-MM-dd HH:mm:ss.fff")); //dch.AddParameter("Status", Status); //dch.AddParameter("IsAdmin", IsAdmin); dch.AddParameter("Birthday", Birthday); dch.AddParameter("IDCard", IDCard); dch.AddParameter("Alipay", Alipay); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString(); sc.Dispose(); SqlConn.Close(); } return(stReturn); }
protected void Page_Load(object sender, EventArgs e) { //绑定对象 //默认值 string m = Request.QueryString["m"]; switch (m) { //添加 case "a": case "A": break; //查看 //修改 default: //获取数据 using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { Apq.STReturn stReturn = new Apq.STReturn(); SqlDataAdapter sda = new SqlDataAdapter("dtxc.Apq_Users_ListOne", SqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("UserID", ApqSession.UserID); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sda.Fill(ds); stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString(); stReturn.FNReturn = ds.Tables[0]; sda.Dispose(); SqlConn.Close(); } if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { //页面赋值 txtBalanceMoney.InnerText = ds.Tables[0].Rows[0]["BalanceMoney"].ToString(); } break; } //设置只读 if (m == "v" || m == "V") { } }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn UserEditSelf(long UserID, string Name, short Sex, string PhotoUrl, DateTime Birthday , string IDCard, string Alipay) { Apq.STReturn stReturn = new Apq.STReturn(); DinnerSession ApqSession = new DinnerSession(Session); if (!CheckLoginPage.CheckPwdExpire(ref stReturn, ApqSession)) { return stReturn; } DbConnection SqlConn = null; using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn)) { Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn); DbCommand sc = SqlConn.CreateCommand(); sc.CommandText = "Dinner.Dinner_User_UpdateSelf"; sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("_OperID", ApqSession); dch.AddParameter("_OpTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); IPAddress ipa; if (IPAddress.TryParse(HttpContext.Current.Request.UserHostAddress, out ipa)) { dch.AddParameter("_OperIP", ipa.GetAddressBytes()); } dch.AddParameter("UserID", UserID); dch.AddParameter("Name", Name); dch.AddParameter("Sex", Sex); dch.AddParameter("PhotoUrl", PhotoUrl); //dch.AddParameter("Expire", Expire.ToString("yyyy-MM-dd HH:mm:ss.fff")); //dch.AddParameter("Status", Status); //dch.AddParameter("IsAdmin", IsAdmin); dch.AddParameter("Birthday", Birthday); dch.AddParameter("IDCard", IDCard); dch.AddParameter("Alipay", Alipay); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString(); sc.Dispose(); SqlConn.Close(); } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn UserEdit(long UserID, string Name, string UserName, string LoginPwd, short Sex, string PhotoUrl, DateTime Expire, bool Status , bool IsAdmin, DateTime Birthday, int UserType, string IDCard, string Alipay) { Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession)) { return(stReturn); } using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { SqlCommand sc = new SqlCommand("dtxc.dtxc_Users_Update", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("_OperID", ApqSession.UserID); dch.AddParameter("_OpTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); IPAddress ipa; if (IPAddress.TryParse(HttpContext.Current.Request.UserHostAddress, out ipa)) { dch.AddParameter("_OperIP", ipa.GetAddressBytes()); } dch.AddParameter("UserID", UserID); dch.AddParameter("Name", Name); dch.AddParameter("UserName", UserName); dch.AddParameter("LoginPwd", LoginPwd); dch.AddParameter("Sex", Sex); dch.AddParameter("PhotoUrl", PhotoUrl); dch.AddParameter("Expire", Expire.ToString("yyyy-MM-dd HH:mm:ss.fff")); dch.AddParameter("Status", Status); dch.AddParameter("IsAdmin", IsAdmin); dch.AddParameter("UserType", UserType); dch.AddParameter("Birthday", Birthday); dch.AddParameter("IDCard", IDCard); dch.AddParameter("Alipay", Alipay); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString(); sc.Dispose(); SqlConn.Close(); } return(stReturn); }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn Dinner_Admin_EmDinner_ListPager(int start, int limit, DateTime BTime, DateTime ETime, long RestID, bool IsDoDinner) { int Pager_Page = start / limit; int Pager_PageSize = limit; Apq.STReturn stReturn = new Apq.STReturn(); DinnerSession ApqSession = new DinnerSession(Session); if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession)) { return(stReturn); } DataSet ds = new DataSet(); DbConnection SqlConn = null; using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn)) { Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn); DbDataAdapter sda = dbch.CreateAdapter(); sda.SelectCommand.CommandText = "dbo.Dinner_Admin_EmDinner_ListPager"; sda.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand); dch.AddParameter("rtn", 0, DbType.Int32); //dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("Pager_Page", Pager_Page, DbType.Int32); dch.AddParameter("Pager_PageSize", Pager_PageSize); dch.AddParameter("Pager_RowCount", 0, DbType.Int32); dch.AddParameter("BTime", BTime); dch.AddParameter("ETime", ETime); dch.AddParameter("RestID", RestID); dch.AddParameter("State", IsDoDinner); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; //sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sda.SelectCommand.Parameters["Pager_RowCount"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sda.Fill(ds); stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); //stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString(); stReturn.FNReturn = ds.Tables[0]; stReturn.POuts.Add(sda.SelectCommand.Parameters["Pager_Page"].Value); stReturn.POuts.Add(sda.SelectCommand.Parameters["Pager_RowCount"].Value); sda.Dispose(); SqlConn.Close(); } return(stReturn); }
protected override void OnPreInit(EventArgs e) { base.OnPreInit(e); Apq.STReturn stReturn = new Apq.STReturn(); if (!CheckLoginPage.CheckLogin(ref stReturn, ApqSession)) { urlLogin = "******"; } }
/// <summary> /// 检测是否登录 /// </summary> /// <param name="stReturn"></param> public static bool CheckLogin(ref Apq.STReturn stReturn, Apq.Web.SessionState.HttpSessionState ApqSession) { if (ApqSession.User == null || ApqSession.User.Rows.Count == 0) { stReturn.NReturn = -1; stReturn.ExMsg = "请登录"; return(false); } return(true); }
/// <summary> /// 检测是否管理员 /// </summary> /// <param name="stReturn"></param> public static bool CheckAdmin(ref Apq.STReturn stReturn, Apq.Web.SessionState.HttpSessionState ApqSession) { if (!ApqSession.IsAdmin) { stReturn.NReturn = -1; stReturn.ExMsg = "只有管理员才能访问该页面"; return(false); } return(true); }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml)] public Apq.STReturn Logout() { Apq.STReturn stReturn = new Apq.STReturn(); // 结束会话 Session.Abandon(); stReturn.NReturn = 1; stReturn.ExMsg = "登出成功"; return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml)] public Apq.STReturn Logout() { Apq.STReturn stReturn = new Apq.STReturn(); // 结束会话 Session.Abandon(); stReturn.NReturn = 1; stReturn.ExMsg = "登出成功"; return(stReturn); }
public static bool CheckPwdExpire(ref Apq.STReturn stReturn, Apq.Web.SessionState.HttpSessionState ApqSession) { /* * if (Convert.ToDateTime(ApqSession.User.Rows[0]["LoginPwdExpire"]) > DateTime.Now) * { * stReturn.NReturn = -1 * stReturn.ExMsg = "密码已过期,请修改密码"; * return false; * } */ return(true); }
protected override void OnPreInit(EventArgs e) { base.OnPreInit(e); // 密码过期 Apq.STReturn stReturn = new Apq.STReturn(); if (!CheckPwdExpire(ref stReturn, ApqSession)) { LoginDirectMsg = "密码已过期,请修改密码"; urlLogin = "******"; } }
protected override void OnInit(EventArgs e) { base.OnInit(e); // 登录检测 Apq.STReturn stReturn = CheckLogin(); if (stReturn.NReturn != 1) { string strJS = "Ext.Msg.alert(\"错误\",\"" + stReturn.ExMsg + "\",function(){ top.location = \"" + stReturn.POuts[0] + "\"; });"; ClientScript.RegisterStartupScript(this.GetType(), "scDinner_CheckLoginPage", strJS, true); } }
protected override void OnPreInit(EventArgs e) { base.OnPreInit(e); // 非管理员提示后跳转到会员首页 Apq.STReturn stReturn = new Apq.STReturn(); if (!CheckAdmin(ref stReturn, ApqSession)) { LoginDirectMsg = "您不是管理员,请访问会员页面"; urlLogin = "******"; } }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn AddinAdd(string AddinName, string AddinUrl, string AddinDescript) { Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession)) { return(stReturn); } long UserID = System.Convert.ToInt64(ApqSession.User.Rows[0]["UserID"]); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { SqlCommand sc = new SqlCommand("dtxc.Apq_Addin_Insert", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("_OperID", UserID); dch.AddParameter("_OpTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); IPAddress ipa; if (IPAddress.TryParse(HttpContext.Current.Request.UserHostAddress, out ipa)) { dch.AddParameter("_OperIP", ipa.GetAddressBytes()); } dch.AddParameter("AddinName", AddinName); dch.AddParameter("AddinUrl", AddinUrl); dch.AddParameter("AddinDescript", AddinDescript); dch.AddParameter("AddinID", 0); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sc.Parameters["AddinID"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString(); stReturn.POuts = new object[] { sc.Parameters["AddinID"].Value }; sc.Dispose(); SqlConn.Close(); } return(stReturn); }
/// <summary> /// 检测是否登录 /// </summary> /// <param name="stReturn"></param> public static bool CheckLogin(ref Apq.STReturn stReturn, DinnerSession ApqSession) { if (ApqSession.Employee.EmID == 0) { stReturn.NReturn = -1; stReturn.ExMsg = "请登录"; stReturn.POuts.Add("Login.aspx"); return(false); } stReturn.NReturn = 1; return(true); }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn UsersListChild(int Pager_Page, int Pager_PageSize, long UserID, bool ContainsSelf, bool ContainsGrand) { Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession)) { return(stReturn); } DataSet ds = new DataSet(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlDataAdapter sda = new SqlDataAdapter("dtxc.Apq_Users_ListChild", SqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("Pager_Page", Pager_Page, DbType.Int32); dch.AddParameter("Pager_PageSize", Pager_PageSize); dch.AddParameter("Pager_RowCount", 0, DbType.Int32); dch.AddParameter("UserID", UserID); dch.AddParameter("ContainsSelf", ContainsSelf); dch.AddParameter("ContainsGrand", ContainsGrand); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sda.SelectCommand.Parameters["Pager_Page"].Direction = ParameterDirection.InputOutput; sda.SelectCommand.Parameters["Pager_RowCount"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sda.Fill(ds); stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString(); stReturn.FNReturn = ds.Tables[0]; stReturn.POuts = new object[] { sda.SelectCommand.Parameters["Pager_Page"].Value, sda.SelectCommand.Parameters["Pager_RowCount"].Value }; sda.Dispose(); SqlConn.Close(); } return(stReturn); }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn AddinList(int start, int limit, short IsLookup, long LookupID) { Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession)) { return stReturn; } DataSet ds = new DataSet(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { SqlDataAdapter sda = new SqlDataAdapter("dtxc.Apq_Addin_List", SqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("Pager_Page", start / limit + 1, DbType.Int32); dch.AddParameter("Pager_PageSize", limit); dch.AddParameter("Pager_RowCount", 0, DbType.Int32); dch.AddParameter("IsLookup", IsLookup, DbType.Int16); dch.AddParameter("LookupID", LookupID); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sda.SelectCommand.Parameters["Pager_Page"].Direction = ParameterDirection.InputOutput; sda.SelectCommand.Parameters["Pager_RowCount"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sda.Fill(ds); stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString(); stReturn.FNReturn = ds.Tables[0]; stReturn.POuts = new object[]{ sda.SelectCommand.Parameters["Pager_Page"].Value, sda.SelectCommand.Parameters["Pager_RowCount"].Value }; sda.Dispose(); SqlConn.Close(); } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn TaskListCanTake(int Pager_Page, int Pager_PageSize) { Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckPwdExpire(ref stReturn, ApqSession)) { return stReturn; } DataSet ds = new DataSet(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { SqlDataAdapter sda = new SqlDataAdapter("dtxc.Apq_Task_ListCanTake", SqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("Pager_Page", Pager_Page, DbType.Int32); dch.AddParameter("Pager_PageSize", Pager_PageSize); dch.AddParameter("Pager_RowCount", 0, DbType.Int32); dch.AddParameter("UserID", ApqSession.UserID); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sda.SelectCommand.Parameters["Pager_Page"].Direction = ParameterDirection.InputOutput; sda.SelectCommand.Parameters["Pager_RowCount"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sda.Fill(ds); stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString(); stReturn.FNReturn = ds.Tables[0]; stReturn.POuts = new object[]{ sda.SelectCommand.Parameters["Pager_Page"].Value, sda.SelectCommand.Parameters["Pager_RowCount"].Value }; sda.Dispose(); SqlConn.Close(); } return stReturn; }
protected override void OnPreInit(EventArgs e) { base.OnPreInit(e); // 非管理员提示后跳转到后台登录页面 Apq.STReturn stReturn = new Apq.STReturn(); if (!CheckAdmin(ref stReturn, ApqSession)) { string strUrlLogin = VirtualPathUtility.ToAbsolute("~/Login.aspx", Request.ApplicationPath); ClientScript.RegisterStartupScript(this.GetType(), "scGlobal_CheckAdminPage", string.Format(@" alert(""{0}""); top.location = ""{1}""; ", stReturn.ExMsg, strUrlLogin), true); } }
protected override void OnInit(EventArgs e) { base.OnInit(e); // 未登录 Apq.STReturn stReturn = new Apq.STReturn(); if (!CheckLogin(ref stReturn, ApqSession)) { LoginDirectMsg = "请登录"; urlLogin = "******"; ClientScript.RegisterStartupScript(this.GetType(), "scdtxc_CheckLoginPage", string.Format(@" alert(""{0}""); top.location = ""{1}""; ", LoginDirectMsg, urlLogin), true); } }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn NewsList(int Pager_Page, int Pager_PageSize) { Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); //if (!CheckLogin(ref stReturn, ApqSession)) //{ // return stReturn; //} DataSet ds = new DataSet(); long UserID = System.Convert.ToInt64(ApqSession.User.Rows[0]["UserID"]); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlDataAdapter sda = new SqlDataAdapter("dtxc.News_List", SqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("Pager_Page", Pager_Page); dch.AddParameter("Pager_PageSize", Pager_PageSize); dch.AddParameter("Pager_RowCount", 0, DbType.Int32); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sda.SelectCommand.Parameters["Pager_RowCount"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sda.Fill(ds); stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString(); stReturn.FNReturn = ds.Tables[0]; stReturn.POuts = new object[]{ sda.SelectCommand.Parameters["Pager_RowCount"].Value }; sda.Dispose(); SqlConn.Close(); } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn Dinner_Restaurant_Save(long RestID, string RestName, string RestAddr) { Apq.STReturn stReturn = new Apq.STReturn(); DinnerSession ApqSession = new DinnerSession(Session); if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession)) { return stReturn; } DbConnection SqlConn = null; using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn)) { Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn); DbCommand sc = SqlConn.CreateCommand(); sc.CommandText = "dbo.Dinner_Restaurant_Save"; sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("RestID", RestID); dch.AddParameter("RestName", RestName); dch.AddParameter("RestAddr", RestAddr); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sc.Parameters["RestID"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = Apq.Convert.ChangeType<string>(sc.Parameters["ExMsg"].Value); stReturn.POuts.Add(sc.Parameters["RestID"]); sc.Dispose(); SqlConn.Close(); } return stReturn; }
public static Apq.STReturn Regist(string LoginName, string LoginPwd, string Introducer) { string CryptPwd = Apq.Security.Cryptography.DESHelper.EncryptString(LoginPwd, DES.Key, DES.IV); IPAddress ipa; IPAddress.TryParse(HttpContext.Current.Request.UserHostAddress, out ipa); pdbp.WS.Login Lg = new pdbp.WS.Login(); pdbp.WS.STReturn stReturnWS = Lg.WS_Reg(LoginName, CryptPwd, ipa.GetAddressBytes(), Introducer); Apq.STReturn stReturn = new Apq.STReturn(); stReturn.NReturn = stReturnWS.NReturn; stReturn.FNReturn = stReturnWS.FNReturn; stReturn.ExMsg = stReturnWS.ExMsg; stReturn.POuts.AddRange(stReturnWS.POuts); if (stReturn.NReturn == 1) { // 注册成功,自动登录 wsLogin wsLogin = new wsLogin(); wsLogin.Login_LoginName(LoginName, LoginPwd); } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn Dinner_EmDinner_ListPager(int start, int limit) { int Pager_Page = start / limit; int Pager_PageSize = limit; Apq.STReturn stReturn = new Apq.STReturn(); DinnerSession ApqSession = new DinnerSession(Session); if (!CheckLoginPage.CheckLogin(ref stReturn, ApqSession)) { return stReturn; } DataSet ds = new DataSet(); DbConnection SqlConn = null; using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn)) { Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn); DbDataAdapter sda = dbch.CreateAdapter(); sda.SelectCommand.CommandText = "dbo.Dinner_EmDinner_ListPager"; sda.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand); dch.AddParameter("rtn", 0, DbType.Int32); //dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("Pager_Page", Pager_Page, DbType.Int32); dch.AddParameter("Pager_PageSize", Pager_PageSize); dch.AddParameter("Pager_RowCount", 0, DbType.Int32); dch.AddParameter("EmID", ApqSession.Employee.EmID); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; //sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sda.SelectCommand.Parameters["Pager_RowCount"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sda.Fill(ds); stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); //stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString(); stReturn.FNReturn = ds.Tables[0]; stReturn.POuts.Add(sda.SelectCommand.Parameters["Pager_Page"].Value); stReturn.POuts.Add(sda.SelectCommand.Parameters["Pager_RowCount"].Value); sda.Dispose(); SqlConn.Close(); } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn AddinListOne(long AddinID) { Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession)) { return stReturn; } DataSet ds = new DataSet(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { SqlDataAdapter sda = new SqlDataAdapter("dtxc.Apq_Addin_ListOne", SqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("AddinID", AddinID); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sda.Fill(ds); stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString(); stReturn.FNReturn = ds.Tables[0]; sda.Dispose(); SqlConn.Close(); } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn dtxc_User_Toggle(long UserID) { Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession)) { return stReturn; } long _OperID = System.Convert.ToInt64(ApqSession.User.Rows[0]["UserID"]); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { SqlCommand sc = new SqlCommand("dtxc.dtxc_User_Toggle", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("_OperID", _OperID); dch.AddParameter("_OpTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); IPAddress ipa; if (IPAddress.TryParse(HttpContext.Current.Request.UserHostAddress, out ipa)) { dch.AddParameter("_OperIP", ipa.GetAddressBytes()); } dch.AddParameter("UserID", UserID); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString(); sc.Dispose(); SqlConn.Close(); } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn UserEdit(long UserID, string Name, string UserName, string LoginPwd, short Sex, string PhotoUrl, DateTime Expire, bool Status , bool IsAdmin, DateTime Birthday, int UserType, string IDCard, string Alipay) { Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession)) { return stReturn; } using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { SqlCommand sc = new SqlCommand("dtxc.dtxc_Users_Update", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("_OperID", ApqSession.UserID); dch.AddParameter("_OpTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); IPAddress ipa; if (IPAddress.TryParse(HttpContext.Current.Request.UserHostAddress, out ipa)) { dch.AddParameter("_OperIP", ipa.GetAddressBytes()); } dch.AddParameter("UserID", UserID); dch.AddParameter("Name", Name); dch.AddParameter("UserName", UserName); dch.AddParameter("LoginPwd", LoginPwd); dch.AddParameter("Sex", Sex); dch.AddParameter("PhotoUrl", PhotoUrl); dch.AddParameter("Expire", Expire.ToString("yyyy-MM-dd HH:mm:ss.fff")); dch.AddParameter("Status", Status); dch.AddParameter("IsAdmin", IsAdmin); dch.AddParameter("UserType", UserType); dch.AddParameter("Birthday", Birthday); dch.AddParameter("IDCard", IDCard); dch.AddParameter("Alipay", Alipay); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString(); sc.Dispose(); SqlConn.Close(); } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn dtxc_Reg_UserName(string UserName, string LoginName, string LoginPwd, short Sex, string PhotoUrl, long IntroUserID, string Alipay, int UserType , DateTime Birthday, string IDCard, string IDCard_Name, short IDCard_Sex, string IDCard_PhotoUrl) { Apq.STReturn stReturn = new Apq.STReturn(); if (LoginPwd.Length < 1) { stReturn.NReturn = -1; stReturn.ExMsg = "密码不允许为空"; return stReturn; } System.Security.Cryptography.SHA512 SHA512 = System.Security.Cryptography.SHA512.Create(); byte[] binLoginPwd = SHA512.ComputeHash(System.Text.Encoding.Unicode.GetBytes(LoginPwd)); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlCommand sc = new SqlCommand("dbo.WS_Reg", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); IPAddress ipa; if (IPAddress.TryParse(HttpContext.Current.Request.UserHostAddress, out ipa)) { dch.AddParameter("RegIP", ipa.GetAddressBytes()); } dch.AddParameter("UserName", UserName); dch.AddParameter("LoginName", LoginName); dch.AddParameter("LoginPwd", binLoginPwd); dch.AddParameter("Sex", Sex); dch.AddParameter("PhotoUrl", PhotoUrl); dch.AddParameter("Birthday", Birthday.ToString("yyyy-MM-dd HH:mm:ss.fff")); dch.AddParameter("Alipay", Alipay); dch.AddParameter("IntroUserID", IntroUserID); dch.AddParameter("UserType", UserType); dch.AddParameter("Expire", DateTime.Now.AddYears(10).ToString("yyyy-MM-dd HH:mm:ss.fff")); dch.AddParameter("IDCard", IDCard); dch.AddParameter("IDCard_Name", IDCard_Name); dch.AddParameter("IDCard_Sex", IDCard_Sex); dch.AddParameter("IDCard_PhotoUrl", IDCard_PhotoUrl); dch.AddParameter("UserID", 0, DbType.Int64); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sc.Parameters["UserID"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = Apq.Convert.ChangeType<string>(sc.Parameters["ExMsg"].Value); stReturn.POuts.Add(sc.Parameters["UserID"].Value); sc.Dispose(); SqlConn.Close(); } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn TaskList(int Pager_Page, int Pager_PageSize, int[] Status) { Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession)) { return stReturn; } DataSet ds = new DataSet(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { DataTable dtStatus = new DataTable(); dtStatus.Columns.Add("ID", typeof(int)); foreach (int i in Status) { dtStatus.Rows.Add(i); } SqlDataAdapter sda = new SqlDataAdapter("dtxc.Apq_Task_List", SqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("Pager_Page", Pager_Page, DbType.Int32); dch.AddParameter("Pager_PageSize", Pager_PageSize); dch.AddParameter("Pager_RowCount", 0, DbType.Int32); sda.SelectCommand.Parameters.Add("Status", SqlDbType.Structured); sda.SelectCommand.Parameters["Status"].TypeName = "tvp:t_int"; sda.SelectCommand.Parameters["Status"].Value = dtStatus; sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sda.SelectCommand.Parameters["Pager_Page"].Direction = ParameterDirection.InputOutput; sda.SelectCommand.Parameters["Pager_RowCount"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sda.Fill(ds); stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString(); stReturn.FNReturn = ds.Tables[0]; stReturn.POuts = new object[]{ sda.SelectCommand.Parameters["Pager_Page"].Value, sda.SelectCommand.Parameters["Pager_RowCount"].Value }; sda.Dispose(); SqlConn.Close(); } return stReturn; }
public Apq.STReturn Login_LoginNameFromCookie(string LoginName, string CryptLoginPwd) { Apq.STReturn stReturn = new Apq.STReturn(); if (CryptLoginPwd.Length < 1) { stReturn.NReturn = -1; stReturn.ExMsg = "密码不允许为空"; return stReturn; } using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlCommand sc = new SqlCommand("dbo.WS_Login", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("LoginName", LoginName); dch.AddParameter("LoginPwd", CryptLoginPwd); dch.AddParameter("UserID", 0, DbType.Int64); dch.AddParameter("IsAdmin", 0, DbType.Byte); dch.AddParameter("NickName", string.Empty, DbType.String, 50); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sc.Parameters["UserID"].Direction = ParameterDirection.InputOutput; sc.Parameters["IsAdmin"].Direction = ParameterDirection.InputOutput; sc.Parameters["NickName"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = Apq.Convert.ChangeType<string>(sc.Parameters["ExMsg"].Value); stReturn.POuts.Add(sc.Parameters["UserID"].Value); //POuts[0]:UserID stReturn.POuts.Add(CryptLoginPwd); //POuts[1]:CryptLoginPwd stReturn.POuts.Add(sc.Parameters["NickName"].Value);//POuts[2]:NickName stReturn.POuts.Add(sc.Parameters["IsAdmin"].Value);//POuts[3]:IsAdmin } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn UserEditLoginPwd(string LoginPwd_C, string LoginPwd) { Apq.STReturn stReturn = new Apq.STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckLogin(ref stReturn, ApqSession)) { return stReturn; } // 检测旧密码 System.Security.Cryptography.SHA512 SHA512 = System.Security.Cryptography.SHA512.Create(); byte[] binLoginPwd_C = SHA512.ComputeHash(System.Text.Encoding.Unicode.GetBytes(LoginPwd_C)); string SqlLoginPwd_C = Apq.Data.SqlClient.Common.ConvertToSqlON(binLoginPwd_C); string SqlLoginPwd_DB = Apq.Data.SqlClient.Common.ConvertToSqlON(ApqSession.User.Rows[0]["LoginPwd"]); if (SqlLoginPwd_C != SqlLoginPwd_DB) { stReturn.NReturn = -1; stReturn.ExMsg = "原密码输入错误"; return stReturn; } byte[] binLoginPwd = SHA512.ComputeHash(System.Text.Encoding.Unicode.GetBytes(LoginPwd)); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { SqlCommand sc = new SqlCommand("dtxc.dtxc_User_UpdateLoginPwd", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("_OperID", ApqSession.UserID); dch.AddParameter("_OpTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); IPAddress ipa; if (IPAddress.TryParse(HttpContext.Current.Request.UserHostAddress, out ipa)) { dch.AddParameter("_OperIP", ipa.GetAddressBytes()); } dch.AddParameter("UserID", ApqSession.UserID); dch.AddParameter("LoginPwd", binLoginPwd); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString(); sc.Dispose(); SqlConn.Close(); } // 更新Session中的密码信息 ApqSession.User.Rows[0]["LoginPwd"] = binLoginPwd; // 返回客户端 stReturn.FNReturn = Apq.Data.SqlClient.Common.ConvertToSqlON(binLoginPwd); return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn Dinner_EmDinner_Delete(long ID) { Apq.STReturn stReturn = new Apq.STReturn(); DinnerSession ApqSession = new DinnerSession(Session); if (!CheckLoginPage.CheckLogin(ref stReturn, ApqSession)) { return stReturn; } DataSet ds = new DataSet(); DbConnection SqlConn = null; using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn)) { Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn); DbCommand sc = SqlConn.CreateCommand(); sc.CommandText = "dbo.Dinner_EmDinner_Delete"; sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("ID", ID); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString(); sc.Dispose(); SqlConn.Close(); } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn WS_Reg(string LoginName, string LoginPwd, byte[] Ipa, string Introducer) { Apq.STReturn stReturn = new Apq.STReturn(); if (LoginPwd.Length < 1) { stReturn.NReturn = -1; stReturn.ExMsg = "密码不允许为空"; return stReturn; } using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlCommand sc = new SqlCommand("dbo.WS_Reg", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("RegIP", Ipa, DbType.Binary); dch.AddParameter("LoginName", LoginName); dch.AddParameter("LoginPwd", LoginPwd); dch.AddParameter("Introducer", Introducer); dch.AddParameter("UserID", 0, DbType.Int64); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sc.Parameters["UserID"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.ExMsg = Apq.Convert.ChangeType<string>(sc.Parameters["ExMsg"].Value); stReturn.POuts.Add(sc.Parameters["UserID"].Value); sc.Dispose(); SqlConn.Close(); } return stReturn; }
protected void Page_Load(object sender, EventArgs e) { //绑定对象 //默认值 txtRegTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); txtExpire.Text = DateTime.Now.AddYears(1).ToString("yyyy-MM-dd"); string m = Request.QueryString["m"]; switch (m) { //添加 case "a": case "A": break; //查看 //修改 default: //获取数据 long UserID = System.Convert.ToInt64(Request.QueryString["UserID"]); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { Apq.STReturn stReturn = new Apq.STReturn(); SqlDataAdapter sda = new SqlDataAdapter("dtxc.Apq_Users_ListOne", SqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1); dch.AddParameter("UserID", UserID); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sda.Fill(ds); stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString(); stReturn.FNReturn = ds.Tables[0]; sda.Dispose(); SqlConn.Close(); } if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { //页面赋值 txtUserID.Text = ds.Tables[0].Rows[0]["UserID"].ToString(); txtUserName.Text = ds.Tables[0].Rows[0]["UserName"].ToString(); ddlSex.SelectedValue = ds.Tables[0].Rows[0]["Sex"].ToString(); cbStatus.Checked = !System.Convert.ToBoolean(ds.Tables[0].Rows[0]["Status"]); cbIsAdmin.Checked = System.Convert.ToBoolean(ds.Tables[0].Rows[0]["IsAdmin"]); txtAlipay.Text = ds.Tables[0].Rows[0]["Alipay"].ToString(); if (!System.Convert.IsDBNull(ds.Tables[0].Rows[0]["Birthday"])) txtBirthday.Text = System.Convert.ToDateTime(ds.Tables[0].Rows[0]["Birthday"]).ToString("yyyy-MM-dd"); txtExpire.Text = System.Convert.ToDateTime(ds.Tables[0].Rows[0]["Expire"]).ToString("yyyy-MM-dd"); txtRegTime.Text = System.Convert.ToDateTime(ds.Tables[0].Rows[0]["RegTime"]).ToString("yyyy-MM-dd"); txtIntroUserID.Text = ds.Tables[0].Rows[0]["IntroUserID"].ToString(); txtIDCard.Text = ds.Tables[0].Rows[0]["IDCard"].ToString(); } break; } //设置只读 if (m == "v" || m == "V") { txtUserID.Enabled = false; txtUserName.Enabled = false; ddlSex.Enabled = false; cbStatus.Enabled = false; cbIsAdmin.Enabled = false; txtAlipay.Enabled = false; txtBirthday.Enabled = false; txtExpire.Enabled = false; txtIntroUserID.Enabled = false; txtIDCard.Enabled = false; } }