protected void updateSolution()
{
int problemid = Convert.ToInt32(Request.QueryString[1]);
int flag = Convert.ToInt32(Request.QueryString[0]);
colproblems = ObjproblemToSolution.Get_All_Problemid(problemid);
foreach (ProblemToSolution obj in colproblems)
{
if (obj.Problemid != 0)
{
if (obj.Solutiontype == "Solution")
{
ObjSolution = ObjSolution.Get_By_id(obj.Solutionid);
if (ObjSolution.Solution == "Solution")
{
ObjSolutionKeyword = ObjSolutionKeyword.Get_By_id(ObjSolution.Solutionid);
txtTitle.Text = ObjSolution.Title.ToString();
txtKeywords.Text = ObjSolutionKeyword.Keywords.ToString();
drpTopic.SelectedValue = Convert.ToString(ObjSolution.Topicid);
Editor.Text = ObjSolution.Content.ToString();
}
}
}
}
}
protected void UpdateSolution()
{
int Solutionid = Convert.ToInt16(Request.QueryString[0]);
ObjSolution = ObjSolution.Get_By_id(Solutionid);
ObjSolutionKeyword = ObjSolutionKeyword.Get_By_id(Solutionid);
txtTitle.Text = ObjSolution.Title.ToString();
Editor.Text = ObjSolution.Content.ToString();
drpTopic.SelectedValue = ObjSolution.Topicid.ToString();
ObjSolutionKeyword = ObjSolutionKeyword.Get_By_id(Solutionid);
txtKeywords.Text = ObjSolutionKeyword.Keywords.ToString();
}
public void SolutionAddKeyword(string solutionpath, string keywordname, byte rate)
{
var sln = from solution in DB.Solutions
where solution.SolutionPath == solutionpath
select solution;
if (sln.Count() > 1)
{
throw new Exception("数据库中包含重复的解决方案路径！");
}
if (sln.Count() == 0)
{
throw new Exception("数据库中无解决方案路径！");
}
Solution s = sln.Single();
var key = from keyword in DB.SolutionKeywords
where keyword.SolutionKeywordName == keywordname
select keyword;
SolutionKeyword sk;
if (key.Count() > 1)
{
throw new Exception("数据库中包含重复的解决方案关键字！");
}
if (key.Count() == 0)
{
sk = new SolutionKeyword();
sk.SolusionKeywordID = Guid.NewGuid();
sk.SolutionKeywordName = keywordname;
DB.SolutionKeywords.InsertOnSubmit(sk);
}
else
{
sk = key.Single();
}
SolusionToKeyword stk = new SolusionToKeyword();
stk.Solution = s;
stk.SolutionKeyword = sk;
stk.Rate = rate;
s.SolusionToKeywords.Add(stk);
DB.SubmitChanges();
}
protected void updateWorkaround()
{
int problemid = Convert.ToInt16(Request.QueryString[1]);
int flag = Convert.ToInt16(Request.QueryString[0]);
colproblems = ObjproblemToSolution.Get_All_Problemid(problemid);
foreach (ProblemToSolution obj in colproblems)
{
if (obj.Solutiontype == "WorkAround" )
{
ObjSolution = ObjSolution.Get_By_id(obj.Solutionid);
if (ObjSolution.Solution == "WorkAround")
{
ObjSolutionKeyword = ObjSolutionKeyword.Get_By_id(obj.Solutionid);
txtTitle.Text = ObjSolution.Title.ToString();
txtKeywords.Text = ObjSolutionKeyword.Keywords.ToString();
drpTopic.SelectedValue = Convert.ToString(ObjSolution.Topicid);
Editor.Text = ObjSolution.Content.ToString();
}
}
}
}
protected void UpdateSolution()
{
int Solutionid = Convert.ToInt16(Request.QueryString[0]);
ObjSolution = ObjSolution.Get_By_id(Solutionid);
ObjSolutionKeyword = ObjSolutionKeyword.Get_By_id(Solutionid);
txtTitle.Text = ObjSolution.Title.ToString();
Editor.Text=ObjSolution.Content.ToString();
drpTopic.SelectedValue = ObjSolution.Topicid.ToString();
ObjSolutionKeyword = ObjSolutionKeyword.Get_By_id(Solutionid);
txtKeywords.Text = ObjSolutionKeyword.Keywords.ToString();
}
protected void ShowPanal1()
{
panShowdata.Visible = true;
panEditData.Visible = false;
int Solutionid = Convert.ToInt16(Request.QueryString[0]);
ObjSolution = ObjSolution.Get_By_id(Solutionid);
ObjSolutionKeyword = ObjSolutionKeyword.Get_By_id(Solutionid);
if(ObjCategory.CategoryName==null)
{
lbltitle.Text = ObjSolution.Title.ToString();
lblcontent.Text = ObjSolution.Content.ToString();
ObjCategory = ObjCategory.Get_By_id(ObjSolution.Topicid);
lbltopic.Text = "";
lblkeyword.Text = ObjSolutionKeyword.Keywords.ToString();
lblsolid.Text = Solutionid.ToString();
editsolheader.Visible = false;
}
else
{
lbltitle.Text = ObjSolution.Title.ToString();
lblcontent.Text = ObjSolution.Content.ToString();
ObjCategory = ObjCategory.Get_By_id(ObjSolution.Topicid);
lbltopic.Text = ObjCategory.CategoryName.ToString();
lblkeyword.Text = ObjSolutionKeyword.Keywords.ToString();
lblsolid.Text = Solutionid.ToString();
editsolheader.Visible = false;
}
int status=Convert.ToInt16(ObjSolution.SolutionStatus);
if (status ==1)
{
imgapprove.Visible = true;
Imgunapproved.Visible = false;
lblapprove.Text = "Approve";
}
else if (status == 2)
{
Imgunapproved.Visible = true;
imgapprove.Visible = false;
lblapprove.Text = "Rejected";
}
else
{
imgapprove.Visible = false;
Imgunapproved.Visible = false;
lblapprove.Text = "UnApproved";
}
ObjSolutionCreator = ObjSolutionCreator.Get_By_id(ObjSolution.Solutionid);
int userid = Convert.ToInt16(ObjSolutionCreator.Createdby);
objUser = objUser.Get_By_id(userid);
lblcreatedby.Text = objUser.Username.ToString();
lblcreatedon.Text = ObjSolutionCreator.CreateDatetime.ToString();
int lastupdateid = Convert.ToInt16(ObjSolutionCreator.LastUpdateBy);
if (lastupdateid != 0)
{
objUser = objUser.Get_By_id(lastupdateid);
lbllastupdateon.Text = ObjSolutionCreator.LastUpdateon.ToString();
lbllastupdate.Text = objUser.Username.ToString();
}
else
{
lbllastupdateon.Text = "";
lbllastupdate.Text = "";
}
//if (objUser.Username == "")
//{
// lbllastupdate.Text = objUser.Username.ToString();
// lbllastupdate.Text = objUser.Username.ToString();
//}
//else
//{
// lbllastupdate.Text = "";
// lbllastupdateon.Text = "";
//}
//if (objUser.Username != "")
//{
// lbllastupdate.Text = objUser.Username.ToString();
//}
//if (ObjSolutionCreator.LastUpdateon == "")
//{
// lbllastupdateon.Text = ObjSolutionCreator.LastUpdateon.ToString();
//}
//if (ObjSolutionCreator.LastUpdateon != "")
//{
// lbllastupdateon.Text = ObjSolutionCreator.LastUpdateon.ToString();
//}
}
public int Update_SolutionKeyword_mst_By_id(SolutionKeyword ObjSolutionKeyword)
{
return (int)ExecuteNonQuery(Sp_SolutionKeyword_Update, new object[] { ObjSolutionKeyword.Solutionid, ObjSolutionKeyword.Keywordid, ObjSolutionKeyword.Keywords });
}
public int Insert_SolutionKeyword_mst(SolutionKeyword objSolutionKeyword)
{
return (int)ExecuteNonQuery(Sp_SolutionKeyword_Insert, new object[] { objSolutionKeyword.Solutionid, objSolutionKeyword.Keywords });
}
public object GenerateSolutionKeyword_mstCollection_mstObject(ref IDataReader returnData)
{
SolutionKeyword obj = new SolutionKeyword();
while (returnData.Read())
{
obj.Keywordid = (int)returnData["Keywordid"];
obj.Solutionid = (int)returnData["Solutionid"];
obj.Keywords = (string)returnData["keywords"];
}
returnData.Close();
returnData.Dispose();
return obj;
}
protected void ShowPanal1()
{
panShowdata.Visible = true;
panEditData.Visible = false;
int Solutionid = Convert.ToInt16(Request.QueryString[0]);
ObjSolution = ObjSolution.Get_By_id(Solutionid);
ObjSolutionKeyword = ObjSolutionKeyword.Get_By_id(Solutionid);
if (ObjCategory.CategoryName == null)
{
lbltitle.Text = ObjSolution.Title.ToString();
lblcontent.Text = ObjSolution.Content.ToString();
ObjCategory = ObjCategory.Get_By_id(ObjSolution.Topicid);
lbltopic.Text = "";
lblkeyword.Text = ObjSolutionKeyword.Keywords.ToString();
lblsolid.Text = Solutionid.ToString();
editsolheader.Visible = false;
}
else
{
lbltitle.Text = ObjSolution.Title.ToString();
lblcontent.Text = ObjSolution.Content.ToString();
ObjCategory = ObjCategory.Get_By_id(ObjSolution.Topicid);
lbltopic.Text = ObjCategory.CategoryName.ToString();
lblkeyword.Text = ObjSolutionKeyword.Keywords.ToString();
lblsolid.Text = Solutionid.ToString();
editsolheader.Visible = false;
}
int status = Convert.ToInt16(ObjSolution.SolutionStatus);
if (status == 1)
{
imgapprove.Visible = true;
Imgunapproved.Visible = false;
lblapprove.Text = "Approve";
}
else if (status == 2)
{
Imgunapproved.Visible = true;
imgapprove.Visible = false;
lblapprove.Text = "Rejected";
}
else
{
imgapprove.Visible = false;
Imgunapproved.Visible = false;
lblapprove.Text = "UnApproved";
}
ObjSolutionCreator = ObjSolutionCreator.Get_By_id(ObjSolution.Solutionid);
int userid = Convert.ToInt16(ObjSolutionCreator.Createdby);
objUser = objUser.Get_By_id(userid);
lblcreatedby.Text = objUser.Username.ToString();
lblcreatedon.Text = ObjSolutionCreator.CreateDatetime.ToString();
int lastupdateid = Convert.ToInt16(ObjSolutionCreator.LastUpdateBy);
if (lastupdateid != 0)
{
objUser = objUser.Get_By_id(lastupdateid);
lbllastupdateon.Text = ObjSolutionCreator.LastUpdateon.ToString();
lbllastupdate.Text = objUser.Username.ToString();
}
else
{
lbllastupdateon.Text = "";
lbllastupdate.Text = "";
}
//if (objUser.Username == "")
//{
// lbllastupdate.Text = objUser.Username.ToString();
// lbllastupdate.Text = objUser.Username.ToString();
//}
//else
//{
// lbllastupdate.Text = "";
// lbllastupdateon.Text = "";
//}
//if (objUser.Username != "")
//{
// lbllastupdate.Text = objUser.Username.ToString();
//}
//if (ObjSolutionCreator.LastUpdateon == "")
//{
// lbllastupdateon.Text = ObjSolutionCreator.LastUpdateon.ToString();
//}
//if (ObjSolutionCreator.LastUpdateon != "")
//{
// lbllastupdateon.Text = ObjSolutionCreator.LastUpdateon.ToString();
//}
}
