public userinfoData[] Select(string Id)
{
int iRel = -1;
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
userinfoData[] datuserinfo = new userinfoData[1];
string sql = "select * from userinfo where Id= " + Id + " ";
try
{
objDB.OpenConnection();
DataSet ds = objDB.QueryData(sql, "departmentinfo");
if (ds.Tables.Count > 0)
{
long nRow = ds.Tables[0].Rows.Count;
if (nRow > 0)
{
datuserinfo = new userinfoData[nRow];
for (int i = 0; i < nRow; i++)
{
datuserinfo[i] = new userinfoData();
datuserinfo[i].subscribe = ds.Tables[0].Rows[i]["subscribe"].ToString();
datuserinfo[i].openid = ds.Tables[0].Rows[i]["openid"].ToString();
datuserinfo[i].nickname = ds.Tables[0].Rows[i]["nickname"].ToString();
datuserinfo[i].sex = ds.Tables[0].Rows[i]["sex"].ToString();
datuserinfo[i].language = ds.Tables[0].Rows[i]["language"].ToString();
datuserinfo[i].city = ds.Tables[0].Rows[i]["city"].ToString();
datuserinfo[i].province = ds.Tables[0].Rows[i]["province"].ToString();
datuserinfo[i].country = ds.Tables[0].Rows[i]["country"].ToString();
datuserinfo[i].headimgurl = ds.Tables[0].Rows[i]["headimgurl"].ToString();
datuserinfo[i].subscribe_time = ds.Tables[0].Rows[i]["subscribe_time"].ToString();
datuserinfo[i].unionid = ds.Tables[0].Rows[i]["unionid"].ToString();
datuserinfo[i].remark = ds.Tables[0].Rows[i]["remark"].ToString();
datuserinfo[i].privilege = ds.Tables[0].Rows[i]["privilege"].ToString();
}
}
}
}
catch (Exception ex)
{
iRel = -1;
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(datuserinfo);
}
public correctingData[] Select(string Id)
{
int iRel = -1;
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
correctingData[] datcorrecting = new correctingData[1];
string sql = "select * from correcting where Id= " + Id + " ";
try
{
objDB.OpenConnection();
DataSet ds = objDB.QueryData(sql, "departmentinfo");
if (ds.Tables.Count > 0)
{
long nRow = ds.Tables[0].Rows.Count;
if (nRow > 0)
{
datcorrecting = new correctingData[nRow];
for (int i = 0; i < nRow; i++)
{
datcorrecting[i] = new correctingData();
datcorrecting[i].hwtit = ds.Tables[0].Rows[i]["hwtit"].ToString();
datcorrecting[i].userid = ds.Tables[0].Rows[i]["userid"].ToString();
datcorrecting[i].ctime = ds.Tables[0].Rows[i]["ctime"].ToString();
datcorrecting[i].ccon = ds.Tables[0].Rows[i]["ccon"].ToString();
datcorrecting[i].ter = ds.Tables[0].Rows[i]["ter"].ToString();
datcorrecting[i].cdate = ds.Tables[0].Rows[i]["cdate"].ToString();
datcorrecting[i].scores = ds.Tables[0].Rows[i]["scores"].ToString();
datcorrecting[i].messages = ds.Tables[0].Rows[i]["messages"].ToString();
}
}
}
}
catch (Exception ex)
{
iRel = -1;
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(datcorrecting);
}
public informationsData[] Put(string casestr)
{
int iRel = -1;
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
informationsData[] datinformations = new informationsData[1];
string sql = "select * from informations where 1 = 1 ";
sql += casestr;
try
{
objDB.OpenConnection();
DataSet ds = objDB.QueryData(sql, "departmentinfo");
if (ds.Tables.Count > 0)
{
long nRow = ds.Tables[0].Rows.Count;
if (nRow > 0)
{
datinformations = new informationsData[nRow];
for (int i = 0; i < nRow; i++)
{
datinformations[i] = new informationsData();
datinformations[i].thetit = ds.Tables[0].Rows[i]["thetit"].ToString();
datinformations[i].thetype = ds.Tables[0].Rows[i]["thetype"].ToString();
datinformations[i].thetime = ds.Tables[0].Rows[i]["thetime"].ToString();
datinformations[i].userid = ds.Tables[0].Rows[i]["userid"].ToString();
datinformations[i].memos = ds.Tables[0].Rows[i]["memos"].ToString();
datinformations[i].userclass = ds.Tables[0].Rows[i]["userclass"].ToString();
}
}
}
}
catch (Exception ex)
{
iRel = -1;
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(datinformations);
}
public articleData[] Select(string Id)
{
int iRel = -1;
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
articleData[] datarticle = new articleData[1];
string sql = "select * from article where Id= " + Id + " ";
try
{
objDB.OpenConnection();
DataSet ds = objDB.QueryData(sql, "departmentinfo");
if (ds.Tables.Count > 0)
{
long nRow = ds.Tables[0].Rows.Count;
if (nRow > 0)
{
datarticle = new articleData[nRow];
for (int i = 0; i < nRow; i++)
{
datarticle[i] = new articleData();
datarticle[i].thumb_media_id = ds.Tables[0].Rows[i]["thumb_media_id"].ToString();
datarticle[i].author = ds.Tables[0].Rows[i]["author"].ToString();
datarticle[i].title = ds.Tables[0].Rows[i]["title"].ToString();
datarticle[i].content_source_url = ds.Tables[0].Rows[i]["content_source_url"].ToString();
datarticle[i].content = ds.Tables[0].Rows[i]["content"].ToString();
datarticle[i].digest = ds.Tables[0].Rows[i]["digest"].ToString();
datarticle[i].show_cover_pic = ds.Tables[0].Rows[i]["show_cover_pic"].ToString();
}
}
}
}
catch (Exception ex)
{
iRel = -1;
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(datarticle);
}
public usersData[] Put(string Id)
{
int iRel = -1;
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
usersData[] datusers = new usersData[1];
string sql = "select * from users where 1 = 1 ";
sql += Id;
try
{
objDB.OpenConnection();
DataSet ds = objDB.QueryData(sql, "departmentinfo");
if (ds.Tables.Count > 0)
{
long nRow = ds.Tables[0].Rows.Count;
if (nRow > 0)
{
datusers = new usersData[nRow];
for (int i = 0; i < nRow; i++)
{
datusers[i] = new usersData();
datusers[i].userid = ds.Tables[0].Rows[i]["userid"].ToString();
datusers[i].userpwrd = ds.Tables[0].Rows[i]["userpwrd"].ToString();
datusers[i].username = ds.Tables[0].Rows[i]["username"].ToString();
datusers[i].usertype = ds.Tables[0].Rows[i]["usertype"].ToString();
datusers[i].userclass = ds.Tables[0].Rows[i]["userclass"].ToString();
}
}
}
}
catch (Exception ex)
{
iRel = -1;
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(datusers);
}
public menulevel2Data[] Select(string Id)
{
int iRel = -1;
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
menulevel2Data[] datmenulevel2 = new menulevel2Data[1];
string sql = "select * from menulevel2 where Id= " + Id + " ";
try
{
objDB.OpenConnection();
DataSet ds = objDB.QueryData(sql, "departmentinfo");
if (ds.Tables.Count > 0)
{
long nRow = ds.Tables[0].Rows.Count;
if (nRow > 0)
{
datmenulevel2 = new menulevel2Data[nRow];
for (int i = 0; i < nRow; i++)
{
datmenulevel2[i] = new menulevel2Data();
datmenulevel2[i].level1id = ds.Tables[0].Rows[i]["level1id"].ToString();
datmenulevel2[i].menutype = ds.Tables[0].Rows[i]["menutype"].ToString();
datmenulevel2[i].menuname = ds.Tables[0].Rows[i]["menuname"].ToString();
datmenulevel2[i].menuurl = ds.Tables[0].Rows[i]["menuurl"].ToString();
datmenulevel2[i].nums = ds.Tables[0].Rows[i]["nums"].ToString();
}
}
}
}
catch (Exception ex)
{
iRel = -1;
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(datmenulevel2);
}
public themessData[] Select(string Id)
{
int iRel = -1;
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
themessData[] datthemess = new themessData[1];
string sql = "select * from themess where Id= " + Id + " ";
try
{
objDB.OpenConnection();
DataSet ds = objDB.QueryData(sql, "departmentinfo");
if (ds.Tables.Count > 0)
{
long nRow = ds.Tables[0].Rows.Count;
if (nRow > 0)
{
datthemess = new themessData[nRow];
for (int i = 0; i < nRow; i++)
{
datthemess[i] = new themessData();
datthemess[i].userid = ds.Tables[0].Rows[i]["userid"].ToString();
datthemess[i].messtime = ds.Tables[0].Rows[i]["messtime"].ToString();
datthemess[i].messcon = ds.Tables[0].Rows[i]["messcon"].ToString();
datthemess[i].ter = ds.Tables[0].Rows[i]["ter"].ToString();
datthemess[i].replys = ds.Tables[0].Rows[i]["replys"].ToString();
}
}
}
}
catch (Exception ex)
{
iRel = -1;
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(datthemess);
}
public homeworkData[] Select(string Id)
{
int iRel = -1;
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
homeworkData[] dathomework = new homeworkData[1];
string sql = "select * from homework where Id= " + Id + " ";
try
{
objDB.OpenConnection();
DataSet ds = objDB.QueryData(sql, "departmentinfo");
if (ds.Tables.Count > 0)
{
long nRow = ds.Tables[0].Rows.Count;
if (nRow > 0)
{
dathomework = new homeworkData[nRow];
for (int i = 0; i < nRow; i++)
{
dathomework[i] = new homeworkData();
dathomework[i].hwtit = ds.Tables[0].Rows[i]["hwtit"].ToString();
dathomework[i].hwtime = ds.Tables[0].Rows[i]["hwtime"].ToString();
dathomework[i].hwer = ds.Tables[0].Rows[i]["hwer"].ToString();
dathomework[i].press = ds.Tables[0].Rows[i]["press"].ToString();
dathomework[i].userclass = ds.Tables[0].Rows[i]["userclass"].ToString();
}
}
}
}
catch (Exception ex)
{
iRel = -1;
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(dathomework);
}
public materialData[] Select(string Id)
{
int iRel = -1;
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
materialData[] datmaterial = new materialData[1];
string sql = "select * from material where Id= " + Id + " ";
try
{
objDB.OpenConnection();
DataSet ds = objDB.QueryData(sql, "departmentinfo");
if (ds.Tables.Count > 0)
{
long nRow = ds.Tables[0].Rows.Count;
if (nRow > 0)
{
datmaterial = new materialData[nRow];
for (int i = 0; i < nRow; i++)
{
datmaterial[i] = new materialData();
datmaterial[i].materialtype = ds.Tables[0].Rows[i]["materialtype"].ToString();
datmaterial[i].materialtit = ds.Tables[0].Rows[i]["materialtit"].ToString();
datmaterial[i].materialfile = ds.Tables[0].Rows[i]["materialfile"].ToString();
datmaterial[i].materialtime = ds.Tables[0].Rows[i]["materialtime"].ToString();
}
}
}
}
catch (Exception ex)
{
iRel = -1;
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(datmaterial);
}
public bbsData SelectData(string casestr)
{
int iRel = -1;
DataAccess.CommonDB objDB = new DataAccess.CommonDB();
bbsData datbbs = new bbsData();
string sql = "select * from bbs where 1= 1 ";
sql += casestr;
try
{
objDB.OpenConnection();
DataSet ds = objDB.QueryData(sql, "departmentinfo");
if (ds.Tables.Count > 0)
{
long nRow = ds.Tables[0].Rows.Count;
if (nRow > 0)
{
for (int i = 0; i < nRow; i++)
{
datbbs.userid = ds.Tables[0].Rows[i]["userid"].ToString();
datbbs.thetime = ds.Tables[0].Rows[i]["thetime"].ToString();
datbbs.memos = ds.Tables[0].Rows[i]["memos"].ToString();
}
}
}
}
catch (Exception ex)
{
iRel = -1;
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(datbbs);
}