/// <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> /// 根据参数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; } }
/// <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; } }