public Procurementschedulehead CreateProcurementschedulehead(Procurementschedulehead info) { try { string sqlCommand = @"INSERT INTO ""PROCUREMENTSCHEDULEHEAD"" (""PSID"",""PROCUREMENTSCHEDULEDATE"",""REASON"",""SUBCOMPANY"",""APPLYUSER"",""APPLYDATE"",""APPROVEUSER"",""APPROVEDATE"",""APPROVERESULT"",""REJECTREASON"",""CREATEDDATE"") VALUES (:Psid,:Procurementscheduledate,:Reason,:Subcompany,:Applyuser,:Applydate,:Approveuser,:Approvedate,:Approveresult,:Rejectreason,:Createddate)"; this.Database.AddInParameter(":Psid", info.Psid);//DBType:VARCHAR2 this.Database.AddInParameter(":Procurementscheduledate", info.Procurementscheduledate);//DBType:DATE this.Database.AddInParameter(":Reason", info.Reason);//DBType:NVARCHAR2 this.Database.AddInParameter(":Subcompany", info.Subcompany);//DBType:VARCHAR2 this.Database.AddInParameter(":Applyuser", info.Applyuser);//DBType:NVARCHAR2 this.Database.AddInParameter(":Applydate", info.Applydate);//DBType:DATE this.Database.AddInParameter(":Approveuser", info.Approveuser);//DBType:NVARCHAR2 this.Database.AddInParameter(":Approvedate", info.Approvedate);//DBType:DATE this.Database.AddInParameter(":Approveresult", info.Approveresult);//DBType:INTERVAL YEAR(2) TO MONTH this.Database.AddInParameter(":Rejectreason", info.Rejectreason);//DBType:NVARCHAR2 this.Database.AddInParameter(":Createddate", info.Createddate);//DBType:DATE this.Database.ExecuteNonQuery(sqlCommand); } finally { this.Database.ClearParameter(); } return info; }
public Procurementschedulehead CreateProcurementschedulehead(Procurementschedulehead info,List<Procurementscheduledetail> detailInfos) { var coderuleManagement=new CoderuleManagement(Management); info.Psid = coderuleManagement.GenerateCodeRule(Procurementschedulehead.RuleCode+DateTime.Today.ToString("yyyyMM"),false); foreach (var detailInfo in detailInfos) { detailInfo.Psid = info.Psid; } var detailManagement = new ProcurementscheduledetailManagement(Management); try { Management.BeginTransaction(); Management.CreateProcurementschedulehead(info); foreach (var detailInfo in detailInfos) { detailManagement.CreateProcurementscheduledetail(detailInfo); } Management.Commit(); } catch { Management.Rollback(); throw; } return info; }
protected void ReadEntityToControl(Procurementschedulehead headInfo) { litPsid.Text = headInfo.Psid; if (headInfo.Procurementscheduledate.HasValue) { litProcurementscheduledate.Text = headInfo.Procurementscheduledate.Value.ToString(UiConst.DateFormat); } litReason.Text = headInfo.Reason; ucSubCompany.SubcompanyId = headInfo.Subcompany; litApplyuser.Text = headInfo.Applyuser; if (headInfo.Applydate.HasValue) { litApplydate.Text = headInfo.Applydate.Value.ToString(UiConst.DateFormat); } litApproveuser.Text = headInfo.Approveuser; if (headInfo.Approvedate.HasValue) {litApprovedate.Text = headInfo.Approvedate.Value.ToString(UiConst.DateFormat);} litApproveresult.Text = EnumUtil.RetrieveEnumDescript(headInfo.Approveresult); litRejectreason.Text = headInfo.Rejectreason; litCreateddate.Text = headInfo.Createddate.Value.ToString(UiConst.DateTimeFormat); //if(headInfo.Approveresult==ApproveResult.Approved) //{ // BtnNewContract.Visible = true; //} }
protected void BtnSave_Click(object sender, EventArgs e) { DateTime dateTime = DateTime.MinValue; if (!ucProcurementscheduledate.DateValue.HasValue) { UIHelper.Alert(this, "请选择计划采购日期!"); return; } if (string.IsNullOrEmpty(ucSubCompany.SubcompanyId)) { UIHelper.Alert(this, "请选择分公司!"); return; } if (!ucApplydate.DateValue.HasValue) { UIHelper.Alert(this, "请选择申请日期!"); return; } Procurementschedulehead headInfo = null; if (string.IsNullOrEmpty(Psid)) { //add headInfo = new Procurementschedulehead(); WriteControlValueToEntity(headInfo); this.ProcurementscheduleheadService.CreateProcurementschedulehead(headInfo, ProcureScheduleDetails); } else { //edit headInfo = ProcurementscheduleheadService.RetrieveProcurementscheduleheadByPsid(Psid); if (headInfo == null) { UIHelper.Alert(this, "对不起,计划已被删除,请重新录入!"); return; } WriteControlValueToEntity(headInfo); headInfo.Approveresult = ApproveResult.Draft; ProcurementscheduleheadService.UpdateProcurementscheduleheadByPsid(headInfo, ProcureScheduleDetails); } UIHelper.AlertMessageGoToURL(this, "保存成功!", ResolveUrl("~/Admin/ProcurePlanList.aspx")); }
protected void WriteControlValueToEntity(Procurementschedulehead headInfo) { headInfo.Psid = litPsid.Text; headInfo.Procurementscheduledate = ucProcurementscheduledate.DateValue; headInfo.Reason = txtReason.Text; headInfo.Subcompany = ucSubCompany.SubcompanyId; headInfo.Applyuser = ucApplyuser.Username; headInfo.Applydate = ucApplydate.DateValue; if (!headInfo.Createddate.HasValue) { headInfo.Createddate = DateTime.Now; } }
protected void ReadEntityToControl(Procurementschedulehead headInfo) { litPsid.Text = headInfo.Psid; if (headInfo.Procurementscheduledate.HasValue) { ucProcurementscheduledate.DateValue = headInfo.Procurementscheduledate; } txtReason.Text = headInfo.Reason; ucSubCompany.SubcompanyId = headInfo.Subcompany; //txtApplyuser.Text = headInfo.Applyuser; //ucApplyuser.Username = headInfo.Applyuser; if (headInfo.Applydate.HasValue) { ucApplydate.DateValue = headInfo.Applydate; } }
protected void WriteControlValueToEntity(Procurementschedulehead headInfo) { headInfo.Rejectreason = string.IsNullOrEmpty(txtRejectreason.Text) ? "无意见" : txtRejectreason.Text; headInfo.Approvedate = DateTime.Now; if (WebContext.Current.CurrentUser != null) { headInfo.Approveuser = WebContext.Current.CurrentUser.Username; } }
protected void ReadEntityToControl(Procurementschedulehead headInfo) { litPsid.Text = headInfo.Psid; if (headInfo.Procurementscheduledate.HasValue) { litProcurementscheduledate.Text = headInfo.Procurementscheduledate.Value.ToString(UiConst.DateFormat); } litReason.Text = headInfo.Reason; ucSubCompany.SubcompanyId = headInfo.Subcompany; litApplyuser.Text = headInfo.Applyuser; if (headInfo.Applydate.HasValue) { litApplydate.Text = headInfo.Applydate.Value.ToString(UiConst.DateFormat); } }
public Procurementschedulehead UpdateProcurementscheduleheadByPsid(Procurementschedulehead info, List<Procurementscheduledetail> detailInfos) { foreach (var detailInfo in detailInfos) { detailInfo.Psid = info.Psid; } var detailManagement = new ProcurementscheduledetailManagement(Management); var dbDetails = detailManagement.RetrieveProcurementscheduledetailListByPsid(info.Psid); try { Management.BeginTransaction(); Management.UpdateProcurementscheduleheadByPsid(info); foreach (var detail in detailInfos) { var existInfo = dbDetails.Where(p => p.Detailid == detail.Detailid).FirstOrDefault(); if (existInfo == null) { detailManagement.CreateProcurementscheduledetail(detail); } else { detailManagement.UpdateProcurementscheduledetailByDetailid(detail); } } Management.Commit(); } catch { Management.Rollback(); throw; } return info; }