public Assetsetupinfo CreateAssetsetupinfo(Assetsetupinfo info) { try { info.Setupid = new CoderuleManagement().GenerateCodeRule(Assetsetupinfo.RuleCode + DateTime.Today.ToString("yyyyMM"), false); Management.BeginTransaction(); Management.CreateAssetsetupinfo(info); Management.Commit(); } catch { Management.Rollback(); throw; } return info; }
public Assetsetupinfo CreateAssetsetupinfo(Assetsetupinfo info) { try { string sqlCommand = @"INSERT INTO ""ASSETSETUPINFO"" (""SETUPID"",""APPLYSETUPDATE"",""APPLYDATE"",""APPLYUSERID"",""CONTACTPHONE"",""PROJECTCONTACTORID"",""PROJECTCONTACTORPHONE"",""PLANSETUPDATE"",""ACTUALSETUPDATE"",""APPLYCONTENT"",""SUBCOMPANY"",""REJECTREASON"",""APPROVEUSER"",""APPROVEDATE"",""APPROVERESULT"",""CREATEDDATE"",""SUBCOMPANYCONTACTORID"",""CREATOR"",""ASSETCATEGORYID"",""SETUPCONTENT"",""CONFIRMDATE"",""CONFIRMUSER"",""STORAGETITLE"",""STORAGEID"") VALUES (:Setupid,:Applysetupdate,:Applydate,:Applyuserid,:Contactphone,:Projectcontactorid,:Projectcontactorphone,:Plansetupdate,:Actualsetupdate,:Applycontent,:Subcompany,:Rejectreason,:Approveuser,:Approvedate,:Approveresult,:Createddate,:Subcompanycontactorid,:Creator,:Assetcategoryid,:Setupcontent,:Confirmdate,:Confirmuser,:Storagetitle,:Storageid)"; this.Database.AddInParameter(":Setupid", info.Setupid);//DBType:VARCHAR2 this.Database.AddInParameter(":Applysetupdate", info.Applysetupdate);//DBType:DATE this.Database.AddInParameter(":Applydate", info.Applydate);//DBType:DATE this.Database.AddInParameter(":Applyuserid", info.Applyuserid);//DBType:VARCHAR2 this.Database.AddInParameter(":Contactphone", info.Contactphone);//DBType:VARCHAR2 this.Database.AddInParameter(":Projectcontactorid", info.Projectcontactorid);//DBType:VARCHAR2 this.Database.AddInParameter(":Projectcontactorphone", info.Projectcontactorphone);//DBType:VARCHAR2 this.Database.AddInParameter(":Plansetupdate", info.Plansetupdate);//DBType:DATE this.Database.AddInParameter(":Actualsetupdate", info.Actualsetupdate);//DBType:DATE this.Database.AddInParameter(":Applycontent", info.Applycontent);//DBType:NVARCHAR2 this.Database.AddInParameter(":Subcompany", info.Subcompany);//DBType:NVARCHAR2 this.Database.AddInParameter(":Rejectreason", info.Rejectreason);//DBType:NVARCHAR2 this.Database.AddInParameter(":Approveuser", info.Approveuser);//DBType:NVARCHAR2 this.Database.AddInParameter(":Approvedate", info.Approvedate);//DBType:DATE this.Database.AddInParameter(":Approveresult", info.Approveresult);//DBType:NUMBER this.Database.AddInParameter(":Createddate", info.Createddate);//DBType:DATE this.Database.AddInParameter(":Subcompanycontactorid", info.Subcompanycontactorid);//DBType:VARCHAR2 this.Database.AddInParameter(":Creator", info.Creator);//DBType:VARCHAR2 this.Database.AddInParameter(":Assetcategoryid", info.Assetcategoryid);//DBType:VARCHAR2 this.Database.AddInParameter(":Setupcontent", info.Setupcontent);//DBType:NVARCHAR2 this.Database.AddInParameter(":Confirmdate", info.Confirmdate);//DBType:DATE this.Database.AddInParameter(":Confirmuser", info.Confirmuser);//DBType:VARCHAR2 this.Database.AddInParameter(":Storagetitle", info.Storagetitle);//DBType:VARCHAR2 this.Database.AddInParameter(":Storageid", info.Storageid);//DBType:VARCHAR2 this.Database.ExecuteNonQuery(sqlCommand); } finally { this.Database.ClearParameter(); } return info; }
protected void BindData(Assetsetupinfo SetupInfo) { //bind setup litSetupid.Text = SetupInfo.Setupid;//申请单号 ucSeletedSystem.Assetcategoryid = SetupInfo.Assetcategoryid; //所属系统 if (SetupInfo.Applysetupdate.HasValue) { litApplysetupdate.Text = SetupInfo.Applysetupdate.Value.ToString(UiConst.DateFormat); //申请安装日期 } if (SetupInfo.Applydate.HasValue) { litApplyDate.Text = SetupInfo.Applydate.Value.ToString(UiConst.DateFormat); //申请日期 } litApplycontent.Text = SetupInfo.Applycontent;//申请内容 ucApplyuser.UserId = SetupInfo.Applyuserid;//申请人 litContactphone.Text = SetupInfo.Contactphone; //联系电话 ucSelectProject.StorageId = SetupInfo.Storageid; ucSelectProject.Storagetitle = SetupInfo.Storagetitle; litProjectcontactorid.Text = SetupInfo.Projectcontactorid; // 项目体(分公司)联系人 litProjectcontactorphone.Text = SetupInfo.Projectcontactorphone; //项目体(分公司)联系电话 if (SetupInfo.Plansetupdate.HasValue) { litPlansetupdate.Text = SetupInfo.Plansetupdate.Value.ToString(UiConst.DateFormat); //计划安装日期 } if (SetupInfo.Approvedate.HasValue) { litApprovedate.Text = SetupInfo.Approvedate.Value.ToString(UiConst.DateTimeFormat);//回复时间 } litApproveuser.Text = SetupInfo.Approveuser;//审核人 if (SetupInfo.Confirmdate.HasValue) { litConfirmdate.Text = SetupInfo.Confirmdate.Value.ToString(UiConst.DateTimeFormat);//确认日期 } litConfirmuser.Text = SetupInfo.Confirmuser;//确认人 litSetupcontent.Text = SetupInfo.Setupcontent;//已安装明细 litApproveresult.Text = EnumUtil.RetrieveEnumDescript(SetupInfo.Approveresult);//状态 }
public Assetsetupinfo UpdateAssetsetupinfoBySetupid(Assetsetupinfo info) { try { Management.BeginTransaction(); Management.UpdateAssetsetupinfoBySetupid(info); Management.Commit(); } catch { Management.Rollback(); throw; } return info; }
protected void BindData(Assetsetupinfo SetupInfo) { //bind setup litSetupid.Text = SetupInfo.Setupid;//申请单号 ucSeletedSystem.Assetcategoryid = SetupInfo.Assetcategoryid; ucApplySetupDate.DateValue = SetupInfo.Applysetupdate; ucApplyDate.DateValue = SetupInfo.Applydate; txtApplycontent.Text = SetupInfo.Applycontent;//申请内容 ucApplyuser.UserId = SetupInfo.Applyuserid; txtContactphone.Text = SetupInfo.Contactphone; //联系电话 ucSelectProject.StorageId = SetupInfo.Storageid; ucSelectProject.Storagetitle = SetupInfo.Storagetitle; txtProjectcontactorid.Text = SetupInfo.Projectcontactorid; // 项目体(分公司)联系人 txtProjectcontactorphone.Text = SetupInfo.Projectcontactorphone; //项目体(分公司)联系电话 }
protected void SaveData(SetupState setupState) { Assetsetupinfo SetupInfo = null; if (!string.IsNullOrEmpty(PageUtility.GetQueryStringValue("Setupid"))) //修改 { SetupInfo = AssetsetupinfoService.RetrieveAssetsetupinfoBySetupid(Setupid); if (SetupInfo==null){return;} ExtractData(SetupInfo); SetupInfo.Approveresult = setupState; AssetsetupinfoService.UpdateAssetsetupinfoBySetupid(SetupInfo); foreach (Assetsetupdetail assetsetupdetail in SetupDetail) { assetsetupdetail.Setupid = SetupInfo.Setupid; if (AssetsetupdetailService.RetrieveAssetsetupdetailByDetailid(assetsetupdetail.Detailid) == null) { AssetsetupdetailService.CreateAssetsetupdetail(assetsetupdetail); } else { AssetsetupdetailService.UpdateAssetsetupdetailByDetailid(assetsetupdetail); } } } else //新增 { SetupInfo=new Assetsetupinfo(); ExtractData(SetupInfo); SetupInfo.Approveresult = setupState; AssetsetupinfoService.CreateAssetsetupinfo(SetupInfo); foreach (Assetsetupdetail assetsetupdetail in SetupDetail) { assetsetupdetail.Setupid = SetupInfo.Setupid; AssetsetupdetailService.CreateAssetsetupdetail(assetsetupdetail); } } }
protected void ExtractData(Assetsetupinfo assetsetupinfo) { assetsetupinfo.Setupid = Setupid;//申请单号 assetsetupinfo.Assetcategoryid = ucSeletedSystem.Assetcategoryid;//(系统)设备大类 assetsetupinfo.Applysetupdate = ucApplySetupDate.DateValue;//申请安装日期 assetsetupinfo.Applycontent = txtApplycontent.Text;//申请内容 assetsetupinfo.Applydate = ucApplyDate.DateValue;//申请日期 assetsetupinfo.Applyuserid = ucApplyuser.UserId;//申请人 assetsetupinfo.Storagetitle = ucSelectProject.Storagetitle;//区分字段:分公司或项目体 assetsetupinfo.Storageid = ucSelectProject.StorageId;//项目体ID或分公司ID assetsetupinfo.Contactphone = txtContactphone.Text;//联系电话 assetsetupinfo.Projectcontactorid = txtProjectcontactorid.Text.Trim();//项目体联系人 assetsetupinfo.Projectcontactorphone = txtProjectcontactorphone.Text;//项目体联系电话 assetsetupinfo.Createddate = DateTime.Now;//创建日期 assetsetupinfo.Creator = WebContext.Current.CurrentUser.Id;//创建人 }
protected void BindData(Assetsetupinfo SetupInfo) { //bind setup litSetupid.Text = SetupInfo.Setupid;//申请单号 ucSeletedSystem.Assetcategoryid = SetupInfo.Assetcategoryid; //所属系统 if (SetupInfo.Applysetupdate.HasValue) { litApplysetupdate.Text = SetupInfo.Applysetupdate.Value.ToString(UiConst.DateFormat); //申请安装日期 } if (SetupInfo.Applydate.HasValue) { litApplyDate.Text = SetupInfo.Applydate.Value.ToString(UiConst.DateFormat); //申请日期 } litApplycontent.Text = SetupInfo.Applycontent;//申请内容 ucApplyuser.UserId = SetupInfo.Applyuserid; litContactphone.Text = SetupInfo.Contactphone; //联系电话 ucSelectProject.StorageId = SetupInfo.Storageid; ucSelectProject.Storagetitle = SetupInfo.Storagetitle; litProjectcontactorid.Text = SetupInfo.Projectcontactorid; // 项目体(分公司)联系人 litProjectcontactorphone.Text = SetupInfo.Projectcontactorphone; //项目体(分公司)联系电话 }