public void Add(PD_PROJECT_JGYS_Model model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into PD_PROJECT_JGYS(");
builder.Append("PD_PROJECT_CODE,PD_PROJECT_COMPLETE_DATE,PD_PROJECT_YSSQ_DATE,PD_PROJECT_YS_DATE,PD_PROJECT_YS_COMPANY,PD_PROJECT_YS_ZRR,PD_PROJECT_YS_NAME,PD_PROJECT_YS_SUGGEST,PD_PROJECT_YS_RESULT,PD_PROJECT_YS_CONDITION)");
builder.Append(" values (");
builder.Append(":PD_PROJECT_CODE,:PD_PROJECT_COMPLETE_DATE,:PD_PROJECT_YSSQ_DATE,:PD_PROJECT_YS_DATE,:PD_PROJECT_YS_COMPANY,:PD_PROJECT_YS_ZRR,:PD_PROJECT_YS_NAME,:PD_PROJECT_YS_SUGGEST,:PD_PROJECT_YS_RESULT,:PD_PROJECT_YS_CONDITION)");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 30), new OracleParameter(":PD_PROJECT_COMPLETE_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_YSSQ_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_YS_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_YS_COMPANY", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_YS_ZRR", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_YS_NAME", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_YS_SUGGEST", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_YS_RESULT", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_YS_CONDITION", OracleType.VarChar, 100) };
cmdParms[0].Value = model.PD_PROJECT_CODE;
cmdParms[1].Value = model.PD_PROJECT_COMPLETE_DATE;
cmdParms[2].Value = model.PD_PROJECT_YSSQ_DATE;
cmdParms[3].Value = model.PD_PROJECT_YS_DATE;
cmdParms[4].Value = model.PD_PROJECT_YS_COMPANY;
cmdParms[5].Value = model.PD_PROJECT_YS_ZRR;
cmdParms[6].Value = model.PD_PROJECT_YS_NAME;
cmdParms[7].Value = model.PD_PROJECT_YS_SUGGEST;
cmdParms[8].Value = model.PD_PROJECT_YS_RESULT;
cmdParms[9].Value = model.PD_PROJECT_YS_CONDITION;
DbHelperOra.ExecuteSql(builder.ToString(), cmdParms);
}
public List<PD_PROJECT_JGYS_Model> DataTableToList(DataTable dt)
{
List<PD_PROJECT_JGYS_Model> list = new List<PD_PROJECT_JGYS_Model>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PD_PROJECT_JGYS_Model item = new PD_PROJECT_JGYS_Model();
if (dt.Rows[i]["AUTO_NO"].ToString() != "")
{
item.AUTO_NO = int.Parse(dt.Rows[i]["AUTO_NO"].ToString());
}
item.PD_PROJECT_CODE = dt.Rows[i]["PD_PROJECT_CODE"].ToString();
if (dt.Rows[i]["PD_PROJECT_COMPLETE_DATE"].ToString() != "")
{
item.PD_PROJECT_COMPLETE_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_PROJECT_COMPLETE_DATE"].ToString()));
}
if (dt.Rows[i]["PD_PROJECT_YSSQ_DATE"].ToString() != "")
{
item.PD_PROJECT_YSSQ_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_PROJECT_YSSQ_DATE"].ToString()));
}
if (dt.Rows[i]["PD_PROJECT_YS_DATE"].ToString() != "")
{
item.PD_PROJECT_YS_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_PROJECT_YS_DATE"].ToString()));
}
item.PD_PROJECT_YS_COMPANY = dt.Rows[i]["PD_PROJECT_YS_COMPANY"].ToString();
item.PD_PROJECT_YS_ZRR = dt.Rows[i]["PD_PROJECT_YS_ZRR"].ToString();
item.PD_PROJECT_YS_NAME = dt.Rows[i]["PD_PROJECT_YS_NAME"].ToString();
item.PD_PROJECT_YS_SUGGEST = dt.Rows[i]["PD_PROJECT_YS_SUGGEST"].ToString();
item.PD_PROJECT_YS_RESULT = dt.Rows[i]["PD_PROJECT_YS_RESULT"].ToString();
item.PD_PROJECT_YS_CONDITION = dt.Rows[i]["PD_PROJECT_YS_CONDITION"].ToString();
list.Add(item);
}
}
return list;
}
public PD_PROJECT_JGYS_Model GetModel(string PD_PROJECT_CODE)
{
StringBuilder builder = new StringBuilder();
builder.Append("select AUTO_NO,PD_PROJECT_CODE,PD_PROJECT_COMPLETE_DATE,PD_PROJECT_YSSQ_DATE,PD_PROJECT_YS_DATE,PD_PROJECT_YS_COMPANY,PD_PROJECT_YS_ZRR,PD_PROJECT_YS_NAME,PD_PROJECT_YS_SUGGEST,PD_PROJECT_YS_RESULT,PD_PROJECT_YS_CONDITION from PD_PROJECT_JGYS ");
builder.Append(" where PD_PROJECT_CODE=:PD_PROJECT_CODE ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 30) };
cmdParms[0].Value = PD_PROJECT_CODE;
PD_PROJECT_JGYS_Model model = new PD_PROJECT_JGYS_Model();
DataSet set = DbHelperOra.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
if (set.Tables[0].Rows[0]["AUTO_NO"].ToString() != "")
{
model.AUTO_NO = int.Parse(set.Tables[0].Rows[0]["AUTO_NO"].ToString());
}
model.PD_PROJECT_CODE = set.Tables[0].Rows[0]["PD_PROJECT_CODE"].ToString();
if (set.Tables[0].Rows[0]["PD_PROJECT_COMPLETE_DATE"].ToString() != "")
{
model.PD_PROJECT_COMPLETE_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_PROJECT_COMPLETE_DATE"].ToString()));
}
if (set.Tables[0].Rows[0]["PD_PROJECT_YSSQ_DATE"].ToString() != "")
{
model.PD_PROJECT_YSSQ_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_PROJECT_YSSQ_DATE"].ToString()));
}
if (set.Tables[0].Rows[0]["PD_PROJECT_YS_DATE"].ToString() != "")
{
model.PD_PROJECT_YS_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_PROJECT_YS_DATE"].ToString()));
}
model.PD_PROJECT_YS_COMPANY = set.Tables[0].Rows[0]["PD_PROJECT_YS_COMPANY"].ToString();
model.PD_PROJECT_YS_ZRR = set.Tables[0].Rows[0]["PD_PROJECT_YS_ZRR"].ToString();
model.PD_PROJECT_YS_NAME = set.Tables[0].Rows[0]["PD_PROJECT_YS_NAME"].ToString();
model.PD_PROJECT_YS_SUGGEST = set.Tables[0].Rows[0]["PD_PROJECT_YS_SUGGEST"].ToString();
model.PD_PROJECT_YS_RESULT = set.Tables[0].Rows[0]["PD_PROJECT_YS_RESULT"].ToString();
model.PD_PROJECT_YS_CONDITION = set.Tables[0].Rows[0]["PD_PROJECT_YS_CONDITION"].ToString();
return model;
}
public bool Update(PD_PROJECT_JGYS_Model model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update PD_PROJECT_JGYS set ");
builder.Append("PD_PROJECT_COMPLETE_DATE=:PD_PROJECT_COMPLETE_DATE,");
builder.Append("PD_PROJECT_YSSQ_DATE=:PD_PROJECT_YSSQ_DATE,");
builder.Append("PD_PROJECT_YS_DATE=:PD_PROJECT_YS_DATE,");
builder.Append("PD_PROJECT_YS_COMPANY=:PD_PROJECT_YS_COMPANY,");
builder.Append("PD_PROJECT_YS_ZRR=:PD_PROJECT_YS_ZRR,");
builder.Append("PD_PROJECT_YS_NAME=:PD_PROJECT_YS_NAME,");
builder.Append("PD_PROJECT_YS_SUGGEST=:PD_PROJECT_YS_SUGGEST,");
builder.Append("PD_PROJECT_YS_RESULT=:PD_PROJECT_YS_RESULT,");
builder.Append("PD_PROJECT_YS_CONDITION=:PD_PROJECT_YS_CONDITION");
builder.Append(" where PD_PROJECT_CODE=:PD_PROJECT_CODE ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_COMPLETE_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_YSSQ_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_YS_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_YS_COMPANY", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_YS_ZRR", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_YS_NAME", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_YS_SUGGEST", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_YS_RESULT", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_YS_CONDITION", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 30) };
cmdParms[0].Value = model.PD_PROJECT_COMPLETE_DATE;
cmdParms[1].Value = model.PD_PROJECT_YSSQ_DATE;
cmdParms[2].Value = model.PD_PROJECT_YS_DATE;
cmdParms[3].Value = model.PD_PROJECT_YS_COMPANY;
cmdParms[4].Value = model.PD_PROJECT_YS_ZRR;
cmdParms[5].Value = model.PD_PROJECT_YS_NAME;
cmdParms[6].Value = model.PD_PROJECT_YS_SUGGEST;
cmdParms[7].Value = model.PD_PROJECT_YS_RESULT;
cmdParms[8].Value = model.PD_PROJECT_YS_CONDITION;
cmdParms[9].Value = model.PD_PROJECT_CODE;
return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
private void UpdateDateJGYS(string PD_OROHECT_CODE)
{
string strErr = "";
if (!this.Panduan_JGYS(ref strErr))
{
this.hy_File(null, strErr);
}
else
{
string text = this.lblPD_PROJECT_CODE.Text;
DateTime time = DateTime.Parse(this.txtPD_PROJECT_COMPLETE_DATE.Value);
DateTime time2 = DateTime.Parse(this.txtPD_PROJECT_YSSQ_DATE.Value);
DateTime time3 = DateTime.Parse(this.txtPD_PROJECT_YS_DATE.Value);
string selectedValue = this.ddlPD_PROJECT_YS_COMPANY.SelectedValue;
string str4 = this.txtPD_PROJECT_YS_ZRR.Text;
string str5 = this.txtPD_PROJECT_YS_NAME.Text;
string str6 = this.txtPD_PROJECT_YS_SUGGEST.Text;
string str7 = this.ddlPD_PROJECT_YS_RESULT.SelectedItem.Text;
string str8 = this.txtPD_PROJECT_YS_CONDITION.Text;
PD_PROJECT_JGYS_Model model = new PD_PROJECT_JGYS_Model
{
PD_PROJECT_CODE = text,
PD_PROJECT_COMPLETE_DATE = new DateTime?(time),
PD_PROJECT_YSSQ_DATE = new DateTime?(time2),
PD_PROJECT_YS_DATE = new DateTime?(time3),
PD_PROJECT_YS_COMPANY = selectedValue,
PD_PROJECT_YS_ZRR = str4,
PD_PROJECT_YS_NAME = str5,
PD_PROJECT_YS_SUGGEST = str6,
PD_PROJECT_YS_RESULT = str7,
PD_PROJECT_YS_CONDITION = str8
};
PD_PROJECT_APPRAISE_Model model2 = new PD_PROJECT_APPRAISE_Model();
string str9 = this.txtAUTO_NO_APPRAISE.Text;
string str10 = this.txtPD_PROJECT_APP_COMPANY.Text;
string str11 = this.txtPD_PROJECT_APP_COMPANY_LIST.Text;
string str12 = this.txtPD_PROJECT_APP_MAN_LIST.Text;
string str13 = this.txtPD_PROJECT_APPRAISE_FILENO.Text;
if (!PublicDal.PageValidate.IsNumber(str9))
{
str9 = "-1";
}
model2.AUTO_NO = int.Parse(str9);
model2.PD_PROJECT_CODE = text;
model2.PD_PROJECT_APP_COMPANY = str10;
model2.PD_PROJECT_APP_COMPANY_LIST = str11;
model2.PD_PROJECT_APP_MAN_LIST = str12;
model2.PD_PROJECT_APPRAISE_FILENO = str13;
PD_PROJECT_JGYS_Bll bll = new PD_PROJECT_JGYS_Bll();
if (bll.Exists(text))
{
bll.Update(model);
}
else
{
bll.Add(model);
}
PD_PROJECT_APPRAISE_Bll bll2 = new PD_PROJECT_APPRAISE_Bll();
if (bll2.Exists(text))
{
bll2.Update(model2);
}
else
{
bll2.Add(model2);
}
this.UpdateDateXMPJ(PD_OROHECT_CODE);
PageShowText.Refurbish("修改成功", this.Page);
}
}
private void CreateData_JGYS()
{
string strErr = "";
if (!this.Panduan_JGYS(ref strErr))
{
this.hy_File(null, strErr);
}
else
{
string text = this.lblPD_PROJECT_CODE.Text;
DateTime time = DateTime.Parse(this.txtPD_PROJECT_COMPLETE_DATE.Value);
DateTime time2 = DateTime.Parse(this.txtPD_PROJECT_YSSQ_DATE.Value);
DateTime time3 = DateTime.Parse(this.txtPD_PROJECT_YS_DATE.Value);
string selectedValue = this.ddlPD_PROJECT_YS_COMPANY.SelectedValue;
string str4 = this.txtPD_PROJECT_YS_ZRR.Text;
string str5 = this.txtPD_PROJECT_YS_NAME.Text;
string str6 = this.txtPD_PROJECT_YS_SUGGEST.Text;
string str7 = this.ddlPD_PROJECT_YS_RESULT.SelectedItem.Text;
string str8 = this.txtPD_PROJECT_YS_CONDITION.Text;
PD_PROJECT_JGYS_Model model = new PD_PROJECT_JGYS_Model
{
PD_PROJECT_CODE = text,
PD_PROJECT_COMPLETE_DATE = new DateTime?(time),
PD_PROJECT_YSSQ_DATE = new DateTime?(time2),
PD_PROJECT_YS_DATE = new DateTime?(time3),
PD_PROJECT_YS_COMPANY = selectedValue,
PD_PROJECT_YS_ZRR = str4,
PD_PROJECT_YS_NAME = str5,
PD_PROJECT_YS_SUGGEST = str6,
PD_PROJECT_YS_RESULT = str7,
PD_PROJECT_YS_CONDITION = str8
};
PD_PROJECT_APPRAISE_Model model2 = new PD_PROJECT_APPRAISE_Model();
string str9 = this.txtAUTO_NO_APPRAISE.Text;
string str10 = this.txtPD_PROJECT_APP_COMPANY.Text;
string str11 = this.txtPD_PROJECT_APP_COMPANY_LIST.Text;
string str12 = this.txtPD_PROJECT_APP_MAN_LIST.Text;
string str13 = this.txtPD_PROJECT_APPRAISE_FILENO.Text;
if (!PublicDal.PageValidate.IsNumber(str9))
{
str9 = "-1";
}
model2.AUTO_NO = int.Parse(str9);
model2.PD_PROJECT_CODE = text;
model2.PD_PROJECT_APP_COMPANY = str10;
model2.PD_PROJECT_APP_COMPANY_LIST = str11;
model2.PD_PROJECT_APP_MAN_LIST = str12;
model2.PD_PROJECT_APPRAISE_FILENO = str13;
new PD_PROJECT_JGYS_Bll().Add(model);
new PD_PROJECT_APPRAISE_Bll().Add(model2);
this.UpdateDateXMPJ("");
Const.DoSuccessNoClose("添加成功", this.Page.Request.Url.LocalPath + "?UpdatePK=" + model.PD_PROJECT_CODE, this.Page);
}
}
protected void btnAddSave_Click(object sender, EventArgs e)
{
string text = this.lblPD_PROJECT_CODE.Text;
DateTime time = DateTime.Parse(this.txtPD_PROJECT_COMPLETE_DATE.Value);
DateTime time2 = DateTime.Parse(this.txtPD_PROJECT_YSSQ_DATE.Value);
DateTime time3 = DateTime.Parse(this.txtPD_PROJECT_YS_DATE.Value);
string selectedValue = this.ddlPD_PROJECT_YS_COMPANY.SelectedValue;
string str3 = this.txtPD_PROJECT_YS_ZRR.Text;
string str4 = this.txtPD_PROJECT_YS_NAME.Text;
string str5 = this.txtPD_PROJECT_YS_SUGGEST.Text;
string str6 = this.ddlPD_PROJECT_YS_RESULT.SelectedItem.Text;
string str7 = this.txtPD_PROJECT_YS_CONDITION.Text;
PD_PROJECT_JGYS_Model model = new PD_PROJECT_JGYS_Model
{
PD_PROJECT_CODE = text,
PD_PROJECT_COMPLETE_DATE = new DateTime?(time),
PD_PROJECT_YSSQ_DATE = new DateTime?(time2),
PD_PROJECT_YS_DATE = new DateTime?(time3),
PD_PROJECT_YS_COMPANY = selectedValue,
PD_PROJECT_YS_ZRR = str3,
PD_PROJECT_YS_NAME = str4,
PD_PROJECT_YS_SUGGEST = str5,
PD_PROJECT_YS_RESULT = str6,
PD_PROJECT_YS_CONDITION = str7
};
new PD_PROJECT_JGYS_Bll().Add(model);
PageShowText.Refurbish("添加成功", this.Page);
}
public void Add(PD_PROJECT_JGYS_Model model)
{
this.dal.Add(model);
}
public bool Update(PD_PROJECT_JGYS_Model model)
{
return this.dal.Update(model);
}
private PD_PROJECT_JGYS_Model getModer_jgys(PD_PROJECT_JGYS_Model model, string PD_PROJECT_CODE)
{
if (model == null)
{
model = new PD_PROJECT_JGYS_Model();
}
model.PD_PROJECT_CODE = PD_PROJECT_CODE;
if (PublicDal.PageValidate.IsDateTime(this.txtPD_PROJECT_COMPLETE_DATE.Value))
{
model.PD_PROJECT_COMPLETE_DATE = new DateTime?(DateTime.Parse(this.txtPD_PROJECT_COMPLETE_DATE.Value));
}
if (PublicDal.PageValidate.IsDateTime(this.txtPD_PROJECT_YSSQ_DATE.Value))
{
model.PD_PROJECT_YSSQ_DATE = new DateTime?(DateTime.Parse(this.txtPD_PROJECT_YSSQ_DATE.Value));
}
if (PublicDal.PageValidate.IsDateTime(this.txtPD_PROJECT_YS_DATE.Value))
{
model.PD_PROJECT_YS_DATE = new DateTime?(DateTime.Parse(this.txtPD_PROJECT_YS_DATE.Value));
}
model.PD_PROJECT_YS_COMPANY = this.ddlPD_PROJECT_YS_COMPANY.SelectedValue;
model.PD_PROJECT_YS_ZRR = this.txtPD_PROJECT_YS_ZRR.Text;
model.PD_PROJECT_YS_NAME = this.txtPD_PROJECT_YS_NAME.Text;
model.PD_PROJECT_YS_SUGGEST = this.txtPD_PROJECT_YS_SUGGEST.Text;
model.PD_PROJECT_YS_RESULT = this.ddlPD_PROJECT_YS_RESULT.SelectedItem.Text;
model.PD_PROJECT_YS_CONDITION = this.txtPD_PROJECT_YS_CONDITION.Text;
return model;
}
