/// <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;
}
}
