private void Save()
{
PD_CONTRACT_CHANGE_Bll bll = new PD_CONTRACT_CHANGE_Bll();
if (base.Request["UpdatePK"] != null)
{
if (PublicDal.PageValidate.IsDecimal(base.Request["UpdatePK"]))
{
PD_CONTRACT_CHANGE_Model model = bll.GetModel(int.Parse(base.Request["UpdatePK"].ToString()));
this.getModel(model);
bll.Update(model);
PageShowText.Refurbish("修改成功", this.Page);
}
}
else if (this.txtPD_PROJECT_CODE.Value != null)
{
PD_CONTRACT_CHANGE_Model model2 = new PD_CONTRACT_CHANGE_Model
{
PD_DB_LOOP = "1",
PD_NOW_SERVERPK = PublicDal.SetCreateServiceStream(this.Page)
};
this.getModel(model2);
bll.Add(model2);
Const.DoSuccessNoClose("添加成功", this.Page.Request.Url.LocalPath + "?UpdatePK=" + model2.AUTO_NO, this.Page);
}
}
private void ShowInfo(int AUTO_NO)
{
PD_CONTRACT_CHANGE_Model model = new PD_CONTRACT_CHANGE_Bll().GetModel(AUTO_NO);
TB_PROJECT_Model model2 = new TB_PROJECT_Bll().GetModel(model.PD_PROJECT_CODE);
this.txtPD_PROJECT_Name.Value = model2.PD_PROJECT_NAME;
this.lblAUTO_NO.Text = model.AUTO_NO.ToString();
this.txtPD_PROJECT_CODE.Value = model.PD_PROJECT_CODE;
this.txtPD_CONTRACT_CHANGE_DATE.Value = model.PD_CONTRACT_CHANGE_DATE.ToString();
this.txtPD_CONTRACT_CHANGE_TYPE.SelectedValue = model.PD_CONTRACT_CHANGE_TYPE;
this.txtPD_CONTRACT_CHANGE_REASON.Text = model.PD_CONTRACT_CHANGE_REASON;
this.txtPD_CONTRACT_TYPE.SelectedValue = model.PD_CONTRACT_TYPE;
this.txtPD_CONTRACT_NO.Value = model.PD_CONTRACT_NO;
this.txtPD_CONTRACT_NO_Name.Value = model.PD_CONTRACT_NO_Name;
this.txtPD_CONTRACT_MONEY.Value = model.PD_CONTRACT_MONEY.ToString();
this.txtPD_CONTRACT_CHANGE_ZJ.Value = model.PD_CONTRACT_CHANGE_ZJ;
this.txtPD_CONTRACT_CHANGE_MONEY.Value = model.PD_CONTRACT_CHANGE_MONEY.ToString();
this.txtPD_CONTRACT_CHANGE_WH.Value = model.PD_CONTRACT_CHANGE_WH.ToString();
this.ddlPD_YEAR.SelectedValue = model.PD_YEAR.ToString();
DataSet ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add("AUTO_NO");
ds.Tables[0].Columns.Add("FILE_NAME");
ds.Tables[0].Columns.Add("FILE_SYSNAME");
if (((model != null) && (model.PD_CONTRACT_FILENAME_SYSTEM_SQ != null)) && (model.PD_CONTRACT_FILENAME_SYSTEM_SQ.Trim() != ""))
{
DataRow row = ds.Tables[0].NewRow();
row["AUTO_NO"] = model.AUTO_NO;
row["FILE_NAME"] = model.PD_CONTRACT_CHANGE_FILENAME_SQ;
row["FILE_SYSNAME"] = model.PD_CONTRACT_FILENAME_SYSTEM_SQ;
ds.Tables[0].Rows.Add(row);
}
this.json_btData.Value = PublicDal.DataToJSON(ds);
}
private void UpdateSave()
{
PD_PROJECT_CONTRACT_Bll bll = new PD_PROJECT_CONTRACT_Bll();
PD_CONTRACT_CHANGE_Bll bll2 = new PD_CONTRACT_CHANGE_Bll();
if ((base.Request["UpdatePK"] != null) && PublicDal.PageValidate.IsDecimal(base.Request["UpdatePK"]))
{
PD_PROJECT_CONTRACT_Model model = bll.GetModel(base.Request["UpdatePK"].ToString());
model.PD_DB_LOOP = "1";
PD_CONTRACT_CHANGE_Model model2 = new PD_CONTRACT_CHANGE_Model();
PD_PROJECT_CONTRACT_BAK_Bll bll3 = new PD_PROJECT_CONTRACT_BAK_Bll();
this.getModel(model, model2);
model.PD_NOW_SERVERPK = PublicDal.SetCreateServiceStream(this.Page);
bll.Update(model);
model2.PD_NOW_SERVERPK = PublicDal.SetCreateServiceStream(this.Page);
this.getModel_BG(model2, model);
decimal? maxID = bll3.GetMaxID(model.PD_CONTRACT_NO);
if (maxID.HasValue)
{
model2.CONTR_CHANGE_MIAN_ID = maxID.Value;
}
model2.AUTO_NO = auto_nos;
bll2.Update(model2);
Const.DoSuccessNoClose("修改成功", this.Page.Request.Url.LocalPath + "?UpdatePK=" + model.AUTO_NO + "&doType=look&strTitle=", this.Page);
}
}
private void ShowInfo(int AUTO_NO, int AUTO_NO_BG)
{
decimal iD = -1M;
if (AUTO_NO_BG != -1)
{
PD_CONTRACT_CHANGE_Model model = new PD_CONTRACT_CHANGE_Bll().GetModel(AUTO_NO_BG);
if (model == null)
{
return;
}
iD = model.CONTR_CHANGE_MIAN_ID;
if (model.PD_CONTRACT_CHANGE_DATE.HasValue)
{
this.txtPD_CONTRACT_CHANGE_DATE.Value = model.PD_CONTRACT_CHANGE_DATE.Value.ToString("yyyy/MM/dd");
}
if (model.PD_CONTRACT_CHANGE_TYPE == null)
{
this.txtPD_CONTRACT_CHANGE_TYPE.SelectedIndex = 0;
}
else
{
this.txtPD_CONTRACT_CHANGE_TYPE.SelectedValue = model.PD_CONTRACT_CHANGE_TYPE;
}
this.txtPD_CONTRACT_CHANGE_REASON.Value = model.PD_CONTRACT_CHANGE_REASON;
this.txtPD_CONTRACT_TYPE.SelectedValue = model.PD_CONTRACT_TYPE;
this.txtPD_CONTRACT_NO.Value = model.PD_CONTRACT_NO;
this.txtPD_CONTRACT_CHANGE_WH.Value = model.PD_CONTRACT_CHANGE_WH.ToString();
if (model.PD_YEAR != "")
{
this.ddlPD_YEAR.SelectedValue = model.PD_YEAR.ToString();
}
DataSet ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add("AUTO_NO");
ds.Tables[0].Columns.Add("FILE_NAME");
ds.Tables[0].Columns.Add("FILE_SYSNAME");
if (((model != null) && (model.PD_CONTRACT_FILENAME_SYSTEM_SQ != null)) && (model.PD_CONTRACT_FILENAME_SYSTEM_SQ.Trim() != ""))
{
DataRow row = ds.Tables[0].NewRow();
row["AUTO_NO"] = model.AUTO_NO;
row["FILE_NAME"] = model.PD_CONTRACT_CHANGE_FILENAME_SQ;
row["FILE_SYSNAME"] = model.PD_CONTRACT_FILENAME_SYSTEM_SQ;
ds.Tables[0].Rows.Add(row);
}
this.json_btData2.Value = base.Server.UrlEncode(PublicDal.DataToJSON(ds));
}
PD_PROJECT_CONTRACT_BAK_Model model2 = new PD_PROJECT_CONTRACT_BAK_Bll().GetModel(iD);
TB_PROJECT_Bll bll3 = new TB_PROJECT_Bll();
if (model2 != null)
{
TB_PROJECT_Model model3 = bll3.GetModel(model2.PD_PROJECT_CODE);
this.txtPD_PROJECT_Name.Value = model3.PD_PROJECT_NAME;
this.lblAUTO_NO.Text = model2.ID.ToString("0");
this.txtPD_PROJECT_CODE.Value = model2.PD_PROJECT_CODE;
this.txtPD_CONTRACT_TYPE.SelectedValue = model2.PD_CONTRACT_TYPE;
this.txtPD_CONTRACT_NO.Value = model2.PD_CONTRACT_NO;
this.txtPD_CONTRACT_DATE.Value = model2.PD_CONTRACT_DATE.ToString();
this.txtPD_CONTRACT_COMPANY.Text = model2.PD_CONTRACT_COMPANY;
this.txtPD_CONTRACT_MOENY.Value = model2.PD_CONTRACT_MOENY.ToString();
this.txtPD_CONTRACT_ASK_LIMIT.Text = model2.PD_CONTRACT_ASK_LIMIT;
this.txtPD_CONTRACT_ASK_PROCEED.Value = model2.PD_CONTRACT_ASK_PROCEED;
this.txtPD_CONTRACT_ASK_PAYMENT.Text = model2.PD_CONTRACT_ASK_PAYMENT;
this.txtPD_CONTRACT_NOTE.Text = model2.PD_CONTRACT_NOTE;
this.txtPD_CONTRACT_NAME.Text = model2.PD_CONTRACT_NAME;
this.txtPD_CONTRACT_TYPE.SelectedValue = model2.PD_CONTRACT_TYPE;
if (model2.PD_YEAR.HasValue)
{
this.ddlPD_YEAR.SelectedValue = model2.PD_YEAR.Value.ToString();
}
DataSet set2 = new DataSet();
set2.Tables.Add();
set2.Tables[0].Columns.Add("AUTO_NO");
set2.Tables[0].Columns.Add("FILE_NAME");
set2.Tables[0].Columns.Add("FILE_SYSNAME");
if (((model2 != null) && (model2.PD_CONTRACT_FILENAME_SYSTEM != null)) && (model2.PD_CONTRACT_FILENAME_SYSTEM.Trim() != ""))
{
DataRow row2 = set2.Tables[0].NewRow();
row2["AUTO_NO"] = model2.ID;
row2["FILE_NAME"] = model2.PD_CONTRACT_FILENAME;
row2["FILE_SYSNAME"] = model2.PD_CONTRACT_FILENAME_SYSTEM;
set2.Tables[0].Rows.Add(row2);
}
this.json_btData.Value = base.Server.UrlEncode(PublicDal.DataToJSON(set2));
}
}
private void Save()
{
PD_PROJECT_CONTRACT_Bll bll = new PD_PROJECT_CONTRACT_Bll();
PD_CONTRACT_CHANGE_Bll bll2 = new PD_CONTRACT_CHANGE_Bll();
if (base.Request["UpdatePK"] != null)
{
if (PublicDal.PageValidate.IsDecimal(base.Request["UpdatePK"]))
{
PD_PROJECT_CONTRACT_Model model = bll.GetModel(base.Request["UpdatePK"].ToString());
PD_CONTRACT_CHANGE_Model model2 = new PD_CONTRACT_CHANGE_Model();
PD_PROJECT_CONTRACT_BAK_Bll bll3 = new PD_PROJECT_CONTRACT_BAK_Bll();
this.getModel(model, model2);
if (bll.Update(model))
{
decimal? maxID = bll3.GetMaxID(model.PD_CONTRACT_NO);
if (maxID.HasValue)
{
model2.CONTR_CHANGE_MIAN_ID = maxID.Value;
}
bll2.Add(model2);
}
Const.DoSuccessNoClose("合同变更成功", this.Page.Request.Url.LocalPath + "?UpdatePK=" + base.Request["UpdatePK"].ToString() + "&doType=look&strTitle=" + base.Request["strTitle"].ToString(), this.Page);
this.Master.btModel.IfUpdate = true;
}
}
else if (this.txtPD_PROJECT_CODE.Value != null)
{
PD_PROJECT_CONTRACT_Model model3 = new PD_PROJECT_CONTRACT_Model
{
PD_DB_LOOP = "1"
};
PD_CONTRACT_CHANGE_Model model4 = new PD_CONTRACT_CHANGE_Model();
PD_PROJECT_CONTRACT_BAK_Bll bll4 = new PD_PROJECT_CONTRACT_BAK_Bll();
this.getModel(model3, model4);
model3.PD_NOW_SERVERPK = PublicDal.SetCreateServiceStream(this.Page);
bll.Add(model3);
model4.PD_NOW_SERVERPK = PublicDal.SetCreateServiceStream(this.Page);
this.getModel_BG(model4, model3);
decimal? nullable2 = bll4.GetMaxID(model3.PD_CONTRACT_NO);
if (nullable2.HasValue)
{
model4.CONTR_CHANGE_MIAN_ID = nullable2.Value;
}
bll2.Add(model4);
Const.DoSuccessNoClose("添加成功", this.Page.Request.Url.LocalPath + "?UpdatePK=" + model3.AUTO_NO + "&doType=look&strTitle=", this.Page);
}
}
public void Deleted(string auto_no)
{
PD_PROJECT_CONTRACT_Bll bll = new PD_PROJECT_CONTRACT_Bll();
new PD_CONTRACT_CHANGE_Bll();
PD_CONTRACT_CHANGE_Bll bll2 = new PD_CONTRACT_CHANGE_Bll();
if (bll2.Delete(long.Parse(auto_no)))
{
string sQLString = " select * from PD_PROJECT_CONTRACT_BAK ORDER by id desc ";
DataTable table = DbHelperOra.Query(sQLString).Tables[0];
PD_PROJECT_CONTRACT_Model model = bll.GetModel(base.Request["UpdatePK"].ToString());
model.PD_DB_LOOP = "1";
new PD_CONTRACT_CHANGE_Model();
model.PD_CONTRACT_ASK_PROCEED = table.Rows[0]["PD_CONTRACT_ASK_PROCEED"].ToString();
model.PD_CONTRACT_ASK_PAYMENT = table.Rows[0]["PD_CONTRACT_ASK_PAYMENT"].ToString();
model.PD_CONTRACT_NAME = table.Rows[0]["PD_CONTRACT_NAME"].ToString();
model.PD_CONTRACT_MOENY = new decimal?(decimal.Parse(table.Rows[0]["PD_CONTRACT_MOENY"].ToString()));
model.PD_CONTRACT_MOENY_CHANGE = new decimal?(decimal.Parse(table.Rows[0]["PD_CONTRACT_MOENY_CHANGE"].ToString()));
model.PD_CONTRACT_ASK_LIMIT = table.Rows[0]["PD_CONTRACT_ASK_LIMIT"].ToString();
model.PD_CONTRACT_ASK_PROCEED = table.Rows[0]["PD_CONTRACT_ASK_PROCEED"].ToString();
model.PD_CONTRACT_ASK_PAYMENT = table.Rows[0]["PD_CONTRACT_ASK_PAYMENT"].ToString();
model.PD_CONTRACT_NOTE = table.Rows[0]["PD_CONTRACT_NOTE"].ToString();
bll.Update(model);
Const.DoSuccessNoClose("删除成功", this.Page.Request.Url.LocalPath + "?UpdatePK=" + model.AUTO_NO + "&doType=look&strTitle=", this.Page);
}
}
private void Bind(string PD_PROJECT_CODE)
{
DataSet list = new PD_CONTRACT_CHANGE_Bll().GetList(" PD_PROJECT_CODE='" + PD_PROJECT_CODE + "'");
this.jsonData_htbggl = PublicDal.DataToJSON(list);
if (list.Tables[0].Rows.Count > 0)
{
list.Tables[0].Rows.Clear();
}
DataRow row = list.Tables[0].NewRow();
row["PD_PROJECT_CODE"] = PD_PROJECT_CODE;
list.Tables[0].Rows.Add(row);
this.json_htbggl = PublicDal.DataToJSON(list);
DataSet ds = new PD_PROJECT_CONTRACT_Bll().GetList(" PD_PROJECT_CODE='" + PD_PROJECT_CODE + "'");
this.jsonData_htgl = PublicDal.DataToJSON(ds);
if (ds.Tables[0].Rows.Count > 0)
{
ds.Tables[0].Rows.Clear();
}
DataRow row2 = ds.Tables[0].NewRow();
ds.Tables[0].Rows.Add(row2);
this.json_htgl = PublicDal.DataToJSON(ds);
DataSet set3 = new PD_PROJECT_ATTACH_SS_Bll().GetList(" PD_PROJECT_CODE='" + PD_PROJECT_CODE + "'");
this.jsonData_xmsszl = PublicDal.DataToJSON(set3);
if (set3.Tables[0].Rows.Count > 0)
{
set3.Tables[0].Rows.Clear();
}
DataRow row3 = set3.Tables[0].NewRow();
row3[1] = PD_PROJECT_CODE;
set3.Tables[0].Rows.Add(row3);
this.json_xmsszl = PublicDal.DataToJSON(set3);
DataSet set4 = new PD_PROJECT_INSPECTION_Bll().GetList(" PD_PROJECT_CODE='" + PD_PROJECT_CODE + "'");
this.jsonData_xmccxc = PublicDal.DataToJSON(set4);
if (set4.Tables[0].Rows.Count > 0)
{
set4.Tables[0].Rows.Clear();
}
DataRow row4 = set4.Tables[0].NewRow();
row4[1] = PD_PROJECT_CODE;
set4.Tables[0].Rows.Add(row4);
this.json_xmccxc = PublicDal.DataToJSON(set4);
}
