public InterimReportBean getIR(string prjID)
{
sqlString = "select tbl_ProjectSubmit.Project_Name, tbl_ProjectSubmit.Project_PersonLiable, tbl_ProjectSubmit.Project_StartTime, tbl_ProjectSubmit.Project_PlanTime, tbl_InterimReport.Interim_Plan, tbl_InterimReport.Interim_Fruit, tbl_InterimReport.Interim_Question from tbl_ProjectSubmit,tbl_InterimReport where tbl_ProjectSubmit.Project_ID='" + prjID + "'";
// sqlString = "select tbl_ProjectSubmit.Project_Name from tbl_ProjectSubmit,tbl_InterimReport where tbl_ProjectSubmit.Project_ID='" + prjID + "'";
//ds = db.GetDataSet(sqlString);
dr = db.GetDataRow(sqlString);
if (dr != null)
{
psr.IrName = dr[0].ToString();
psr.IrPerson = dr[1].ToString();
psr.IrStartTime = dr[2].ToString();
psr.IrPlanTime = dr[3].ToString();
psr.IrPlan = dr[4].ToString();
psr.IrFruit = dr[5].ToString();
psr.IrQuestion = dr[6].ToString();
}
else
{
sqlString = "select tbl_ProjectSubmit.Project_Name, tbl_ProjectSubmit.Project_PersonLiable, tbl_ProjectSubmit.Project_StartTime, tbl_ProjectSubmit.Project_PlanTime from tbl_ProjectSubmit where tbl_ProjectSubmit.Project_ID='" + prjID + "'";
dr = db.GetDataRow(sqlString);
psr.IrName = dr[0].ToString();
psr.IrPerson = dr[1].ToString();
psr.IrStartTime = dr[2].ToString();
psr.IrPlanTime = dr[3].ToString();
}
return(psr);
}
public ProjectEndBean getProjectEnd(string prjID)
{
sqlString = "select tbl_ProjectSubmit.Project_Name, tbl_ProjectSubmit.Project_PersonLiable, tbl_ProjectSubmit.Project_StartTime, tbl_ProjectSubmit.Project_PlanTime, tbl_ProjectEnd.Project_Fruit, tbl_ProjectEnd.Project_Content, tbl_ProjectEnd.Project_PlanImplement,tbl_ProjectEnd.Project_PlanImplement,tbl_ProjectEnd.Project_innovation,tbl_ProjectEnd.Project_NextProblem from tbl_ProjectSubmit,tbl_ProjectEnd where tbl_ProjectSubmit.Project_ID='" + prjID + "'";
// sqlString = "select tbl_ProjectSubmit.Project_Name from tbl_ProjectSubmit,tbl_InterimReport where tbl_ProjectSubmit.Project_ID='" + prjID + "'";
dr = db.GetDataRow(sqlString);
if (dr != null)
{
peb.PrjName = dr[0].ToString();
peb.IrPerson = dr[1].ToString();
peb.IrStartTime = dr[2].ToString();
peb.IrPlanTime = dr[3].ToString();
peb.PrjFruit = dr[4].ToString();
peb.PrjContent = dr[5].ToString();
peb.PrjPlanImplement = dr[6].ToString();
peb.PrjInnovation = dr[7].ToString();
peb.PrjNextProblem = dr[8].ToString();
}
else
{
sqlString = "select tbl_ProjectSubmit.Project_Name, tbl_ProjectSubmit.Project_PersonLiable, tbl_ProjectSubmit.Project_StartTime, tbl_ProjectSubmit.Project_PlanTime from tbl_ProjectSubmit where tbl_ProjectSubmit.Project_ID='" + prjID + "'";
dr = db.GetDataRow(sqlString);
peb.PrjName = dr[0].ToString();
peb.IrPerson = dr[1].ToString();
peb.IrStartTime = dr[2].ToString();
peb.IrPlanTime = dr[3].ToString();
}
return(peb);
}
public ResultBean getIR(string prjID)
{
sqlString = "select tbl_ProjectSubmit.Project_Name, tbl_ProjectSubmit.Project_PersonLiable,tbl_ResultData.Result_BookNumber,tbl_ResultData.Result_BookNameC,tbl_ResultData.Result_BookNameEn,tbl_ResultData.Result_class,tbl_ResultData.Result_PublishName,tbl_ResultData.Result_PublishLevel,tbl_ResultData.Result_PublishTime,tbl_ResultData.Result_publishNumber, tbl_ResultData.Result_WordCount from tbl_ProjectSubmit,tbl_ResultData where tbl_ProjectSubmit.Project_ID='" + prjID + "'";
dr = db.GetDataRow(sqlString);
if (dr != null)
{
result.RtPrjName = dr[0].ToString();
result.RtPeople = dr[1].ToString();
result.RtBookNumber = dr[2].ToString();
result.RtBookNameC = dr[3].ToString();
result.RtBookNameEn = dr[4].ToString();
result.RtClass = dr[5].ToString();
result.RtPublishName = dr[6].ToString();
result.RtPublishLevel = dr[7].ToString();
result.RtPublishTime = dr[8].ToString();
result.RtPublishNumber = dr[9].ToString();
result.RtWordCount = dr[10].ToString();
}
else
{
sqlString = "select tbl_ProjectSubmit.Project_Name, tbl_ProjectSubmit.Project_PersonLiable, tbl_ProjectSubmit.Project_StartTime, tbl_ProjectSubmit.Project_PlanTime from tbl_ProjectSubmit where tbl_ProjectSubmit.Project_ID='" + prjID + "'";
dr = db.GetDataRow(sqlString);
result.RtPrjName = dr[0].ToString();
result.RtPeople = dr[1].ToString();
}
return(result);
}
public bool userCheck(string userID, string userPassword)
{
sqlString = "select * from tbl_Users where User_ID='" + userID + "' and User_Password='******'";
if (db.GetDataRow(sqlString) != null)
{
return(true);
}
else
{
return(false);
}
}
public string getNewsID()
{
string temp;
sqlString = "select News_ID from tbl_NewsBulletin order by News_ID desc";
DataRow dr = db.GetDataRow(sqlString);
currentTime = CurrentTime.GetInstance().timeFormat("yyyyMMdd");
if (dr != null)
{
temp = dr[0].ToString();
newsID = parserID(temp);
}
else
{
newsID = currentTime + "001";
}
return(newsID);
}