/// <summary>
/// 更新一条数据
/// </summary>
public void Update(A_PATemplate model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update A_PATemplate set ");
if (model.A_PATemplateName != null)
{
strSql.Append("A_PATemplateName='" + model.A_PATemplateName + "',");
}
else
{
strSql.Append("A_PATemplateName= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where A_PATemplateID=" + model.A_PATemplateID + "");
DBHelp.ExeCommand(strSql.ToString());
if (model.A_PATemplateItem.Count > 0)
{
string strSql3 = "delete from A_PATemplateItem where A_PATemplateID=" + model.A_PATemplateID;
object obj1 = DBHelp.ExeScalar(strSql3.ToString());
for (int i = 0; i < model.A_PATemplateItem.Count; i++)
{
strSql3 = "Insert into A_PATemplateItem (A_PATemplateID,A_PASectionID,A_PAItemID,A_PAItemScore,A_PAItemAmount,A_PAIsFirstReview,A_PAFirstReviewUserID,A_PAIsSecondReview,A_PASecondReviewUserID,A_PAIsMultiReview) values (" + model.A_PATemplateID + "," + model.A_PATemplateSection[i].ToString() + "," + model.A_PATemplateItem[i].ToString() + "," + model.A_PATemplateScore[i].ToString() + "," + model.A_PATemplateAmount[i].ToString() + "," + (model.A_PATemplateIsFirstReview[i] ? 1 : 0) + "," + model.A_PATemplateFirstReviewUserID[i].ToString() + "," + (model.A_PATemplateIsSecondReview[i] ? 1 : 0) + "," + model.A_PATemplateSecondReviewUserID[i].ToString() + "," + (model.A_PATemplateIsMultiReview[i] ? 1 : 0) + ")";
object obj2 = DBHelp.ExeScalar(strSql3.ToString());
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public List <A_PATemplate> GetModelList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select A_PATemplateID,A_PATemplateName ");
strSql.Append(" FROM A_PATemplate ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
List <A_PATemplate> PATemplate = new List <A_PATemplate>();
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn);
using (SqlDataReader dataReader = objCommand.ExecuteReader())
{
while (dataReader.Read())
{
A_PATemplate model = new A_PATemplate();
object ojb;
ojb = dataReader["A_PATemplateID"];
if (ojb != null && ojb != DBNull.Value)
{
model.A_PATemplateID = (int)ojb;
}
model.A_PATemplateName = dataReader["A_PATemplateName"].ToString();
PATemplate.Add(model);
}
}
}
return(PATemplate);
}
protected void Page_Load(object sender, EventArgs e)
{
for (int i = 1; i <= 100; i++)
{
sequence.Add(i);
}
if (!base.IsPostBack)
{
PASection = this.PASectionSer.GetModelList("");
AllUserTable = UserSer.getUserTableByLoginName(null);
AllUserDropDownList.DataSource = AllUserTable;
AllUserDropDownList.DataTextField = "LoginName";
AllUserDropDownList.DataValueField = "Id";
AllUserDropDownList.DataBind();
if (base.Request["PATemplateId"] != null)
{
this.btnAdd.Visible = false;
A_PATemplate PATemplate = this.PATemplateSer.GetModelList("A_PATemplateId=" + base.Request["PATemplateId"])[0];
this.txtPATemplateName.Text = PATemplate.A_PATemplateName;
PAItemDetail = this.PATemplateSer.GetDetailList(base.Request["PATemplateId"]);
this.gvList.DataSource = PAItemDetail;
this.gvList.DataBind();
}
else
{
this.btnUpdate.Visible = false;
this.gvList.DataSource = this.PATemplateSer.GetDetailList("");
this.gvList.DataBind();
}
}
}
/// <summary>
/// 增加一条模版及子项和众评人
/// </summary>
public int Add(A_PATemplate model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
string strSql3;
if (model.A_PATemplateName != null)
{
strSql1.Append("A_PATemplateName,");
strSql2.Append("'" + model.A_PATemplateName + "',");
}
strSql.Append("insert into A_PATemplate(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
object obj = DBHelp.ExeScalar(strSql.ToString());
if (obj == null)
{
return(0);
}
else
{
int PATemplateID = Convert.ToInt32(obj);
if (model.A_PATemplateItem.Count > 0)
{
strSql3 = "delete from A_PATemplateItem where A_PATemplateID=" + PATemplateID.ToString() + ";delete from A_PATemplateItemUser where A_PATemplateID=" + PATemplateID.ToString();
object obj1 = DBHelp.ExeScalar(strSql3.ToString());
for (int i = 0; i < model.A_PATemplateItem.Count; i++)
{
strSql3 = "Insert into A_PATemplateItem (A_PATemplateID,Sequence,A_PASectionID,A_PAItemID,A_PAItemScore,A_PAItemAmount,A_PAIsFirstReview,A_PAFirstReviewUserID,A_PAIsSecondReview,A_PASecondReviewUserID,A_PAIsMultiReview) values (" + PATemplateID.ToString() + "," + model.A_PAItemSequence[i].ToString() + "," + model.A_PATemplateSection[i].ToString() + "," + model.A_PATemplateItem[i].ToString() + "," + model.A_PATemplateScore[i].ToString() + "," + model.A_PATemplateAmount[i].ToString() + "," + (model.A_PATemplateIsFirstReview[i] ? 1 : 0) + "," + model.A_PATemplateFirstReviewUserID[i].ToString() + "," + (model.A_PATemplateIsSecondReview[i] ? 1 : 0) + "," + model.A_PATemplateSecondReviewUserID[i].ToString() + "," + (model.A_PATemplateIsMultiReview[i] ? 1 : 0) + ")";
object obj3 = DBHelp.ExeScalar(strSql3.ToString());
for (int j = 0; j < model.A_PATemplateMultiReviewUserID[i].Count; j++)
{
strSql3 = "Insert into A_PATemplateItemUser (A_PATemplateID,A_PASection_ID,A_PAItemID,User_ID) values (" + PATemplateID.ToString() + "," + model.A_PATemplateSection[i].ToString() + "," + model.A_PATemplateItem[i].ToString() + "," + model.A_PATemplateMultiReviewUserID[i][j].ToString() + ")";
object obj4 = DBHelp.ExeScalar(strSql3.ToString());
}
}
}
return(PATemplateID);
}
}
public int SingleModify(A_PATemplate model, string PATemplateID)
{
string strSql3;
if (model.A_PATemplateItem.Count > 0)
{
strSql3 = "delete from A_PATemplateItem where A_PATemplateID=" + PATemplateID + " and A_PAItemID=" + model.A_PATemplateItem[0].ToString() + ";delete from A_PATemplateItemUser where A_PATemplateID=" + PATemplateID + " and A_PAItemID=" + model.A_PATemplateItem[0].ToString();
object obj1 = DBHelp.ExeScalar(strSql3.ToString());
strSql3 = "Insert into A_PATemplateItem (A_PATemplateID,Sequence,A_PASectionID,A_PAItemID,A_PAItemScore,A_PAItemAmount,A_PAIsFirstReview,A_PAFirstReviewUserID,A_PAIsSecondReview,A_PASecondReviewUserID,A_PAIsMultiReview) values (" + PATemplateID + "," + model.A_PAItemSequence[0].ToString() + "," + model.A_PATemplateSection[0].ToString() + "," + model.A_PATemplateItem[0].ToString() + "," + model.A_PATemplateScore[0].ToString() + "," + model.A_PATemplateAmount[0].ToString() + "," + (model.A_PATemplateIsFirstReview[0] ? 1 : 0) + "," + model.A_PATemplateFirstReviewUserID[0].ToString() + "," + (model.A_PATemplateIsSecondReview[0] ? 1 : 0) + "," + model.A_PATemplateSecondReviewUserID[0].ToString() + "," + (model.A_PATemplateIsMultiReview[0] ? 1 : 0) + ")";
object obj3 = DBHelp.ExeScalar(strSql3.ToString());
for (int j = 0; j < model.A_PATemplateMultiReviewUserID[0].Count; j++)
{
strSql3 = "Insert into A_PATemplateItemUser (A_PATemplateID,A_PASection_ID,A_PAItemID,User_ID) values (" + PATemplateID + "," + model.A_PATemplateSection[0].ToString() + "," + model.A_PATemplateItem[0].ToString() + "," + model.A_PATemplateMultiReviewUserID[0][j].ToString() + ")";
object obj4 = DBHelp.ExeScalar(strSql3.ToString());
}
}
return(1);
}
protected A_PATemplate getSelectedDetail()
{
List <int> TemplateItem = new List <int>();
List <int> ItemSequence = new List <int>();
List <int> TemplateSection = new List <int>();
List <decimal> TemplateScore = new List <decimal>();
List <decimal> TemplateAmount = new List <decimal>();
List <bool> IsFirstReview = new List <bool>();
List <int> FirstReviewUserID = new List <int>();
List <bool> IsSecondReview = new List <bool>();
List <int> SecondReviewUserID = new List <int>();
List <bool> IsMultiReview = new List <bool>();
List <List <int> > MultiReviewUserID = new List <List <int> >();
A_PATemplate PATemplate = new A_PATemplate();
TemplateItem.Add(int.Parse(ddlPAItem.SelectedValue.Trim()));
ItemSequence.Add(int.Parse(this.ddlSequence.SelectedValue.Trim()));
TemplateSection.Add(int.Parse(ddlPASection.SelectedValue.Trim()));
TemplateScore.Add(decimal.Parse(txtPAItemScore.Text.Trim()));
TemplateAmount.Add(decimal.Parse(txtPAItemAmount.Text.Trim()));
IsFirstReview.Add(cbFirstReview.Checked);
FirstReviewUserID.Add(int.Parse(ddlFirstReviewUserID.SelectedValue.Trim()));
IsSecondReview.Add(cbSecondReview.Checked);
SecondReviewUserID.Add(int.Parse(ddlSecondReviewUserID.SelectedValue.Trim()));
IsMultiReview.Add(cbMultiReview.Checked);
MultiReviewUserID.Add(getEachMultiReviewID(cblMultiReviewUserID));
PATemplate.A_PATemplateItem = TemplateItem;
PATemplate.A_PAItemSequence = ItemSequence;
PATemplate.A_PATemplateSection = TemplateSection;
PATemplate.A_PATemplateScore = TemplateScore;
PATemplate.A_PATemplateAmount = TemplateAmount;
PATemplate.A_PATemplateIsFirstReview = IsFirstReview;
PATemplate.A_PATemplateFirstReviewUserID = FirstReviewUserID;
PATemplate.A_PATemplateIsSecondReview = IsSecondReview;
PATemplate.A_PATemplateSecondReviewUserID = SecondReviewUserID;
PATemplate.A_PATemplateIsMultiReview = IsMultiReview;
PATemplate.A_PATemplateMultiReviewUserID = MultiReviewUserID;
PATemplate.A_PATemplateName = this.txtPATemplateName.Text.Trim();
if (base.Request["PATemplateId"] != null)
{
PATemplate.A_PATemplateID = Convert.ToInt32(base.Request["PATemplateId"]);
}
return(PATemplate);
}
protected A_PATemplate getSelectedDetail()
{
List <int> TemplateItem = new List <int>();
List <int> ItemSequence = new List <int>();
List <int> TemplateSection = new List <int>();
List <decimal> TemplateScore = new List <decimal>();
List <decimal> TemplateAmount = new List <decimal>();
List <bool> IsFirstReview = new List <bool>();
List <int> FirstReviewUserID = new List <int>();
List <bool> IsSecondReview = new List <bool>();
List <int> SecondReviewUserID = new List <int>();
List <bool> IsMultiReview = new List <bool>();
List <List <int> > MultiReviewUserID = new List <List <int> >();
A_PATemplate PATemplate = new A_PATemplate();
for (int i = 0; i < gvList.Rows.Count; i++)
{
CheckBox cbsSelect = gvList.Rows[i].FindControl("cbSelect") as CheckBox;
if (cbsSelect.Checked)
{
TemplateItem.Add(int.Parse(gvList.DataKeys[i].Value.ToString()));
DropDownList ddlItemSequence = gvList.Rows[i].FindControl("ddlSequence") as DropDownList;
ItemSequence.Add(int.Parse(ddlItemSequence.SelectedValue.ToString()));
DropDownList ddlPASection = gvList.Rows[i].FindControl("ddlPASection") as DropDownList;
TemplateSection.Add(int.Parse(ddlPASection.SelectedValue.ToString()));
TextBox txtScore = gvList.Rows[i].FindControl("txtPAItemScore") as TextBox;
TemplateScore.Add(decimal.Parse(txtScore.Text.Trim()));
TextBox txtAmount = gvList.Rows[i].FindControl("txtPAItemAmount") as TextBox;
TemplateAmount.Add(decimal.Parse(txtAmount.Text.Trim()));
ASPxCheckBox ASPxcbFirstReview = gvList.Rows[i].FindControl("ASPxcbFirstReview") as ASPxCheckBox;
IsFirstReview.Add(ASPxcbFirstReview.Checked);
DropDownList ddlFirstReviewUserID = gvList.Rows[i].FindControl("ddlFirstReviewUserID") as DropDownList;
FirstReviewUserID.Add(int.Parse(ddlFirstReviewUserID.SelectedValue.ToString()));
ASPxCheckBox ASPxcbSecondReview = gvList.Rows[i].FindControl("ASPxcbSecondReview") as ASPxCheckBox;
IsSecondReview.Add(ASPxcbSecondReview.Checked);
DropDownList ddlSecondReviewUserID = gvList.Rows[i].FindControl("ddlSecondReviewUserID") as DropDownList;
SecondReviewUserID.Add(int.Parse(ddlSecondReviewUserID.SelectedValue.ToString()));
ASPxCheckBox ASPxcbMultiReview = gvList.Rows[i].FindControl("ASPxcbMultiReview") as ASPxCheckBox;
IsMultiReview.Add(ASPxcbMultiReview.Checked);
ASPxListBox albMultiReview = gvList.Rows[i].FindControl("albMultiReview") as ASPxListBox;
MultiReviewUserID.Add(getEachMultiReviewID(albMultiReview));
}
}
PATemplate.A_PATemplateItem = TemplateItem;
PATemplate.A_PAItemSequence = ItemSequence;
PATemplate.A_PATemplateSection = TemplateSection;
PATemplate.A_PATemplateScore = TemplateScore;
PATemplate.A_PATemplateAmount = TemplateAmount;
PATemplate.A_PATemplateIsFirstReview = IsFirstReview;
PATemplate.A_PATemplateFirstReviewUserID = FirstReviewUserID;
PATemplate.A_PATemplateIsSecondReview = IsSecondReview;
PATemplate.A_PATemplateSecondReviewUserID = SecondReviewUserID;
PATemplate.A_PATemplateIsMultiReview = IsMultiReview;
PATemplate.A_PATemplateMultiReviewUserID = MultiReviewUserID;
PATemplate.A_PATemplateName = this.txtPATemplateName.Text.Trim();
if (base.Request["PATemplateId"] != null)
{
PATemplate.A_PATemplateID = Convert.ToInt32(base.Request["PATemplateId"]);
}
return(PATemplate);
}
protected void Page_Load(object sender, EventArgs e)
{
for (int i = 1; i <= 100; i++)
{
sequence.Add(i);
}
if (!base.IsPostBack)
{
ddlSequence.DataSource = sequence;
ddlSequence.DataBind();
ddlPAItem.DataSource = PAItemSer.GetTablePAItemList("");
ddlPAItem.DataTextField = "A_PAItemName";
ddlPAItem.DataValueField = "A_PAItemId";
ddlPAItem.DataBind();
PASection = this.PASectionSer.GetModelList("");
ddlPASection.DataSource = PASection;
ddlPASection.DataTextField = "A_PASectionName";
ddlPASection.DataValueField = "A_PASectionId";
ddlPASection.DataBind();
AllUserTable = UserSer.getUserTableByLoginName(" and loginStatus='在职'");
ddlFirstReviewUserID.DataSource = AllUserTable;
ddlFirstReviewUserID.DataTextField = "LoginName";
ddlFirstReviewUserID.DataValueField = "Id";
ddlFirstReviewUserID.DataBind();
ddlSecondReviewUserID.DataSource = AllUserTable;
ddlSecondReviewUserID.DataTextField = "LoginName";
ddlSecondReviewUserID.DataValueField = "Id";
ddlSecondReviewUserID.DataBind();
cblMultiReviewUserID.DataSource = AllUserTable;
cblMultiReviewUserID.DataTextField = "LoginName";
cblMultiReviewUserID.DataValueField = "Id";
cblMultiReviewUserID.DataBind();
if (base.Request["PATemplateId"] != null)
{
A_PATemplate PATemplate = this.PATemplateSer.GetModelList("A_PATemplateId=" + base.Request["PATemplateId"])[0];
this.txtPATemplateName.Text = PATemplate.A_PATemplateName;
PAItemDetail = this.PATemplateSer.GetDetailList(base.Request["PATemplateId"]);
this.gvList.DataSource = PAItemDetail;
this.gvList.DataBind();
#region SingleItemDisplay
if (base.Request["PAItemId"] != null)
{
SinglePAItem = PATemplateSer.GetTableTemplateItem(base.Request["PATemplateId"], base.Request["PAItemId"]);
ddlSequence.SelectedValue = SinglePAItem.Rows[0]["Sequence"].ToString();
ddlPASection.SelectedValue = SinglePAItem.Rows[0]["A_PASectionID"].ToString();
ddlPAItem.SelectedValue = SinglePAItem.Rows[0]["A_PAItemID"].ToString();
txtPAItemAmount.Text = SinglePAItem.Rows[0]["A_PAItemAmount"].ToString();
txtPAItemScore.Text = SinglePAItem.Rows[0]["A_PAItemScore"].ToString();
cbFirstReview.Checked = bool.Parse(SinglePAItem.Rows[0]["A_PAIsFirstReview"].ToString());
ddlFirstReviewUserID.SelectedValue = SinglePAItem.Rows[0]["A_PAFirstReviewUserID"].ToString();
cbSecondReview.Checked = bool.Parse(SinglePAItem.Rows[0]["A_PAIsSecondReview"].ToString());
ddlSecondReviewUserID.SelectedValue = SinglePAItem.Rows[0]["A_PASecondReviewUserID"].ToString();
cbMultiReview.Checked = bool.Parse(SinglePAItem.Rows[0]["A_PAIsMultiReview"].ToString());
SingleMultiUser = PATemplateSer.GetTableTemplateItemMultiUser(base.Request["PATemplateId"], base.Request["PAItemId"]);
for (int i = 0; i < cblMultiReviewUserID.Items.Count; i++)
{
for (int j = 0; j < SingleMultiUser.Rows.Count; j++)
{
if (cblMultiReviewUserID.Items[i].Value.ToString() == SingleMultiUser.Rows[j]["User_ID"].ToString())
{
cblMultiReviewUserID.Items[i].Selected = true;
}
}
}
if (bool.Parse(SinglePAItem.Rows[0]["A_PAIsFirstReview"].ToString()) == true || bool.Parse(SinglePAItem.Rows[0]["A_PAIsSecondReview"].ToString()) == true)
{
ddlFirstReviewUserID.Enabled = true;
ddlSecondReviewUserID.Enabled = true;
cbMultiReview.Checked = false;
cblMultiReviewUserID.Enabled = false;
}
else
{
ddlFirstReviewUserID.Enabled = false;
ddlSecondReviewUserID.Enabled = false;
cbFirstReview.Checked = false;
cbSecondReview.Checked = false;
cblMultiReviewUserID.Enabled = true;
}
}
#endregion
btnNameUpdate.Enabled = true;
}
else
{
btnNameUpdate.Enabled = false;
}
}
}
