public Procurementcontract CreateProcurementcontract(Procurementcontract info, List<Procurementcontractdetail> detailInfos)
{
var coderuleManagement = new CoderuleManagement(Management);
info.Contractid = coderuleManagement.GenerateCodeRule(Procurementcontract.RuleCode+DateTime.Today.ToString("yyyyMM"), false);
foreach (var detailInfo in detailInfos)
{
detailInfo.Contractid = info.Contractid;
}
var detailManagement = new ProcurementcontractdetailManagement(Management);
try
{
Management.BeginTransaction();
Management.CreateProcurementcontract(info);
foreach (var detailInfo in detailInfos)
{
detailManagement.CreateProcurementcontractdetail(detailInfo);
}
Management.Commit();
}
catch
{
Management.Rollback();
throw;
}
return info;
}
public Procurementcontract CreateProcurementcontract(Procurementcontract info)
{
try
{
Management.BeginTransaction();
Management.CreateProcurementcontract(info);
Management.Commit();
}
catch
{
Management.Rollback();
throw;
}
return info;
}
public Procurementcontract CreateProcurementcontract(Procurementcontract info)
{
try
{
string sqlCommand = @"INSERT INTO ""PROCUREMENTCONTRACT"" (""CONTRACTID"",""CONTENT"",""CREATEDDATE"",""CONTRACTDATE"",""SUPPLIER"",""OPERATOR"",""SUBCOMPANY"",""CREATOR"",""PSID"") VALUES (:Contractid,:Content,:Createddate,:Contractdate,:Supplier,:Operator,:Subcompany,:Creator,:Psid)";
this.Database.AddInParameter(":Contractid", info.Contractid);//DBType:VARCHAR2
this.Database.AddInParameter(":Content", info.Content);//DBType:NVARCHAR2
this.Database.AddInParameter(":Createddate", info.Createddate);//DBType:DATE
this.Database.AddInParameter(":Contractdate", info.Contractdate);//DBType:DATE
this.Database.AddInParameter(":Supplier", info.Supplier);//DBType:NVARCHAR2
this.Database.AddInParameter(":Operator", info.Operator);//DBType:NVARCHAR2
this.Database.AddInParameter(":Subcompany", info.Subcompany);//DBType:VARCHAR2
this.Database.AddInParameter(":Creator", info.Creator);//DBType:NVARCHAR2
this.Database.AddInParameter(":Psid", info.Psid);//DBType:VARCHAR2
this.Database.ExecuteNonQuery(sqlCommand);
}
finally
{
this.Database.ClearParameter();
}
return info;
}
protected void ReadEntityToControl(Procurementcontract headInfo)
{
litContractid.Text = headInfo.Contractid;//合同编号
//litContent.Text = headInfo.Content;//主要内容
if (headInfo.Createddate.HasValue)
{
litCreateddate.Text = headInfo.Createddate.Value.ToString(UiConst.DateFormat);//创建日期
}
if (headInfo.Contractdate.HasValue)
{
litContractdate.Text = headInfo.Contractdate.Value.ToString(UiConst.DateFormat); ;//签订日期
}
ucSelectSupplier.Supplierid = headInfo.Supplier;//供应商
//litOperator.Text = headInfo.Operator;//合同负责人
ucSubCompany.SubcompanyId = headInfo.Subcompany; //分公司
litCreator.Text = headInfo.Creator;//创建人
}
protected void ReadEntityToControl(Procurementcontract headInfo)
{
litPsid.Text = headInfo.Contractid;
if (headInfo.Contractdate.HasValue)
{
litContactscheduledate.Text = Convert.ToDateTime(headInfo.Contractdate.Value).ToString("yyyy-MM-dd"); ;
}
var info = this.AssetsupplierService.RetrieveAssetsupplierBySupplierid(headInfo.Supplier);
if (info != null)
{
lblSelectSupplier.Text = info.Suppliername;
}
var subcompanyinfoService = new SubcompanyinfoService();
decimal decSubcompanyId = 0;
if (decimal.TryParse(headInfo.Subcompany, out decSubcompanyId))
{
var infosubcompany = subcompanyinfoService.RetrieveSubcompanyinfoBySubcompanyid(decSubcompanyId);
if (infosubcompany != null)
{
lblSubCompany.Text = infosubcompany.Subcompanyname;
}
}
if (headInfo.Createddate.HasValue)
{
lblApplydate.Text = Convert.ToDateTime(headInfo.Createddate).ToString("yyyy-MM-dd");
}
}
public Procurementcontract UpdateProcurementcontractByContractid(Procurementcontract info, List<Procurementcontractdetail> detailInfos)
{
foreach (var detailInfo in detailInfos)
{
detailInfo.Contractid = info.Contractid;
}
var detailManagement = new ProcurementcontractdetailManagement(Management);
var dbContractDetails = detailManagement.RetrieveProcurementcontractdetailListByContractid(info.Contractid);
try
{
Management.BeginTransaction();
Management.UpdateProcurementcontractByContractid(info);
foreach (var detail in detailInfos)
{
var existInfo = dbContractDetails.Where(p => p.Contractdetailid == detail.Contractdetailid).FirstOrDefault();
if (existInfo == null)
{
detailManagement.CreateProcurementcontractdetail(detail);
}
else
{
detailManagement.UpdateProcurementcontractdetailByContractdetailid(detail);
}
}
Management.Commit();
}
catch
{
Management.Rollback();
throw;
}
return info;
}
public Procurementcontract UpdateProcurementcontractByContractid(Procurementcontract info)
{
try
{
this.Database.AddInParameter(":Contractid", info.Contractid);//DBType:VARCHAR2
this.Database.AddInParameter(":Content", info.Content);//DBType:NVARCHAR2
this.Database.AddInParameter(":Createddate", info.Createddate);//DBType:DATE
this.Database.AddInParameter(":Contractdate", info.Contractdate);//DBType:DATE
this.Database.AddInParameter(":Supplier", info.Supplier);//DBType:NVARCHAR2
this.Database.AddInParameter(":Operator", info.Operator);//DBType:NVARCHAR2
this.Database.AddInParameter(":Subcompany", info.Subcompany);//DBType:VARCHAR2
this.Database.AddInParameter(":Creator", info.Creator);//DBType:NVARCHAR2
this.Database.AddInParameter(":Psid", info.Psid);//DBType:VARCHAR2
string sqlCommand = @"UPDATE ""PROCUREMENTCONTRACT"" SET ""CONTENT""=:Content , ""CREATEDDATE""=:Createddate , ""CONTRACTDATE""=:Contractdate , ""SUPPLIER""=:Supplier , ""OPERATOR""=:Operator , ""SUBCOMPANY""=:Subcompany , ""CREATOR""=:Creator , ""PSID""=:Psid WHERE ""CONTRACTID""=:Contractid";
this.Database.ExecuteNonQuery(sqlCommand);
}
finally
{
this.Database.ClearParameter();
}
return info;
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnSave_Click(object sender, EventArgs e)
{
if (!ucContactscheduledate.DateValue.HasValue)
{
UIHelper.Alert(this, "请选择合同签订日期!");
return;
}
if (string.IsNullOrEmpty(ucSubCompany.SubcompanyId))
{
UIHelper.Alert(this, "请选择分公司!");
return;
}
if (string.IsNullOrEmpty(ucSelectSupplier.Supplierid))
{
UIHelper.Alert(this, "请选择供应商!");
return;
}
if (!ucApplydate.DateValue.HasValue)
{
UIHelper.Alert(this, "请选择创建日期!");
return;
}
Procurementcontract headInfo = null;
if (string.IsNullOrEmpty(Contractid))
{
//add
headInfo = new Procurementcontract();
WriteControlValueToEntity(headInfo);
this.ProcurementcontractService.CreateProcurementcontract(headInfo, ProcurementContractDetail);
}
else
{
//edit
headInfo = ProcurementcontractService.RetrieveProcurementcontractByContractid(Contractid);
if (headInfo == null) { UIHelper.Alert(this, "对不起，合同已被删除,请重新录入！"); return; }
WriteControlValueToEntity(headInfo);
ProcurementcontractService.UpdateProcurementcontractByContractid(headInfo, ProcurementContractDetail);
}
UIHelper.AlertMessageGoToURL(this, "保存成功!", ResolveUrl("~/Admin/ContractList.aspx"));
}
protected void WriteControlValueToEntity(Procurementcontract headInfo)
{
headInfo.Contractid = litPsid.Text;
headInfo.Contractdate = ucContactscheduledate.DateValue;
headInfo.Psid=PageUtility.GetQueryStringValue("Psid");
headInfo.Supplier = ucSelectSupplier.Supplierid;
headInfo.Subcompany = ucSubCompany.SubcompanyId;
headInfo.Createddate = ucApplydate.DateValue;
if (!headInfo.Createddate.HasValue)
{
headInfo.Createddate = DateTime.Now;
}
if(WebContext.Current.CurrentUser!=null)
{
headInfo.Creator = WebContext.Current.CurrentUser.Username;
}
}
protected void ReadEntityToControl(Procurementcontract headInfo)
{
litPsid.Text = headInfo.Contractid;
if (headInfo.Contractdate.HasValue)
{
ucContactscheduledate.DateValue = headInfo.Contractdate;
}
ucSelectSupplier.Supplierid = headInfo.Supplier;
ucSubCompany.SubcompanyId = headInfo.Subcompany;
if (headInfo.Createddate.HasValue)
{
ucApplydate.DateValue = headInfo.Createddate;
}
}
/// <summary>
/// 确定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
DateTime dateTime = DateTime.MinValue;
if (!ucContactscheduledate.DateValue.HasValue)
{
UIHelper.Alert(this, "请选择合同签订日期!");
return;
}
if (!ucApplydate.DateValue.HasValue)
{
UIHelper.Alert(this, "请选择创建日期!");
return;
}
if (ProcurementContractDetail.Count == 0)
{
UIHelper.Alert(this, "请录入合同明细！"); return;
}
Procurementcontract headInfo = null;
if (string.IsNullOrEmpty(Contractid))
{
//add
headInfo = new Procurementcontract();
WriteControlValueToEntity(headInfo);
this.ProcurementcontractService.CreateProcurementcontract(headInfo, ProcurementContractDetail);
}
else
{
//edit
headInfo = ProcurementcontractService.RetrieveProcurementcontractByContractid(Contractid);
if (headInfo == null) { UIHelper.Alert(this, "对不起，合同已被删除,请重新录入！"); return; }
WriteControlValueToEntity(headInfo);
ProcurementcontractService.UpdateProcurementcontractByContractid(headInfo, ProcurementContractDetail);
}
UIHelper.AlertMessageGoToURL(this, "提交成功!", ResolveUrl("~/Admin/ContractList.aspx"));
}