/// <summary> /// 获取某个用户及其下级 /// </summary> /// <param name="NReturn"></param> /// <param name="ExMsg"></param> /// <param name="UserID">UserID</param> /// <param name="ContainsSelf">是否包含自己</param> /// <param name="ContainsGrand">是否包含子孙</param> /// <returns></returns> public static DataTable ListChild(ref int NReturn, ref string ExMsg, long UserID, bool ContainsSelf, bool ContainsGrand) { 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", ExMsg, DbType.String, -1); dch.AddParameter("UserID", UserID, DbType.Int64); dch.AddParameter("ContainsSelf", ContainsSelf, DbType.Byte); dch.AddParameter("ContainsGrand", ContainsGrand, DbType.Byte); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sda.Fill(ds); NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString(); sda.Dispose(); SqlConn.Close(); } return(ds.Tables.Count > 0 ? ds.Tables[0] : null); }
/// <summary> /// 上传文件 /// </summary> public void FileUp(string FullName, string DBFullName, byte[] bFile) { string FileName = System.IO.Path.GetFileName(FullName); string CFolder = System.IO.Path.GetDirectoryName(FullName); string DBFolder = System.IO.Path.GetDirectoryName(DBFullName); // 1.上传到数据库 Apq.Data.Common.DbConnectionHelper.Open(Connection); System.Data.Common.DbCommand sqlCmd = Connection.CreateCommand(); sqlCmd.CommandText = "Apq_FileTrans_Insert"; sqlCmd.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper cmdHelper = new Apq.Data.Common.DbCommandHelper(sqlCmd); cmdHelper.AddParameter("@FileName", FileName); cmdHelper.AddParameter("@DBFolder", DBFolder); cmdHelper.AddParameter("@CFolder", CFolder); cmdHelper.AddParameter("@FileStream", bFile); cmdHelper.AddParameter("@ID", 0); sqlCmd.Parameters["@ID"].Direction = ParameterDirection.InputOutput; sqlCmd.ExecuteNonQuery(); int ID = Apq.Convert.ChangeType<int>(sqlCmd.Parameters["@ID"].Value); // 2.转到磁盘 sqlCmd.Parameters.Clear(); sqlCmd.CommandText = "Apq_FileTrans_WriteToHD_ADO"; sqlCmd.CommandType = CommandType.StoredProcedure; cmdHelper.AddParameter("@ID", ID); cmdHelper.AddParameter("@KeepInDB", DBNull.Value); sqlCmd.ExecuteNonQuery(); }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public STReturn dtxc_TaskVote_Log_List(string TaskName, string UserNameBegin) { STReturn stReturn = new 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 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; }
/// <summary> /// 获取某个用户及其下级 /// </summary> /// <param name="NReturn"></param> /// <param name="ExMsg"></param> /// <param name="UserID">UserID</param> /// <param name="ContainsSelf">是否包含自己</param> /// <param name="ContainsGrand">是否包含子孙</param> /// <returns></returns> public static DataTable ListChild(ref int NReturn, ref string ExMsg, long UserID, bool ContainsSelf, bool ContainsGrand) { 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", ExMsg, DbType.String, -1); dch.AddParameter("UserID", UserID, DbType.Int64); dch.AddParameter("ContainsSelf", ContainsSelf, DbType.Byte); dch.AddParameter("ContainsGrand", ContainsGrand, DbType.Byte); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sda.Fill(ds); NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value); ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString(); sda.Dispose(); SqlConn.Close(); } return ds.Tables.Count > 0 ? ds.Tables[0] : null; }
/// <summary> /// 编辑 /// </summary> public static STReturn ApqPrivilege_Edit(long PID, long ParentID, string PName, string Remark) { STReturn stReturn = new STReturn(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlCommand sc = new SqlCommand("dbo.ApqPrivilege_Edit", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("PID", PID, DbType.Int64); dch.AddParameter("ParentID", ParentID, DbType.Int64); dch.AddParameter("PName", PName); dch.AddParameter("Remark", Remark); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["PID"].Direction = ParameterDirection.InputOutput; sc.Parameters["ParentID"].Direction = ParameterDirection.InputOutput; sc.Parameters["PName"].Direction = ParameterDirection.InputOutput; sc.Parameters["Remark"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.POuts.Add(sc.Parameters["PID"].Value); stReturn.POuts.Add(sc.Parameters["ParentID"].Value); stReturn.POuts.Add(sc.Parameters["PName"].Value); stReturn.POuts.Add(sc.Parameters["Remark"].Value); stReturn.ExMsg = Apq.Convert.ChangeType<string>(sc.Parameters["ExMsg"].Value); SqlConn.Close(); } return stReturn; }
//#region 注册 ///// <summary> ///// 以用户名注册用户 ///// </summary> ///// <param name="NReturn">返回值</param> ///// <param name="ExMsg">返回信息</param> ///// <param name="LoginName">用户名</param> ///// <param name="binPwd">密码</param> ///// <param name="IDCard">身份证号</param> ///// <param name="IDCardName">身份证姓名</param> ///// <param name="Sex">性别</param> ///// <param name="IDCardPhotoUrl">身份证照片</param> ///// <param name="Users_Name">名字</param> ///// <param name="Users_PhotoUrl">头像</param> ///// <param name="Expire">过期时间</param> ///// <param name="IsAdmin">是否管理员</param> ///// <param name="Birthday">生日</param> ///// <param name="UserID">用户编号</param> ///// <returns></returns> //public static void Apq_Reg_LoginName(ref int NReturn, ref string ExMsg, string LoginName, byte[] binPwd, string IDCard, string IDCardName, byte Sex // , string IDCardPhotoUrl, string Users_Name, string Users_PhotoUrl, DateTime Expire, byte IsAdmin, DateTime Birthday, ref long UserID) //{ // SqlCommand sc = new SqlCommand("Apq_User.Apq_Reg_LoginName"); // sc.CommandType = CommandType.StoredProcedure; // Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); // dch.AddParameter("rtn", 0, DbType.Int32); // dch.AddParameter("ExMsg", ExMsg, DbType.String, -1); // dch.AddParameter("LoginName", LoginName); // dch.AddParameter("binPwd", binPwd); // dch.AddParameter("IDCard", IDCard); // dch.AddParameter("IDCardName", IDCardName); // dch.AddParameter("Sex", Sex, DbType.Byte); // dch.AddParameter("IDCardPhotoUrl", IDCardPhotoUrl); // dch.AddParameter("Users_Name", Users_Name); // dch.AddParameter("Users_PhotoUrl", Users_PhotoUrl); // dch.AddParameter("Expire", Expire); // dch.AddParameter("IsAdmin", IsAdmin, DbType.Byte); // dch.AddParameter("Birthday", Birthday); // dch.AddParameter("UserID", UserID, DbType.Int64); // sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; // sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; // sc.Parameters["UserID"].Direction = ParameterDirection.InputOutput; // using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) // { // sc.Connection = SqlConn; // SqlConn.Open(); // sc.ExecuteNonQuery(); // NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); // ExMsg = sc.Parameters["ExMsg"].Value.ToString(); // UserID = System.Convert.ToInt64(sc.Parameters["UserID"].Value); // sc.Dispose(); // SqlConn.Close(); // } //} //#endregion #region 登录 /// <summary> /// 登录权限子系统 /// </summary> public static STReturn ApqUser_Login(int UserSrc, string UserName) { STReturn stReturn = new 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", string.Empty, 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.POuts.Add(sc.Parameters["UserID"].Value); stReturn.ExMsg = Apq.Convert.ChangeType <string>(sc.Parameters["ExMsg"].Value); SqlConn.Close(); } return(stReturn); }
/// <summary> /// 编辑 /// </summary> public static STReturn ApqPrivilege_Edit(long PID, long ParentID, string PName, string Remark) { STReturn stReturn = new STReturn(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlCommand sc = new SqlCommand("dbo.ApqPrivilege_Edit", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("PID", PID, DbType.Int64); dch.AddParameter("ParentID", ParentID, DbType.Int64); dch.AddParameter("PName", PName); dch.AddParameter("Remark", Remark); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["PID"].Direction = ParameterDirection.InputOutput; sc.Parameters["ParentID"].Direction = ParameterDirection.InputOutput; sc.Parameters["PName"].Direction = ParameterDirection.InputOutput; sc.Parameters["Remark"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.POuts.Add(sc.Parameters["PID"].Value); stReturn.POuts.Add(sc.Parameters["ParentID"].Value); stReturn.POuts.Add(sc.Parameters["PName"].Value); stReturn.POuts.Add(sc.Parameters["Remark"].Value); stReturn.ExMsg = Apq.Convert.ChangeType <string>(sc.Parameters["ExMsg"].Value); SqlConn.Close(); } 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, XmlSerializeString = true)] public STReturn TaskList(int Pager_Page, int Pager_PageSize, int[] Status) { STReturn stReturn = new 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); }
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)) { STReturn stReturn = new 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 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); }
/// <summary> /// 下载文件 /// </summary> public void FileDow(string DBFullName, string FullName) { string FileName = System.IO.Path.GetFileName(FullName); string CFolder = System.IO.Path.GetDirectoryName(FullName); string DBFolder = System.IO.Path.GetDirectoryName(DBFullName); // 准备本地目录 if (!System.IO.Directory.Exists(CFolder)) { System.IO.Directory.CreateDirectory(CFolder); } // 1.写入数据库 Apq.Data.Common.DbConnectionHelper.Open(Connection); System.Data.Common.DbCommand sqlCmd = Connection.CreateCommand(); sqlCmd.CommandText = "Apq_FileTrans_Insert_ADO"; sqlCmd.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper cmdHelper = new Apq.Data.Common.DbCommandHelper(sqlCmd); cmdHelper.AddParameter("@FullName", DBFullName); cmdHelper.AddParameter("@CFolder", CFolder); cmdHelper.AddParameter("@ID", 0); sqlCmd.Parameters["@ID"].Direction = ParameterDirection.InputOutput; sqlCmd.ExecuteNonQuery(); int ID = Apq.Convert.ChangeType <int>(sqlCmd.Parameters["@ID"].Value); // 2.读取到本地 DataSet ds = new DataSet(); Apq.Data.Common.DbConnectionHelper connHelper = new Apq.Data.Common.DbConnectionHelper(Connection); DbDataAdapter da = connHelper.CreateAdapter(); da.SelectCommand.CommandText = "Apq_FileTrans_List"; da.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper daHelper = new Apq.Data.Common.DbCommandHelper(da.SelectCommand); daHelper.AddParameter("@ID", ID); da.Fill(ds); // 3.保存文件 if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { byte[] bFile = Apq.Convert.ChangeType <byte[]>(ds.Tables[0].Rows[0]["FileStream"]); System.IO.FileStream fs = new System.IO.FileStream(FullName, System.IO.FileMode.Create); fs.Write(bFile, 0, bFile.Length); fs.Flush(); fs.Close(); } // 4.删除数据库行 da.SelectCommand.CommandText = "Apq_FileTrans_Delete"; da.SelectCommand.ExecuteNonQuery(); }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public STReturn AddinAdd(string AddinName, string AddinUrl, string AddinDescript) { STReturn stReturn = new STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession)) { return(stReturn); } long UserID = 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="LoginName">用户名</param> /// <param name="binLoginPwd">密码</param> /// <returns></returns> private Apq.STReturn DBLogin(string LoginName, byte[] binLoginPwd) { Apq.STReturn stReturn = new Apq.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_Login"; 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("LoginName", LoginName); dch.AddParameter("LoginPwd", binLoginPwd); 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(); if (ds.Tables.Count > 0) { stReturn.FNReturn = ds.Tables[0]; } sda.Dispose(); SqlConn.Close(); } // 返回调用者 string SqlLoginPwd = Apq.Data.SqlClient.Common.ConvertToSqlON(binLoginPwd); if (stReturn.NReturn > 0 && ds.Tables[0].Rows.Count > 0) { stReturn.NReturn = 1; stReturn.FNReturn = ds.Tables[0]; stReturn.POuts.Add(SqlLoginPwd); } 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, XmlSerializeString = true)] public STReturn NewsList(int Pager_Page, int Pager_PageSize) { STReturn stReturn = new 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 = 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 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; }
/// <summary> /// 上传文件 /// </summary> public void FileUp(string FullName, string DBFullName, byte[] bFile) { string FileName = System.IO.Path.GetFileName(FullName); string CFolder = System.IO.Path.GetDirectoryName(FullName); string DBFolder = System.IO.Path.GetDirectoryName(DBFullName); // 1.上传到数据库 Apq.Data.Common.DbConnectionHelper.Open(Connection); System.Data.Common.DbCommand sqlCmd = Connection.CreateCommand(); sqlCmd.CommandText = "Apq_FileTrans_Insert"; sqlCmd.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper cmdHelper = new Apq.Data.Common.DbCommandHelper(sqlCmd); cmdHelper.AddParameter("@FileName", FileName); cmdHelper.AddParameter("@DBFolder", DBFolder); cmdHelper.AddParameter("@CFolder", CFolder); cmdHelper.AddParameter("@FileStream", bFile); cmdHelper.AddParameter("@ID", 0); sqlCmd.Parameters["@ID"].Direction = ParameterDirection.InputOutput; sqlCmd.ExecuteNonQuery(); int ID = Apq.Convert.ChangeType <int>(sqlCmd.Parameters["@ID"].Value); // 2.转到磁盘 sqlCmd.Parameters.Clear(); sqlCmd.CommandText = "Apq_FileTrans_WriteToHD_ADO"; sqlCmd.CommandType = CommandType.StoredProcedure; cmdHelper.AddParameter("@ID", ID); cmdHelper.AddParameter("@KeepInDB", DBNull.Value); sqlCmd.ExecuteNonQuery(); }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn Dinner_Stat_EmDinner_Food(DateTime BTime, DateTime ETime, bool State) { 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_Stat_EmDinner_Food"; 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("BTime", BTime); dch.AddParameter("ETime", ETime); dch.AddParameter("State", State); 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 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); }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public STReturn UsersListChild(int Pager_Page, int Pager_PageSize, long UserID, bool ContainsSelf, bool ContainsGrand) { STReturn stReturn = new 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 Dinner_EmDinner_Insert(long FoodID) { 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_Insert"; 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("EmID", ApqSession.Employee.EmID); dch.AddParameter("FoodID", FoodID); 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); }
/// <summary> /// 用户信息 /// </summary> public static System.Data.DataSet ApqUser_ListOne(long UserID) { System.Data.DataSet ds = new System.Data.DataSet(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlDataAdapter sda = new SqlDataAdapter("dbo.ApqUser_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("UserID", UserID, DbType.Int64); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; SqlConn.Open(); sda.Fill(ds); //stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); SqlConn.Close(); } return(ds); }
/// <summary> /// 列表权限项树 /// </summary> /// <param name="PID">根</param> /// <returns></returns> public static System.Data.DataSet ApqPrivilege_List(long PID) { System.Data.DataSet ds = new System.Data.DataSet(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlDataAdapter sda = new SqlDataAdapter("dbo.ApqPrivilege_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("PID", PID, DbType.Int64); sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; SqlConn.Open(); sda.Fill(ds); //stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); SqlConn.Close(); } return ds; }
/// <summary> /// 执行登录存储过程 /// </summary> /// <param name="UserName">用户名</param> /// <param name="binLoginPwd">密码</param> /// <returns></returns> private STReturn DBLogin(string UserName, byte[] binLoginPwd) { STReturn stReturn = new STReturn(); DataSet ds = new DataSet(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { SqlDataAdapter sda = new SqlDataAdapter("dtxc.dtxc_Login_UserName", 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("UserName", UserName); dch.AddParameter("LoginPwd", binLoginPwd); 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(); } // 返回客户端 string SqlLoginPwd = Apq.Data.SqlClient.Common.ConvertToSqlON(binLoginPwd); if (stReturn.NReturn > 0) { stReturn.FNReturn = ds.Tables[0]; stReturn.POuts = new object[] { UserName, SqlLoginPwd }; } 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); }
/// <summary> /// 设置权限 /// </summary> /// <param name="UserID"></param> /// <param name="strUserP">权限串,格式:PID,IsDeny;... IsDeny为-1时表示删除</param> public static STReturn ApqUser_SetP(long UserID, string strUserP) { STReturn stReturn = new STReturn(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlCommand sc = new SqlCommand("dbo.ApqUser_SetP", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("UserID", UserID, DbType.Int64); dch.AddParameter("strUserP", strUserP); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); 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 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 STReturn TaskBalance(long TaskID) { STReturn stReturn = new STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckPwdExpire(ref stReturn, ApqSession)) { return(stReturn); } using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlCommand sc = new SqlCommand("dtxc.Apq_Task_BalanceOne", 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("TaskID", TaskID); 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 STReturn dtxc_Users_ListChild_Pager(int Pager_Page, int Pager_PageSize, long UserID) { STReturn stReturn = new 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.dtxc_Users_ListChild_Pager", 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); 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 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); }
//[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); }
//[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.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_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, XmlSerializeString = true)] public STReturn dtxc_Reg_UserName(string Name, string UserName, 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) { STReturn stReturn = new 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.Common.GetSqlConnectionString("SqlConnectionString2"))) { SqlCommand sc = new SqlCommand("dtxc.dtxc_Reg_UserName", 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("Name", Name); dch.AddParameter("UserName", UserName); 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 = sc.Parameters["ExMsg"].Value.ToString(); stReturn.POuts = new object[] { sc.Parameters["UserID"].Value }; sc.Dispose(); SqlConn.Close(); } 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; }
/// <summary> /// 执行登录存储过程 /// </summary> /// <param name="UserName">用户名</param> /// <param name="binLoginPwd">密码</param> /// <returns></returns> private STReturn DBLogin(string UserName, byte[] binLoginPwd) { STReturn stReturn = new STReturn(); DataSet ds = new DataSet(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { SqlDataAdapter sda = new SqlDataAdapter("dtxc.dtxc_Login_UserName", 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("UserName", UserName); dch.AddParameter("LoginPwd", binLoginPwd); 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(); } // 返回客户端 string SqlLoginPwd = Apq.Data.SqlClient.Common.ConvertToSqlON(binLoginPwd); if (stReturn.NReturn > 0) { stReturn.FNReturn = ds.Tables[0]; stReturn.POuts = new object[] { UserName, SqlLoginPwd }; } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public STReturn dtxc_TaskVote_Log_List(string TaskName, string UserNameBegin) { STReturn stReturn = new 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; }
protected void Page_Load(object sender, EventArgs e) { //绑定对象 //默认值 txtBTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); txtETime.Text = DateTime.Now.AddMonths(1).ToString("yyyy-MM-dd"); string m = Request.QueryString["m"]; switch (m) { //添加 case "a": case "A": break; //查看 //修改 default: //获取数据 long TaskID = System.Convert.ToInt64(Request.QueryString["TaskID"]); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { Apq.STReturn stReturn = new Apq.STReturn(); SqlDataAdapter sda = new SqlDataAdapter("dtxc.Apq_Task_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("TaskID", TaskID); 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) { //页面赋值 txtTaskID.Text = ds.Tables[0].Rows[0]["TaskID"].ToString(); txtTaskName.Text = ds.Tables[0].Rows[0]["TaskName"].ToString(); cbNeedChangeIP.Checked = System.Convert.ToBoolean(ds.Tables[0].Rows[0]["NeedChangeIP"]); cbIsAutoStart.Checked = System.Convert.ToBoolean(ds.Tables[0].Rows[0]["IsAutoStart"]); txtBTime.Text = System.Convert.ToDateTime(ds.Tables[0].Rows[0]["BTime"]).ToString("yyyy-MM-dd"); txtETime.Text = System.Convert.ToDateTime(ds.Tables[0].Rows[0]["ETime"]).ToString("yyyy-MM-dd"); txtTaskContent.Text = ds.Tables[0].Rows[0]["TaskContent"].ToString(); txtAddinID.Text = ds.Tables[0].Rows[0]["AddinID"].ToString(); txtTaskMoney.Text = ds.Tables[0].Rows[0]["TaskMoney"].ToString(); txtPrice.Text = ds.Tables[0].Rows[0]["Price"].ToString(); txtParentPrice.Text = ds.Tables[0].Rows[0]["ParentPrice"].ToString(); } break; } //设置只读 if (m == "v" || m == "V") { txtTaskID.Enabled = false; txtTaskName.Enabled = false; cbNeedChangeIP.Enabled = false; cbIsAutoStart.Enabled = false; txtBTime.Enabled = false; txtETime.Enabled = false; txtTaskContent.Enabled = false; txtAddinID.Enabled = false; txtTaskMoney.Enabled = false; txtPrice.Enabled = false; txtParentPrice.Enabled = false; txtBTime.Enabled = false; txtETime.Enabled = false; } }
//[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; }
/// <summary> /// 删除 /// </summary> public static STReturn ApqUser_Delete(long PID, long ParentID) { STReturn stReturn = new STReturn(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlCommand sc = new SqlCommand("dbo.ApqUser_Delete", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("PID", PID, DbType.Int64); dch.AddParameter("ParentID", ParentID, DbType.Int64); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); SqlConn.Close(); } return stReturn; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public STReturn UserEdit(long UserID, string UserName, short Sex, string PhotoUrl, DateTime Expire, bool Status, bool IsAdmin, DateTime Birthday , string IDCard, string Alipay) { STReturn stReturn = new 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.GlobalObject.SqlConnectionString)) { SqlCommand sc = new SqlCommand("dtxc.Apq_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("UserName", UserName); 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 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 TaskEdit(long TaskID, 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_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", 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("TaskID", TaskID); 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); 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) { //绑定对象 //默认值 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: //获取数据 using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { STReturn stReturn = new STReturn(); SqlDataAdapter sda = new SqlDataAdapter("dtxc.dtxc_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) { //页面赋值 txtUserID.Text = ds.Tables[0].Rows[0]["UserID"].ToString(); txtName.Text = ds.Tables[0].Rows[0]["Name"].ToString(); ddlSex.SelectedValue = ds.Tables[0].Rows[0]["Sex"].ToString(); txtAlipay.Text = ds.Tables[0].Rows[0]["Alipay"].ToString(); if (!Convert.IsDBNull(ds.Tables[0].Rows[0]["Birthday"])) txtBirthday.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["Birthday"]).ToString("yyyy-MM-dd"); txtExpire.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["Expire"]).ToString("yyyy-MM-dd"); txtRegTime.Text = 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; txtName.Enabled = false; ddlSex.Enabled = false; txtAlipay.Enabled = false; txtBirthday.Enabled = false; txtIntroUserID.Enabled = false; txtIDCard.Enabled = false; } }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn Dinner_RegEmployee(string EmName, string LoginName, string LoginPwd) { Apq.STReturn stReturn = new Apq.STReturn(); if (EmName.Length < 1) { stReturn.NReturn = -1; stReturn.ExMsg = "姓名不允许为空"; return(stReturn); } if (LoginName.Length < 1) { stReturn.NReturn = -1; stReturn.ExMsg = "登录不允许为空"; return(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)); string SqlLoginPwd = Apq.Data.SqlClient.Common.ConvertToSqlON(binLoginPwd); 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_RegEmployee"; 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("EmName", EmName); 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("EmID", 0, DbType.Int64); dch.AddParameter("LoginID", 0, DbType.Int64); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput; sc.Parameters["EmID"].Direction = ParameterDirection.InputOutput; sc.Parameters["LoginID"].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.Add(sc.Parameters["EmID"].Value); stReturn.POuts.Add(sc.Parameters["LoginID"].Value); stReturn.POuts.Add(LoginName); stReturn.POuts.Add(SqlLoginPwd); sc.Dispose(); SqlConn.Close(); } 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; }
/// <summary> /// 编辑 /// </summary> public static STReturn ApqUser_Edit(long UserID, int UserSrc, string UserName, byte AllowLogin) { STReturn stReturn = new STReturn(); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.GlobalObject.SqlConnectionString)) { SqlCommand sc = new SqlCommand("dbo.ApqUser_Edit", SqlConn); sc.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc); dch.AddParameter("rtn", 0, DbType.Int32); dch.AddParameter("UserID", UserID, DbType.Int64); dch.AddParameter("UserSrc", UserSrc, DbType.Int32); dch.AddParameter("UserName", UserName); dch.AddParameter("AllowLogin", AllowLogin, DbType.Byte); sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue; sc.Parameters["UserID"].Direction = ParameterDirection.InputOutput; sc.Parameters["UserSrc"].Direction = ParameterDirection.InputOutput; sc.Parameters["UserName"].Direction = ParameterDirection.InputOutput; sc.Parameters["AllowLogin"].Direction = ParameterDirection.InputOutput; SqlConn.Open(); sc.ExecuteNonQuery(); stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value); stReturn.POuts.Add(sc.Parameters["UserID"].Value); stReturn.POuts.Add(sc.Parameters["UserSrc"].Value); stReturn.POuts.Add(sc.Parameters["UserName"].Value); stReturn.POuts.Add(sc.Parameters["AllowLogin"].Value); 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: //获取数据 long AddinID = Convert.ToInt64(Request.QueryString["AddinID"]); using (SqlConnection SqlConn = new SqlConnection(Apq.DB.Common.GetSqlConnectionString("SqlConnectionString2"))) { STReturn stReturn = new STReturn(); 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(); } if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { //页面赋值 txtAddinID.Text = ds.Tables[0].Rows[0]["AddinID"].ToString(); txtAddinName.Text = ds.Tables[0].Rows[0]["AddinName"].ToString(); txtAddinUrl.Text = ds.Tables[0].Rows[0]["AddinUrl"].ToString(); txtAddinDescript.Text = ds.Tables[0].Rows[0]["AddinDescript"].ToString(); } break; } //设置只读 if (m == "v" || m == "V") { txtAddinID.Enabled = false; txtAddinName.Enabled = false; txtAddinUrl.Enabled = false; txtAddinDescript.Enabled = false; } }
//[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 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; }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public STReturn TaskList(int Pager_Page, int Pager_PageSize, int[] Status) { STReturn stReturn = new 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 STReturn AddinAdd(string AddinName, string AddinUrl, string AddinDescript) { STReturn stReturn = new STReturn(); Apq.Web.SessionState.HttpSessionState ApqSession = new Apq.Web.SessionState.HttpSessionState(Session); if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession)) { return stReturn; } long UserID = 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; }
//[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; }
/// <summary> /// 下载文件 /// </summary> public void FileDow(string DBFullName, string FullName) { string FileName = System.IO.Path.GetFileName(FullName); string CFolder = System.IO.Path.GetDirectoryName(FullName); string DBFolder = System.IO.Path.GetDirectoryName(DBFullName); // 准备本地目录 if (!System.IO.Directory.Exists(CFolder)) { System.IO.Directory.CreateDirectory(CFolder); } // 1.写入数据库 Apq.Data.Common.DbConnectionHelper.Open(Connection); System.Data.Common.DbCommand sqlCmd = Connection.CreateCommand(); sqlCmd.CommandText = "Apq_FileTrans_Insert_ADO"; sqlCmd.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper cmdHelper = new Apq.Data.Common.DbCommandHelper(sqlCmd); cmdHelper.AddParameter("@FullName", DBFullName); cmdHelper.AddParameter("@CFolder", CFolder); cmdHelper.AddParameter("@ID", 0); sqlCmd.Parameters["@ID"].Direction = ParameterDirection.InputOutput; sqlCmd.ExecuteNonQuery(); int ID = Apq.Convert.ChangeType<int>(sqlCmd.Parameters["@ID"].Value); // 2.读取到本地 DataSet ds = new DataSet(); Apq.Data.Common.DbConnectionHelper connHelper = new Apq.Data.Common.DbConnectionHelper(Connection); DbDataAdapter da = connHelper.CreateAdapter(); da.SelectCommand.CommandText = "Apq_FileTrans_List"; da.SelectCommand.CommandType = CommandType.StoredProcedure; Apq.Data.Common.DbCommandHelper daHelper = new Apq.Data.Common.DbCommandHelper(da.SelectCommand); daHelper.AddParameter("@ID", ID); da.Fill(ds); // 3.保存文件 if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { byte[] bFile = Apq.Convert.ChangeType<byte[]>(ds.Tables[0].Rows[0]["FileStream"]); System.IO.FileStream fs = new System.IO.FileStream(FullName, System.IO.FileMode.Create); fs.Write(bFile, 0, bFile.Length); fs.Flush(); fs.Close(); } // 4.删除数据库行 da.SelectCommand.CommandText = "Apq_FileTrans_Delete"; da.SelectCommand.ExecuteNonQuery(); }
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)] public Apq.STReturn PayoutConfirm(long PayoutID) { 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.GlobalObject.SqlConnectionString)) { SqlCommand sc = new SqlCommand("dtxc.dtxc_Payout_Confirm", 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("PayoutID", PayoutID); 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; }