protected void BindData(Assetremove remove) { //bind setup litRemoveId.Text = remove.Assetremoveid;//申请单号 ucSeletedSystem.Assetcategoryid = remove.Assetcategoryid; //所属系统 if (remove.Applydate.HasValue) { litApplysetupdate.Text = remove.Applydate.Value.ToString(UiConst.DateFormat); //申请安装日期 } if (remove.Applydate.HasValue) { litApplyDate.Text = remove.Applydate.Value.ToString(UiConst.DateFormat); //申请日期 } litApplycontent.Text = remove.Applycontent;//申请内容 ucApplyuser.UserId = remove.Applyuserid;//申请人 litContactphone.Text = remove.Contactphone; //联系电话 ucSelectProject.StorageId = remove.Storageid; ucSelectProject.Storagetitle = remove.Storagetitle; litProjectcontactorid.Text = remove.Projectcontactorid; // 项目体(分公司)联系人 litProjectcontactorphone.Text = remove.Projectcontactorphone; //项目体(分公司)联系电话 if (remove.Planremovedate.HasValue) { litPlansetupdate.Text = remove.Planremovedate.Value.ToString(UiConst.DateFormat); //计划安装日期 } if (remove.Approvedate.HasValue) { litApprovedate.Text = remove.Approvedate.Value.ToString(UiConst.DateTimeFormat);//回复时间 } litApproveuser.Text = remove.Approveuser;//审核人 }
protected void BindData(Assetremove RemoveInfo) { //bind Remove litRemoveid.Text = RemoveInfo.Assetremoveid;//申请单号 ucSeletedSystem.Assetcategoryid = RemoveInfo.Assetcategoryid; ucApplyRemoveDate.DateValue = RemoveInfo.Applydate; ucApplyDate.DateValue = RemoveInfo.Applydate; txtApplycontent.Text = RemoveInfo.Applycontent;//申请内容 ucApplyuser.UserId = RemoveInfo.Applyuserid; txtContactphone.Text = RemoveInfo.Contactphone; //联系电话 ucSelectProject.StorageId = RemoveInfo.Storageid; ucSelectProject.Storagetitle = RemoveInfo.Storagetitle; txtProjectcontactorid.Text = RemoveInfo.Projectcontactorid; // 项目体(分公司)联系人 txtProjectcontactorphone.Text = RemoveInfo.Projectcontactorphone; //项目体(分公司)联系电话 }
public Assetremove CreateAssetremove(Assetremove info) { try { info.Assetremoveid = new CoderuleManagement().GenerateCodeRule(Assetremove.RuleCode + DateTime.Today.ToString("yyyyMM"), false); Management.BeginTransaction(); Management.CreateAssetremove(info); Management.Commit(); } catch { Management.Rollback(); throw; } return info; }
public Assetremove CreateAssetremove(Assetremove info) { try { string sqlCommand = @"INSERT INTO ""ASSETREMOVE"" (""ASSETREMOVEID"",""ASSETCATEGORYID"",""APPLYDATE"",""APPLYUSERID"",""APPLYCONTENT"",""APPROVEUSER"",""APPROVEDATE"",""APPROVERESULT"",""PLANREMOVEDATE"",""ACTUALREMOVEDATE"",""REJECTREASON"",""CONFIRMDATE"",""CONFIRMUSER"",""REMOVEDCONTENT"",""STORAGETITLE"",""STORAGEID"",""SUBCOMPANY"",""SUBCOMPANYCONTACTORID"",""CONTACTPHONE"",""PROJECTCONTACTORID"",""PROJECTCONTACTORPHONE"",""CREATOR"",""CREATEDDATE"") VALUES (:Assetremoveid,:Assetcategoryid,:Applydate,:Applyuserid,:Applycontent,:Approveuser,:Approvedate,:Approveresult,:Planremovedate,:Actualremovedate,:Rejectreason,:Confirmdate,:Confirmuser,:Removedcontent,:Storagetitle,:Storageid,:Subcompany,:Subcompanycontactorid,:Contactphone,:Projectcontactorid,:Projectcontactorphone,:Creator,:Createddate)"; this.Database.AddInParameter(":Assetremoveid", info.Assetremoveid);//DBType:VARCHAR2 this.Database.AddInParameter(":Assetcategoryid", info.Assetcategoryid);//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(":Planremovedate", info.Planremovedate);//DBType:DATE this.Database.AddInParameter(":Actualremovedate", info.Actualremovedate);//DBType:DATE this.Database.AddInParameter(":Rejectreason", info.Rejectreason);//DBType:NVARCHAR2 this.Database.AddInParameter(":Confirmdate", info.Confirmdate);//DBType:DATE this.Database.AddInParameter(":Confirmuser", info.Confirmuser);//DBType:VARCHAR2 this.Database.AddInParameter(":Removedcontent", info.Removedcontent);//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.ExecuteNonQuery(sqlCommand); } finally { this.Database.ClearParameter(); } return info; }
protected void SaveData(AssetRemoveState RemoveState) { Assetremove RemoveInfo = null; if (!string.IsNullOrEmpty(PageUtility.GetQueryStringValue("Assetremoveid"))) //修改 { RemoveInfo = Assetremoveservice.RetrieveAssetremoveByAssetremoveid(Removeid); if (RemoveInfo == null) { return; } ExtractData(RemoveInfo); RemoveInfo.Approveresult = RemoveState; Assetremoveservice.UpdateAssetremoveByAssetremoveid(RemoveInfo); foreach (Assetremovedetail Assetremovedetail in RemoveDetail) { Assetremovedetail.Assetremoveid = RemoveInfo.Assetremoveid; if (AssetremovedetailService.RetrieveAssetremovedetailByDetailid(Assetremovedetail.Detailid) == null) { AssetremovedetailService.CreateAssetremovedetail(Assetremovedetail); } else { AssetremovedetailService.UpdateAssetremovedetailByDetailid(Assetremovedetail); } } } else //新增 { RemoveInfo = new Assetremove(); ExtractData(RemoveInfo); RemoveInfo.Approveresult = RemoveState; Assetremoveservice.CreateAssetremove(RemoveInfo); foreach (Assetremovedetail Assetremovedetail in RemoveDetail) { Assetremovedetail.Assetremoveid = RemoveInfo.Assetremoveid; AssetremovedetailService.CreateAssetremovedetail(Assetremovedetail); } } }
protected void ExtractData(Assetremove assetRemoveinfo) { assetRemoveinfo.Assetremoveid = Removeid;//申请单号 assetRemoveinfo.Assetcategoryid = ucSeletedSystem.Assetcategoryid;//(系统)设备大类 assetRemoveinfo.Applydate = ucApplyRemoveDate.DateValue;//申请拆机日期 assetRemoveinfo.Applycontent = txtApplycontent.Text;//申请内容 assetRemoveinfo.Applydate = ucApplyDate.DateValue;//申请日期 assetRemoveinfo.Applyuserid = ucApplyuser.UserId;//申请人 assetRemoveinfo.Storagetitle = ucSelectProject.Storagetitle;//区分字段:分公司或项目体 assetRemoveinfo.Storageid = ucSelectProject.StorageId;//项目体ID或分公司ID assetRemoveinfo.Contactphone = txtContactphone.Text;//联系电话 assetRemoveinfo.Projectcontactorid = txtProjectcontactorid.Text.Trim();//项目体联系人 assetRemoveinfo.Projectcontactorphone = txtProjectcontactorphone.Text;//项目体联系电话 assetRemoveinfo.Createddate = DateTime.Now;//创建日期 assetRemoveinfo.Creator = WebContext.Current.CurrentUser.Id;//创建人 }
protected void BindData(Assetremove remove) { //bind setup litRemoveid.Text = remove.Assetremoveid;//申请单号 ucSeletedSystem.Assetcategoryid = remove.Assetcategoryid; //所属系统 if (remove.Applydate.HasValue) { litApplysetupdate.Text = remove.Applydate.Value.ToString(UiConst.DateFormat); //申请拆机日期 } if (remove.Applydate.HasValue) { litApplyDate.Text = remove.Applydate.Value.ToString(UiConst.DateFormat); //申请日期 } litApplycontent.Text = remove.Applycontent;//申请内容 ucApplyuser.UserId = remove.Applyuserid;//申请人 litContactphone.Text = remove.Contactphone; //联系电话 ucSelectProject.StorageId = remove.Storageid; ucSelectProject.Storagetitle = remove.Storagetitle; litProjectcontactorid.Text = remove.Projectcontactorid; // 项目体(分公司)联系人 litProjectcontactorphone.Text = remove.Projectcontactorphone; //项目体(分公司)联系电话 if (remove.Planremovedate.HasValue) { litPlansetupdate.Text = remove.Planremovedate.Value.ToString(UiConst.DateFormat); //计划拆机日期 } if (remove.Approvedate.HasValue) { litApprovedate.Text = remove.Approvedate.Value.ToString(UiConst.DateTimeFormat);//回复时间 } litApproveuser.Text = remove.Approveuser;//审核人 if (remove.Confirmdate.HasValue) { litConfirmdate.Text = remove.Confirmdate.Value.ToString(UiConst.DateTimeFormat);//确认日期 } if(remove.Actualremovedate.HasValue) { litActualsetupdate.Text = remove.Actualremovedate.Value.ToString(UiConst.DateFormat); //实际拆机日期 } litConfirmuser.Text = remove.Confirmuser;//确认人 litSetupcontent.Text = remove.Removedcontent;//已拆机明细 litApproveresult.Text = EnumUtil.RetrieveEnumDescript(remove.Approveresult);//状态 }
public Assetremove UpdateAssetremoveByAssetremoveid(Assetremove info) { try { Management.BeginTransaction(); Management.UpdateAssetremoveByAssetremoveid(info); Management.Commit(); } catch { Management.Rollback(); throw; } return info; }