private void Save()
{
PD_PROJECT_CONTRACT_Bll bll = new PD_PROJECT_CONTRACT_Bll();
if (base.Request["UpdatePK"] != null)
{
if (PublicDal.PageValidate.IsDecimal(base.Request["UpdatePK"]))
{
PD_PROJECT_CONTRACT_Model model = bll.GetModel(base.Request["UpdatePK"].ToString());
this.getModel(model);
bll.Update(model);
PageShowText.Refurbish("修改成功", this.Page);
}
}
else if (this.txtPD_PROJECT_CODE.Value != null)
{
PD_PROJECT_CONTRACT_Model model2 = new PD_PROJECT_CONTRACT_Model
{
PD_DB_LOOP = "1"
};
this.getModel(model2);
model2.PD_NOW_SERVERPK = PublicDal.SetCreateServiceStream(this.Page);
bll.Add(model2);
Const.DoSuccessNoClose("添加成功", this.Page.Request.Url.LocalPath + "?UpdatePK=" + model2.AUTO_NO, this.Page);
}
}
private void ShowInfo(string AUTO_NO)
{
PD_PROJECT_CONTRACT_Model model = new PD_PROJECT_CONTRACT_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;
this.txtPD_PROJECT_CODE.Value = model.PD_PROJECT_CODE;
this.txtPD_CONTRACT_TYPE.SelectedValue = model.PD_CONTRACT_TYPE;
this.txtPD_CONTRACT_NO.Value = model.PD_CONTRACT_NO;
this.txtPD_CONTRACT_DATE.Value = model.PD_CONTRACT_DATE.ToString();
this.txtPD_CONTRACT_COMPANY.Text = model.PD_CONTRACT_COMPANY;
this.txtPD_CONTRACT_MOENY.Value = model.PD_CONTRACT_MOENY.ToString();
this.txtPD_CONTRACT_MOENY_CHANGE.Value = model.PD_CONTRACT_MOENY_CHANGE.ToString();
this.txtPD_CONTRACT_ASK_LIMIT.Text = model.PD_CONTRACT_ASK_LIMIT;
this.txtPD_CONTRACT_ASK_PROCEED.Value = model.PD_CONTRACT_ASK_PROCEED;
this.txtPD_CONTRACT_ASK_PAYMENT.Text = model.PD_CONTRACT_ASK_PAYMENT;
this.txtPD_CONTRACT_NOTE.Text = model.PD_CONTRACT_NOTE;
this.txtPD_CONTRACT_NAME.Text = model.PD_CONTRACT_NAME;
this.txtPD_CONTRACT_TYPE.SelectedValue = model.PD_CONTRACT_TYPE;
this.ddlPD_YEAR.SelectedValue = model.PD_YEAR;
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 != null)) && (model.PD_CONTRACT_FILENAME_SYSTEM.Trim() != ""))
{
DataRow row = ds.Tables[0].NewRow();
row["AUTO_NO"] = model.AUTO_NO;
row["FILE_NAME"] = model.PD_CONTRACT_FILENAME;
row["FILE_SYSNAME"] = model.PD_CONTRACT_FILENAME_SYSTEM;
ds.Tables[0].Rows.Add(row);
}
this.json_btData.Value = PublicDal.DataToJSON(ds);
}
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);
}
}
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 DataDelete(string strPK)
{
try
{
PD_PROJECT_CONTRACT_Bll bll = new PD_PROJECT_CONTRACT_Bll();
new PD_CONTRACT_CHANGE_Bll().DeletePROJECT(bll.GetModel(base.Request["UpdatePK"].ToString()).PD_PROJECT_CODE);
bll.Delete(strPK);
Const.DoSuccessNoClose("删除成功", this.Page.Request.Url.LocalPath + "?UpdatePK=" + strPK + "&doType=look&strTitle=", this.Page);
}
catch (Exception exception)
{
this.el = new ExceptionLog.ExceptionLog();
this.el.ErrClassName = base.GetType().ToString();
this.el.ErrMessage = exception.Message.ToString();
this.el.ErrMethod = "DataDelete()";
this.el.WriteExceptionLog(true);
Const.OpenErrorPage("操作失败，请联系系统管理员！", this.Page);
}
}
private void BindBGList()
{
if (base.Request["UpdatePK"] != null)
{
DataSet list = new PD_PROJECT_CONTRACT_Bll().GetList(" pd_contract_no='" + Convert.ToInt32(base.Request["UpdatePK"]) + "'");
if (list != null)
{
this.gvResult.DataSource = list.Tables[0];
this.gvResult.DataBind();
}
}
}
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 DataDelete(string strPK)
{
try
{
PD_PROJECT_CONTRACT_Bll bll = new PD_PROJECT_CONTRACT_Bll();
new PD_CONTRACT_CHANGE_Bll().DeletePROJECT(bll.GetModel(strPK).PD_PROJECT_CODE);
bll.Delete(strPK);
if (this.Master.PageIndex > 1)
{
this.pageind = this.Master.PageIndex;
}
this.ShowData(this.Master.StrSelect);
}
catch (Exception exception)
{
this.el = new ExceptionLog.ExceptionLog();
this.el.ErrClassName = base.GetType().ToString();
this.el.ErrMessage = exception.Message.ToString();
this.el.ErrMethod = "DataDelete()";
this.el.WriteExceptionLog(true);
Const.OpenErrorPage("操作失败，请联系系统管理员！", 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);
}
