public Assetmaintain CreateAssetmaintain(Assetmaintain info) { try { info.Assetmaintainid = new CoderuleManagement().GenerateCodeRule(Assetmaintain.RuleCode + DateTime.Today.ToString("yyyyMM"), false); Management.BeginTransaction(); Management.CreateAssetmaintain(info); Management.Commit(); } catch { Management.Rollback(); throw; } return info; }
public Assetmaintain CreateAssetmaintain(Assetmaintain info) { try { this.Database.AddInParameter(":Assetmaintainid", info.Assetmaintainid);//DBType:VARCHAR2 this.Database.AddInParameter(":Assetcategoryid", info.Assetcategoryid);//DBType:VARCHAR2 this.Database.AddInParameter(":Maintaintype", info.Maintaintype);//DBType:VARCHAR2 this.Database.AddInParameter(":Applydate", info.Applydate);//DBType:DATE this.Database.AddInParameter(":Applyuserid", info.Applyuserid);//DBType:VARCHAR2 this.Database.AddInParameter(":Applycontent", info.Applycontent);//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(":Rejectreason", info.Rejectreason);//DBType:NVARCHAR2 this.Database.AddInParameter(":Planmaintaindate", info.Planmaintaindate);//DBType:DATE this.Database.AddInParameter(":Actualmaintaindate", info.Actualmaintaindate);//DBType:DATE this.Database.AddInParameter(":Confirmdate", info.Confirmdate);//DBType:DATE this.Database.AddInParameter(":Confirmuser", info.Confirmuser);//DBType:VARCHAR2 this.Database.AddInParameter(":Maintaincontent", info.Maintaincontent);//DBType:NVARCHAR2 this.Database.AddInParameter(":Storagetitle", info.Storagetitle);//DBType:VARCHAR2 this.Database.AddInParameter(":Storageid", info.Storageid);//DBType:VARCHAR2 this.Database.AddInParameter(":Subcompany", info.Subcompany);//DBType:NVARCHAR2 this.Database.AddInParameter(":Subcompanycontactorid", info.Subcompanycontactorid);//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(":Creator", info.Creator);//DBType:VARCHAR2 this.Database.AddInParameter(":Createddate", info.Createddate);//DBType:DATE this.Database.AddInParameter(":Reason", info.Reason);//DBType:NVARCHAR2 string sqlCommand = @"INSERT INTO ""ASSETMAINTAIN"" (""ASSETMAINTAINID"",""ASSETCATEGORYID"",""MAINTAINTYPE"",""APPLYDATE"",""APPLYUSERID"",""APPLYCONTENT"",""APPROVEUSER"",""APPROVEDATE"",""APPROVERESULT"",""REJECTREASON"",""PLANMAINTAINDATE"",""ACTUALMAINTAINDATE"",""CONFIRMDATE"",""CONFIRMUSER"",""MAINTAINCONTENT"",""STORAGETITLE"",""STORAGEID"",""SUBCOMPANY"",""SUBCOMPANYCONTACTORID"",""CONTACTPHONE"",""PROJECTCONTACTORID"",""PROJECTCONTACTORPHONE"",""CREATOR"",""CREATEDDATE"",""REASON"") VALUES (:Assetmaintainid,:Assetcategoryid,:Maintaintype,:Applydate,:Applyuserid,:Applycontent,:Approveuser,:Approvedate,:Approveresult,:Rejectreason,:Planmaintaindate,:Actualmaintaindate,:Confirmdate,:Confirmuser,:Maintaincontent,:Storagetitle,:Storageid,:Subcompany,:Subcompanycontactorid,:Contactphone,:Projectcontactorid,:Projectcontactorphone,:Creator,:Createddate,:Reason)"; this.Database.ExecuteNonQuery(sqlCommand); } finally { this.Database.ClearParameter(); } return info; }
protected void ReadEntityToControl(Assetmaintain headInfo) { litAssetmaintainid.Text = headInfo.Assetmaintainid;//维修单编号 ucSeletedSystem.Assetcategoryid = headInfo.Assetcategoryid;//(系统)设备大类 ucMaintaintype.Configid = headInfo.Maintaintype; //保修来源:(项目体、自检、月检)数据字典 if (headInfo.Applydate.HasValue) { litApplydate.Text = headInfo.Applydate.Value.ToString(UiConst.DateFormat);//申请维修日期 } ucApplyuser.UserId = headInfo.Applyuserid;//申请人 litApplycontent.Text = headInfo.Applycontent;//申请内容 ucSelectProject.StorageId = headInfo.Storageid; //区分字段:分公司或项目体 ucSelectProject.Storagetitle = headInfo.Storagetitle; //项目体ID或分公司ID litContactphone.Text = headInfo.Contactphone;//联系电话 litProjectcontactorid.Text = headInfo.Projectcontactorid; // 项目体(分公司)联系人 litProjectcontactorphone.Text = headInfo.Projectcontactorphone; //项目体(分公司)联系电话 if (headInfo.Approvedate.HasValue) { litApprovedate.Text = headInfo.Approvedate.Value.ToString(UiConst.DateTimeFormat);//回复时间 } litApproveuser.Text = headInfo.Approveuser;//回复人 if (headInfo.Planmaintaindate.HasValue) { litPlanmaintaindate.Text = headInfo.Planmaintaindate.Value.ToString(UiConst.DateFormat);//计划维修日期 } if(!string.IsNullOrEmpty(headInfo.Reason)) { int index = -1; if (ddlReason.Items.Count > 0) { for (int i = 0; i < ddlReason.Items.Count; i++) { var currentItem = ddlReason.Items[i]; if (currentItem.Value.Contains(headInfo.Reason)) { ddlReason.SelectedIndex = i; index = i; break; } } } if (index == -1) { txtReason.Text = headInfo.Reason; for (int i = 0; i < ddlReason.Items.Count; i++) { var currentItem = ddlReason.Items[i]; if (currentItem.Value.Contains("其他")) { ddlReason.SelectedIndex = i; break; } } } } }
protected void WriteControlValueToEntity(Assetmaintain assetmaintain) { assetmaintain.Assetmaintainid = Assetmaintainid;//维修单编号 assetmaintain.Assetcategoryid = ucSeletedSystem.Assetcategoryid;//(系统)设备大类 assetmaintain.Maintaintype = ucMaintaintype.Configid;//保修来源:(项目体、自检、月检)数据字典 assetmaintain.Applycontent = txtApplycontent.Text;//申请内容 assetmaintain.Applydate = ucApplyDate.DateValue;//申请日期 assetmaintain.Applyuserid = ucApplyuser.UserId;//申请人 assetmaintain.Storagetitle = ucSelectProject.Storagetitle;//区分字段:分公司或项目体 assetmaintain.Storageid = ucSelectProject.StorageId;//项目体ID或分公司ID assetmaintain.Contactphone = txtContactphone.Text;//联系电话 assetmaintain.Projectcontactorid = txtProjectcontactorid.Text.Trim();//项目体联系人 assetmaintain.Projectcontactorphone = txtProjectcontactorphone.Text;//项目体联系电话 if (string.IsNullOrEmpty(assetmaintain.Assetmaintainid)) { assetmaintain.Createddate = DateTime.Now;//创建日期 assetmaintain.Creator = WebContext.Current.CurrentUser.Id;//创建人 } }
protected void SaveData(AssetMaintainState maintainState) { Assetmaintain headInfo = null; if (!string.IsNullOrEmpty(PageUtility.GetQueryStringValue("Assetmaintainid"))) //修改 { headInfo = AssetmaintainService.RetrieveAssetmaintainByAssetmaintainid(Assetmaintainid); if (headInfo == null) { return; } WriteControlValueToEntity(headInfo); headInfo.Approveresult = maintainState; AssetmaintainService.UpdateAssetmaintainByAssetmaintainid(headInfo); foreach (var detail in Details) { detail.Assetmaintainid = headInfo.Assetmaintainid; if (AssetmaintaindetailService.RetrieveAssetmaintaindetailByDetailid(detail.Detailid) == null) { AssetmaintaindetailService.CreateAssetmaintaindetail(detail); } else { AssetmaintaindetailService.UpdateAssetmaintaindetailByDetailid(detail); } } } else //新增 { headInfo = new Assetmaintain(); WriteControlValueToEntity(headInfo); headInfo.Approveresult = maintainState; AssetmaintainService.CreateAssetmaintain(headInfo); foreach (var detail in Details) { detail.Assetmaintainid = headInfo.Assetmaintainid; AssetmaintaindetailService.CreateAssetmaintaindetail(detail); } } }
protected void ReadEntityToControl(Assetmaintain headInfo) { litAssetmaintainid.Text = headInfo.Assetmaintainid;//维修单编号 ucSeletedSystem.Assetcategoryid = headInfo.Assetcategoryid;//(系统)设备大类 ucMaintaintype.Configid = headInfo.Maintaintype; //保修来源:(项目体、自检、月检)数据字典 ucApplyDate.DateValue = headInfo.Applydate;//申请维修日期 ucApplyuser.UserId = headInfo.Applyuserid;//申请人 txtApplycontent.Text = headInfo.Applycontent;//申请内容 ucSelectProject.StorageId = headInfo.Storageid; //区分字段:分公司或项目体 ucSelectProject.Storagetitle = headInfo.Storagetitle; //项目体ID或分公司ID txtContactphone.Text = headInfo.Contactphone;//联系电话 txtProjectcontactorid.Text = headInfo.Projectcontactorid.Trim(); // 项目体(分公司)联系人 txtProjectcontactorphone.Text = headInfo.Projectcontactorphone; //项目体(分公司)联系电话 }
protected void ReadEntityToControl(Assetmaintain headInfo) { litAssetmaintainid.Text = headInfo.Assetmaintainid;//维修单编号 ucSeletedSystem.Assetcategoryid = headInfo.Assetcategoryid;//(系统)设备大类 ucMaintaintype.Configid = headInfo.Maintaintype; //保修来源:(项目体、自检、月检)数据字典 if (headInfo.Applydate.HasValue) { litApplydate.Text = headInfo.Applydate.Value.ToString(UiConst.DateFormat);//申请维修日期 } ucApplyuser.UserId = headInfo.Applyuserid;//申请人 litApplycontent.Text = headInfo.Applycontent;//申请内容 ucSelectProject.StorageId = headInfo.Storageid; //区分字段:分公司或项目体 ucSelectProject.Storagetitle = headInfo.Storagetitle; //项目体ID或分公司ID litContactphone.Text = headInfo.Contactphone;//联系电话 litProjectcontactorid.Text = headInfo.Projectcontactorid; // 项目体(分公司)联系人 litProjectcontactorphone.Text = headInfo.Projectcontactorphone; //项目体(分公司)联系电话 if (headInfo.Planmaintaindate.HasValue) { litPlanmaintaindate.Text = headInfo.Planmaintaindate.Value.ToString(UiConst.DateFormat);//计划维修日期 } if (headInfo.Approvedate.HasValue) { litApprovedate.Text = headInfo.Approvedate.Value.ToString(UiConst.DateTimeFormat);//回复时间 } litApproveuser.Text = headInfo.Approveuser;//回复人 litMaintaincontent.Text = headInfo.Maintaincontent;//已维修明细 if (headInfo.Confirmdate.HasValue) { litConfirmdate.Text = headInfo.Confirmdate.Value.ToString(UiConst.DateFormat);//确认日期 } if (headInfo.Actualmaintaindate.HasValue) { litActualmaintaindate.Text = headInfo.Actualmaintaindate.Value.ToString(UiConst.DateFormat);//实际维修日期 } litConfirmuser.Text = headInfo.Confirmuser;//确认人 litApproveresult.Text = EnumUtil.RetrieveEnumDescript(headInfo.Approveresult); //状态 litReason.Text = headInfo.Reason;//修复原因 }
protected void ReadEntityToControl(Assetmaintain headInfo) { litAssetmaintainid.Text = headInfo.Assetmaintainid;//维修单编号 ucSeletedSystem.Assetcategoryid = headInfo.Assetcategoryid;//(系统)设备大类 ucMaintaintype.Configid = headInfo.Maintaintype; //保修来源:(项目体、自检、月检)数据字典 if(headInfo.Applydate.HasValue) { litApplydate.Text = headInfo.Applydate.Value.ToString(UiConst.DateFormat);//申请维修日期 } ucApplyuser.UserId = headInfo.Applyuserid;//申请人 litApplycontent.Text = headInfo.Applycontent;//申请内容 ucSelectProject.StorageId = headInfo.Storageid; //区分字段:分公司或项目体 ucSelectProject.Storagetitle = headInfo.Storagetitle; //项目体ID或分公司ID litContactphone.Text = headInfo.Contactphone;//联系电话 litProjectcontactorid.Text = headInfo.Projectcontactorid; // 项目体(分公司)联系人 litProjectcontactorphone.Text = headInfo.Projectcontactorphone; //项目体(分公司)联系电话 }
public Assetmaintain UpdateAssetmaintainByAssetmaintainid(Assetmaintain info) { try { Management.BeginTransaction(); Management.UpdateAssetmaintainByAssetmaintainid(info); Management.Commit(); } catch { Management.Rollback(); throw; } return info; }