/// <summary> /// 根据参数Jxbbh,获取教学班详细信息 /// </summary> /// <param name="jxbbh">教学班编号</param> public void LoadData(string jsbh, string bysjlx, string kbxn, string kbxq) { Database db = new Database(); //实例化一个Database类 string sql = ""; sql = "Select * from [bysjb],[jsb],[yxb] where [jsb].jsbh = " + SqlStringConstructor.GetQuotedString(jsbh) + " And bysjlx = " + SqlStringConstructor.GetQuotedString(bysjlx) + " And kbxn = " + SqlStringConstructor.GetQuotedString(kbxn) + " And kbxq =" + SqlStringConstructor.GetQuotedString(kbxq) + "And [bysjb].jsbh=[jsb].jsbh And [bysjb].yxbh=[yxb].yxbh"; DataRow dr = db.GetDataRow(sql); //利用Database类的GetDataRow方法查询用户数据 //根据查询得到的数据,对成员赋值 if (dr != null) { this._jsxm = GetSafeData.ValidateDataRow_S(dr, "jsxm"); this._bysjlx = GetSafeData.ValidateDataRow_S(dr, "bysjlx"); this._yxmc = GetSafeData.ValidateDataRow_S(dr, "yxmc"); this._bysjzs = GetSafeData.ValidateDataRow_F(dr, "bysjzs"); this._cjrs = GetSafeData.ValidateDataRow_N(dr, "cjrs"); this._kbxn = GetSafeData.ValidateDataRow_S(dr, "kbxn"); this._kbxq = GetSafeData.ValidateDataRow_S(dr, "kbxq"); this._jsbh = GetSafeData.ValidateDataRow_S(dr, "jsbh"); this._yxbh = GetSafeData.ValidateDataRow_S(dr, "yxbh"); this._exist = true; } else { this._exist = false; } }
//根据题目ID 初始化题目 //输入: // TID - 题目编号; //输出: // 题目存在:返回True; // 题目不在:返回False; public bool LoadData(int TID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID); //用户编号 DataSet ds = DB.GetDataSet("Proc_MultiProblemDetail", Params); ds.CaseSensitive = false; DataRow DR; if (ds.Tables[0].Rows.Count > 0) { DR = ds.Tables[0].Rows[0]; this._CourseID = GetSafeData.ValidateDataRow_N(DR, "CourseID"); //科目编号 this._Title = GetSafeData.ValidateDataRow_S(DR, "Title"); //题目 this._AnswerA = GetSafeData.ValidateDataRow_S(DR, "AnswerA"); //答案A this._AnswerB = GetSafeData.ValidateDataRow_S(DR, "AnswerB"); //答案B this._AnswerC = GetSafeData.ValidateDataRow_S(DR, "AnswerC"); //答案C this._AnswerD = GetSafeData.ValidateDataRow_S(DR, "AnswerD"); //答案D this._Answer = GetSafeData.ValidateDataRow_S(DR, "Answer"); //答案 return(true); } else { return(false); } }
//根据题目ID 初始化题目 //输入: // TID - 题目编号; //输出: // 题目存在:返回True; // 题目不在:返回False; public bool LoadData(int TID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID); //用户编号 DataSet ds = DB.GetDataSet("Proc_FillBlankProblemDetail", Params); ds.CaseSensitive = false; DataRow DR; if (ds.Tables[0].Rows.Count > 0) { DR = ds.Tables[0].Rows[0]; this._CourseID = GetSafeData.ValidateDataRow_N(DR, "CourseID"); //科目编号 this._FrontTitle = GetSafeData.ValidateDataRow_S(DR, "FrontTitle"); //题目前部分 this._BackTitle = GetSafeData.ValidateDataRow_S(DR, "BackTitle"); //题目后部分 this._Answer = GetSafeData.ValidateDataRow_S(DR, "Answer"); //答案 return(true); } else { return(false); } }
/// <summary> /// 根据参数bookID,获取图书详细信息 /// </summary> /// <param name="topicID">图书ID</param> public void LoadData(int bookID) { Database db = new Database(); //实例化一个Database类 string sql = ""; sql = "Select * from [Book] where BookID = " + bookID; DataRow dr = db.GetDataRow(sql); //利用Database类的GetDataRow方法查询用户数据 //根据查询得到的数据,对成员赋值 if (dr != null) { this._bookId = GetSafeData.ValidateDataRow_N(dr, "BookID"); this._bookName = GetSafeData.ValidateDataRow_S(dr, "BookName"); this._categoryId = GetSafeData.ValidateDataRow_N(dr, "CategoryId"); this._price = GetSafeData.ValidateDataRow_F(dr, "Price"); this._publisher = GetSafeData.ValidateDataRow_S(dr, "Publisher"); this._publishDate = GetSafeData.ValidateDataRow_T(dr, "PublishDate"); this._author = GetSafeData.ValidateDataRow_S(dr, "Author"); this._pageNum = GetSafeData.ValidateDataRow_N(dr, "PageNum"); this._pictureUrl = GetSafeData.ValidateDataRow_S(dr, "PictureUrl"); this._description = GetSafeData.ValidateDataRow_S(dr, "Description"); this._saleCount = GetSafeData.ValidateDataRow_N(dr, "SaleCount"); this._exist = true; } else { this._exist = false; } }
/// <summary> /// 根据参数departmentId,获取部门详细信息 /// </summary> /// <param name="topicID">部门ID</param> public bool LoadData(int DepartmentId) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); Params[0] = DB.MakeInParam("@DepartmentId", SqlDbType.Int, 4, DepartmentId); //用户编号 DataSet ds = DB.GetDataSet("Proc_DepartmentDetail", Params); ds.CaseSensitive = false; DataRow DR; if (ds.Tables[0].Rows.Count > 0) { DR = ds.Tables[0].Rows[0]; this._departmentId = GetSafeData.ValidateDataRow_N(DR, "DepartmentId"); this._departmentName = GetSafeData.ValidateDataRow_S(DR, "DepartmentName"); return(true); } else { return(false); } }
//根据题目ID 初始化题目 //输入: // TID - 题目编号; //输出: // 题目存在:返回True; // 题目不在:返回False; public bool LoadData(int TID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID); //用户编号 DataSet ds = DB.GetDataSet("Proc_DatiDetail", Params); ds.CaseSensitive = false; DataRow DR; if (ds.Tables[0].Rows.Count > 0) { DR = ds.Tables[0].Rows[0]; this._CourseID = GetSafeData.ValidateDataRow_N(DR, "CourseID"); //科目编号 this._ImgFile = GetSafeData.ValidateDataRow_S(DR, "Img"); //图片url this._Title = GetSafeData.ValidateDataRow_S(DR, "Title"); //大题信息 this._nandu = GetSafeData.ValidateDataRow_N(DR, "Nandu"); //难度 this._zhang = GetSafeData.ValidateDataRow_N(DR, "Zhang"); //章 this._jie = GetSafeData.ValidateDataRow_N(DR, "Jie"); //节 return(true); } else { return(false); } }
//根据题目ID 初始化题目 //输入: // TID - 题目编号; //输出: // 如果考试题目存在:返回True; // 如果考试题目不在:返回False; public bool LoadData(int TID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); string strsql = "SELECT * FROM JudgeProblemmr where ID=@ID"; Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID); //用户编号 DataSet ds = DB.GetStrDataSetSql(strsql, Params); ds.CaseSensitive = false; DataRow DR; if (ds.Tables[0].Rows.Count > 0) { DR = ds.Tables[0].Rows[0]; this._CourseID = GetSafeData.ValidateDataRow_N(DR, "CourseID"); //科目编号 this._Title = GetSafeData.ValidateDataRow_S(DR, "Title"); //题目 this._Answer = GetSafeData.ValidateDataRow_B(DR, "Answer"); //答案 return(true); } else { return(false); } }
/// <summary> /// 根据参数loginName,获取用户详细信息 /// </summary> /// <param name="userId">用户ID</param> public void LoadData(int userId) { Database db = new Database(); //实例化一个Database类 string sql = ""; sql = "Select * from [User] where UserId = " + userId.ToString(); DataRow dr = db.GetDataRow(sql); //利用Database类的GetDataRow方法查询用户数据 //根据查询得到的数据,对成员赋值 if (dr != null) { this._userID = GetSafeData.ValidateDataRow_N(dr, "UserID"); this._loginName = GetSafeData.ValidateDataRow_S(dr, "loginName"); this._userName = GetSafeData.ValidateDataRow_S(dr, "UserName"); this._password = GetSafeData.ValidateDataRow_S(dr, "PassWord"); this._address = GetSafeData.ValidateDataRow_S(dr, "Address"); this._zip = GetSafeData.ValidateDataRow_S(dr, "Zip"); this._exist = true; } else { this._exist = false; } }
//根据用户 UserID 初始化该用户 //输入: // XUserID - 用户编号; //输出: // 用户存在:返回True; // 用户不在:返回False; public bool LoadData(int XUserID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, XUserID); //用户编号 DataSet ds = DB.GetDataSet("Proc_UsersDetail", Params); ds.CaseSensitive = false; DataRow DR; if (ds.Tables[0].Rows.Count > 0) { DR = ds.Tables[0].Rows[0]; this._userID = GetSafeData.ValidateDataRow_N(DR, "UserID"); //用户编号 this._userPower = GetSafeData.ValidateDataRow_N(DR, "UserPower"); //用户权限 this._userName = GetSafeData.ValidateDataRow_S(DR, "UserName"); //用户姓名 this._userEmail = GetSafeData.ValidateDataRow_S(DR, "UserEmail"); //用户邮箱 this._userNum = GetSafeData.ValidateDataRow_S(DR, "UserNum"); //用户学号 return(true); } else { return(false); } }
//根据题目ID 初始化题目 //输入: // TID - 题目编号; //输出: // 题目存在:返回True; // 题目不在:返回False; public bool LoadData(int TID) { SqlParameter[] Params = new SqlParameter[1]; Datacon DB = new Datacon(); Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID); //用户编号 DataSet ds = DB.GetDataSet("Proc_JudgeProblemDetail", Params); ds.CaseSensitive = false; DataRow DR; if (ds.Tables[0].Rows.Count > 0) { DR = ds.Tables[0].Rows[0]; this._c_id = GetSafeData.ValidateDataRow_N(DR, "c_id"); //科目编号 this._Title = GetSafeData.ValidateDataRow_S(DR, "Title"); //题目 this._Answer = GetSafeData.ValidateDataRow_B(DR, "Answer"); //答案 return(true); } else { return(false); } }
//下载于51aspx.com //根据用户 UserID 初始化该用户 //输入: // XUserID - 用户编号; //输出: // 用户存在:返回True; // 用户不在:返回False; public bool LoadData(string XUserID) {//下载于51aspx.com SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, XUserID); //用户编号 DataSet ds = DB.GetDataSet("Proc_UsersDetail", Params); ds.CaseSensitive = false; DataRow DR; if (ds.Tables[0].Rows.Count > 0) { DR = ds.Tables[0].Rows[0]; this._userID = GetSafeData.ValidateDataRow_S(DR, "UserID"); //用户编号 this._userName = GetSafeData.ValidateDataRow_S(DR, "UserName"); //用户姓名 this._userPwd = GetSafeData.ValidateDataRow_S(DR, "UserPwd"); //用户密码 this._department = GetSafeData.ValidateDataRow_N(DR, "DepartmentId"); //所在部门 this._roleid = GetSafeData.ValidateDataRow_N(DR, "RoleId"); //用户权限 this._rolename = GetSafeData.ValidateDataRow_S(DR, "RoleName"); //用户权限 //获取权限集合 string colName = ""; for (int i = 0; i < DR.ItemArray.Length; i++) { colName = DR.Table.Columns[i].ColumnName; if (colName.StartsWith("HasDuty_") && GetSafeData.ValidateDataRow_N(DR, colName) == 1) { this._duties.Add(DR.Table.Columns[i].ColumnName.Substring(8)); //去掉前缀“HasDuty_” } } //默认 this._duties.Add("UserTest"); this._duties.Add("PaperScore"); return(true); } else { return(false); } }
//根据用户 UserID 初始化该用户 //输入: // XUserID - 用户编号; //输出: // 用户存在:返回True; // 用户不在:返回False; public bool LoadData(string XUserID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, XUserID); //用户编号 string strsql = "SELECT * FROM Usersmr,Departmentmr,Rolemr WHERE UserID=@UserID AND Usersmr.DepartmentId = Departmentmr.DepartmentId And Usersmr.RoleId = Rolemr.RoleId"; DataSet ds = DB.GetStrDataSetSql(strsql, Params); ds.CaseSensitive = false; DataRow DR; if (ds.Tables[0].Rows.Count > 0) { DR = ds.Tables[0].Rows[0]; this._userID = GetSafeData.ValidateDataRow_S(DR, "UserID"); //用户编号 this._userName = GetSafeData.ValidateDataRow_S(DR, "UserName"); //用户姓名 this._userPwd = GetSafeData.ValidateDataRow_S(DR, "UserPwd"); //用户密码 this._department = GetSafeData.ValidateDataRow_N(DR, "DepartmentId"); //所在部门 this._roleid = GetSafeData.ValidateDataRow_N(DR, "RoleId"); //用户权限 this._rolename = GetSafeData.ValidateDataRow_S(DR, "RoleName"); //用户权限 //获取权限集合 string colName = ""; for (int i = 0; i < DR.ItemArray.Length; i++) { colName = DR.Table.Columns[i].ColumnName; if (colName.StartsWith("HasDuty_") && GetSafeData.ValidateDataRow_N(DR, colName) == 1) { this._duties.Add(DR.Table.Columns[i].ColumnName.Substring(8)); //去掉前缀“HasDuty_” } } return(true); } else { return(false); } }
/// <summary> /// 根据参数roleId,获取角色(职务)详细信息 /// </summary> /// <param name="topicID">角色(职务)ID</param> public void LoadData(int roleId) { DataBase db = new DataBase(); //实例化一个Database类 string sql = ""; sql = "Select * from [Role] where RoleId = " + roleId; DataRow dr = db.GetDataRow(sql); //利用Database类的GetDataRow方法查询数据 //根据查询得到的数据,对成员赋值 if (dr != null) { this._roleId = GetSafeData.ValidateDataRow_N(dr, "RoleId"); this._roleName = GetSafeData.ValidateDataRow_S(dr, "RoleName"); this._exist = true; } else { this._exist = false; } }
/// <summary> /// 根据参数categoryId,获取图书类别详细信息 /// </summary> /// <param name="topicID">图书类别ID</param> public void LoadData(int categoryId) { Database db = new Database(); //实例化一个Database类 string sql = ""; sql = "Select * from [Category] where CategoryId = " + categoryId; DataRow dr = db.GetDataRow(sql); //利用Database类的GetDataRow方法查询用户数据 //根据查询得到的数据,对成员赋值 if (dr != null) { this._categoryId = GetSafeData.ValidateDataRow_N(dr, "CategoryId"); this._categoryName = GetSafeData.ValidateDataRow_S(dr, "CategoryName"); this._exist = true; } else { this._exist = false; } }
/// <summary> /// 根据参数Jxbbh,获取教学班详细信息 /// </summary> /// <param name="jxbbh">教学班编号</param> public void LoadData(string jsbh, string kcmc, string jxbmc, string kbxn, string kbxq) { Database db = new Database(); //实例化一个Database类 string sql = ""; sql = "Select * from [js_kc_gxb],[jsb],[kcb],[jxbb] where [jsb].jsbh = " + SqlStringConstructor.GetQuotedString(jsbh) + " And [kcb].kcmc = " + SqlStringConstructor.GetQuotedString(kcmc) + " And [jxbb].jxbmc = " + SqlStringConstructor.GetQuotedString(jxbmc) + " And kbxn = " + SqlStringConstructor.GetQuotedString(kbxn) + " And kbxq =" + SqlStringConstructor.GetQuotedString(kbxq) + "And [js_kc_gxb].jsbh=[jsb].jsbh And [js_kc_gxb].kcbh=[kcb].kcbh And [js_kc_gxb].jxbbh=[jxbb].jxbbh"; DataRow dr = db.GetDataRow(sql); //利用Database类的GetDataRow方法查询用户数据 //根据查询得到的数据,对成员赋值 if (dr != null) { this._jsxm = GetSafeData.ValidateDataRow_S(dr, "jsxm"); this._jsbh = GetSafeData.ValidateDataRow_S(dr, "jsbh"); this._kcmc = GetSafeData.ValidateDataRow_S(dr, "kcmc"); this._kcbh = GetSafeData.ValidateDataRow_S(dr, "kcbh"); this._jxbbh = GetSafeData.ValidateDataRow_S(dr, "jxbbh"); this._jxbmc = GetSafeData.ValidateDataRow_S(dr, "jxbmc"); this._kbxn = GetSafeData.ValidateDataRow_S(dr, "kbxn"); this._kbxq = GetSafeData.ValidateDataRow_S(dr, "kbxq"); this._llxs = GetSafeData.ValidateDataRow_N(dr, "llxs"); this._lldxs = GetSafeData.ValidateDataRow_F(dr, "lldxs"); this._syxs = GetSafeData.ValidateDataRow_N(dr, "syxs"); this._sydxs = GetSafeData.ValidateDataRow_F(dr, "sydxs"); this._exist = true; } else { this._exist = false; } }
public void Docload(int docID) //加载稿件信息 { string sql = "select * from document where docID=" + SQLString.GetQuotedString(Convert.ToString(docID)); Database db = new Database(); DataRow dr = db.GetDataRow(sql); if (dr != null) { this._docID = GetSafeData.ValidateDataRow_N(dr, "docID"); this._docTime = GetSafeData.ValidateDataRow_T(dr, "docTime"); this._docTitle = GetSafeData.ValidateDataRow_S(dr, "docTitle"); this._docTitleEn = GetSafeData.ValidateDataRow_S(dr, "docTitleEn"); this._docAbstract = GetSafeData.ValidateDataRow_S(dr, "docAbstract"); this._docAbstractEn = GetSafeData.ValidateDataRow_S(dr, "docAbstractEn"); this._docKeywords = GetSafeData.ValidateDataRow_S(dr, "docKeywords"); this._docKeywordsEn = GetSafeData.ValidateDataRow_S(dr, "docKeywordsEn"); this._docLetters = GetSafeData.ValidateDataRow_N(dr, "docLetters"); this._docAuthor = GetSafeData.ValidateDataRow_S(dr, "docAuthor"); this._docColumnID = GetSafeData.ValidateDataRow_S(dr, "docColumnID"); this._authorID = GetSafeData.ValidateDataRow_S(dr, "authorID"); this._docState = GetSafeData.ValidateDataRow_S(dr, "docState"); this._docReason = GetSafeData.ValidateDataRow_S(dr, "docReason"); } }
/// <summary> /// 根据参数bjbh,获取班级详细信息 /// </summary> /// <param name="bjbh">班级编号/param> public void LoadData(string bjbh) { Database db = new Database(); //实例化一个Database类 string sql = ""; sql = "Select * from [bjb] where bjbh = " + bjbh; DataRow dr = db.GetDataRow(sql); //利用Database类的GetDataRow方法查询数据 //根据查询得到的数据,对成员赋值 if (dr != null) { this._bjbh = GetSafeData.ValidateDataRow_S(dr, "Bjbh"); this._bjmc = GetSafeData.ValidateDataRow_S(dr, "Bjmc"); this._bjrs = GetSafeData.ValidateDataRow_N(dr, "Bjrs"); this._yxbz = GetSafeData.ValidateDataRow_B(dr, "Yxbz"); this._exist = true; } else { this._exist = false; } }
/// <summary> /// 根据参数zcbh,获取职称详细信息 /// </summary> /// <param name="zcbh">职称编号/param> public void LoadData(string zcbh) { Database db = new Database(); //实例化一个Database类 string sql = ""; sql = "Select * from [zcb] where zcbh = " + zcbh; DataRow dr = db.GetDataRow(sql); //利用Database类的GetDataRow方法查询数据 //根据查询得到的数据,对成员赋值 if (dr != null) { this._zcbh = GetSafeData.ValidateDataRow_S(dr, "Zcbh"); this._zcmc = GetSafeData.ValidateDataRow_S(dr, "Zcmc"); this._zclx = GetSafeData.ValidateDataRow_S(dr, "Zclx"); this._bzgzl = GetSafeData.ValidateDataRow_N(dr, "Bzgzl"); this._exist = true; } else { this._exist = false; } }