/// <summary>
/// 得到一个对象实体
/// </summary>
public List <A_PAUserTemplate> GetModelList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select U.ID,U.loginName,PA.A_PATemplateName ");
strSql.Append(" FROM tb_User U left join tb_UserPATemplate PU on U.ID=PU.UserID left join A_PATemplate PA on PU.PATemplateID=PA.A_PATemplateID");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
List <A_PAUserTemplate> PAUserTemplate = new List <A_PAUserTemplate>();
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn);
using (SqlDataReader dataReader = objCommand.ExecuteReader())
{
while (dataReader.Read())
{
A_PAUserTemplate model = new A_PAUserTemplate();
object ojb;
ojb = dataReader["ID"];
if (ojb != null && ojb != DBNull.Value)
{
model.UserID = (int)ojb;
}
PAUserTemplate.Add(model);
}
}
}
return(PAUserTemplate);
}
protected A_PAUserTemplate 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_PAUserTemplate PAUserTemplate = new A_PAUserTemplate();
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));
}
}
PAUserTemplate.UserID = int.Parse(base.Request["UserID"]);
PAUserTemplate.A_PATemplateItem = TemplateItem;
PAUserTemplate.A_Sequence = ItemSequence;
PAUserTemplate.A_PATemplateSection = TemplateSection;
PAUserTemplate.A_PATemplateScore = TemplateScore;
PAUserTemplate.A_PATemplateAmount = TemplateAmount;
PAUserTemplate.A_PATemplateIsFirstReview = IsFirstReview;
PAUserTemplate.A_PATemplateFirstReviewUserID = FirstReviewUserID;
PAUserTemplate.A_PATemplateIsSecondReview = IsSecondReview;
PAUserTemplate.A_PATemplateSecondReviewUserID = SecondReviewUserID;
PAUserTemplate.A_PATemplateIsMultiReview = IsMultiReview;
PAUserTemplate.A_PATemplateMultiReviewUserID = MultiReviewUserID;
return(PAUserTemplate);
}
/// <summary>
/// 插入临时一条数据
/// </summary>
public void SingleInsert(A_PAUserTemplate model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
string strSql3;
if (model.A_PATemplateItem.Count > 0)
{
strSql3 = "delete from tb_UserPAForm where UserID=" + model.UserID + " and PAItemID=" + model.A_PATemplateItem[0].ToString() + ";delete from tb_UserPAFormUser where UserID=" + model.UserID + " and ItemID=" + model.A_PATemplateItem[0].ToString();
object obj1 = DBHelp.ExeScalar(strSql3.ToString());
strSql3 = "Insert into tb_UserPAForm (UserID,PASectionID,PAItemID,Sequence,PAItemScore,PAItemAmount,IsFirstReview,FirstReviewUserID,IsSecondReview,SecondReviewUserID,IsMultiReview) values (" + model.UserID + "," + model.A_PATemplateSection[0].ToString() + "," + model.A_PATemplateItem[0].ToString() + "," + model.A_Sequence[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 obj2 = DBHelp.ExeScalar(strSql3.ToString());
for (int j = 0; j < model.A_PATemplateMultiReviewUserID[0].Count; j++)
{
strSql3 = "insert into tb_UserPAFormUser (UserID,SectionID,ItemID,ReviewID) values (" + model.UserID + "," + model.A_PATemplateSection[0].ToString() + "," + model.A_PATemplateItem[0].ToString() + "," + model.A_PATemplateMultiReviewUserID[0][j].ToString() + ")";
object obj3 = DBHelp.ExeScalar(strSql3.ToString());
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(A_PAUserTemplate model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.UserID != null)
{
strSql1.Append("A_PATemplateName,");
strSql2.Append("'" + model.UserID + "',");
}
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)
{
string strSql3 = "delete from A_PATemplateItem 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,A_PASectionID,A_PAItemID,A_PAItemScore,A_PAItemAmount,A_PAIsFirstReview,A_PAFirstReviewUserID,A_PAIsSecondReview,A_PASecondReviewUserID) values (" + PATemplateID.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() + ")";
object obj2 = DBHelp.ExeScalar(strSql3.ToString());
}
}
return(PATemplateID);
}
}
protected A_PAUserTemplate 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_PAUserTemplate PAUserTemplate = new A_PAUserTemplate();
TemplateItem.Add(int.Parse(ddlPAItem.SelectedValue.Trim()));
ItemSequence.Add(int.Parse(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));
PAUserTemplate.UserID = int.Parse(base.Request["UserID"]);
PAUserTemplate.A_PATemplateItem = TemplateItem;
PAUserTemplate.A_Sequence = ItemSequence;
PAUserTemplate.A_PATemplateSection = TemplateSection;
PAUserTemplate.A_PATemplateScore = TemplateScore;
PAUserTemplate.A_PATemplateAmount = TemplateAmount;
PAUserTemplate.A_PATemplateIsFirstReview = IsFirstReview;
PAUserTemplate.A_PATemplateFirstReviewUserID = FirstReviewUserID;
PAUserTemplate.A_PATemplateIsSecondReview = IsSecondReview;
PAUserTemplate.A_PATemplateSecondReviewUserID = SecondReviewUserID;
PAUserTemplate.A_PATemplateIsMultiReview = IsMultiReview;
PAUserTemplate.A_PATemplateMultiReviewUserID = MultiReviewUserID;
return(PAUserTemplate);
}
