public Assetscrapped CreateAssetscrapped(Assetscrapped info) { try { var coderuleManagement = new CoderuleManagement(Management); info.Assetscrappedid = coderuleManagement.GenerateCodeRule(Assetscrapped.ScrappedRuleCode + DateTime.Today.ToString("yyyyMM"), false); Management.BeginTransaction(); Management.CreateAssetscrapped(info); Management.Commit(); } catch { Management.Rollback(); throw; } return info; }
protected void ReadEntityToControl(Assetscrapped info) { litAssetscrappedid.Text = info.Assetscrappedid;//编号 if (info.Scrappeddate.HasValue) { litScrappeddate.Text = info.Scrappeddate.Value.ToString(UiConst.DateFormat);//报废日期 } litScrappeduser.Text = info.Scrappeduser;//报废人 litAssetno.Text = info.Assetno;//设备编号 litApproveuser.Text = info.Approveuser;//审核人 if (info.Approvedate.HasValue) { litApprovedate.Text = info.Approvedate.Value.ToString(UiConst.DateTimeFormat);//审核日期 } litRejectreason.Text = info.Rejectreason;//拒绝理由 //litCreateddate.Text = info.Createddate;//创建日期 //litCreator.Text = info.Creator;//创建人 litApprovedstate.Text = EnumUtil.RetrieveEnumDescript(info.Approvedstate);//审核状态 }
protected void BtnApplicate_Click(object sender, EventArgs e) { var intCount = 0; if (rptUsedList.Items.Count > 0) { foreach (RepeaterItem item in rptUsedList.Items) { HtmlInputCheckBox check = (HtmlInputCheckBox)item.FindControl("ckbScrapped"); if (check.Checked == true) { intCount++; Domain.Assetscrapped assetScrappedInfo = new Assetscrapped(); assetScrappedInfo.Assetscrappedid = Guid.NewGuid().ToString("N"); assetScrappedInfo.Assetno = check.Value; assetScrappedInfo.Createddate = System.DateTime.Now; assetScrappedInfo.Creator = WebContext.Current.CurrentUser.Username; AssetscrappedService.CreateAssetscrapped(assetScrappedInfo); ClientScript.RegisterStartupScript(this.GetType(), "", "<script>CloseTopDialogFrame();</script>"); //UIHelper.Alert(this, "报废申请成功,请等待审核"); } else { if (intCount == 0) { UIHelper.Alert(this, "请选择要申请报废的设备"); return; } } } } else { UIHelper.Alert(this, "没有待申请报废的设备"); return; } }
public Assetscrapped CreateAssetscrapped(Assetscrapped info) { try { string sqlCommand = @"INSERT INTO ""ASSET_SCRAPPED"" (""ASSET_SCRAPPED_ID"",""SCRAPPEDDATE"",""SCRAPPEDUSER"",""ASSETNO"",""APPROVEUSER"",""APPROVEDATE"",""REJECTREASON"",""CREATEDDATE"",""CREATOR"",""APPROVEDSTATE"") VALUES (:Assetscrappedid,:Scrappeddate,:Scrappeduser,:Assetno,:Approveuser,:Approvedate,:Rejectreason,:Createddate,:Creator,:Approvedstate)"; this.Database.AddInParameter(":Assetscrappedid", info.Assetscrappedid);//DBType:VARCHAR2 this.Database.AddInParameter(":Scrappeddate", info.Scrappeddate);//DBType:DATE this.Database.AddInParameter(":Scrappeduser", info.Scrappeduser);//DBType:NVARCHAR2 this.Database.AddInParameter(":Assetno", info.Assetno);//DBType:VARCHAR2 this.Database.AddInParameter(":Approveuser", info.Approveuser);//DBType:NVARCHAR2 this.Database.AddInParameter(":Approvedate", info.Approvedate);//DBType:DATE this.Database.AddInParameter(":Rejectreason", info.Rejectreason);//DBType:NVARCHAR2 this.Database.AddInParameter(":Createddate", info.Createddate);//DBType:DATE this.Database.AddInParameter(":Creator", info.Creator);//DBType:NVARCHAR2 this.Database.AddInParameter(":Approvedstate", info.Approvedstate);//DBType:NUMBER this.Database.ExecuteNonQuery(sqlCommand); } finally { this.Database.ClearParameter(); } return info; }
protected void BtnBatchApply_Click(object sender,EventArgs e) { CheckSelectedAssetId(); if(AssetIds.Count==0) { UIHelper.Alert(this, "请选择要申请报废的设备"); return; } var currentAssetScrappedInfos = AssetscrappedService.RetrieveAssetscrappedByAssetNo(AssetIds); if (currentAssetScrappedInfos.Count > 0) { if (currentAssetScrappedInfos.Where(p => p.Approvedstate == AssetScrappedState.None || p.Approvedstate == AssetScrappedState.Rejected). Count() == 0) { UIHelper.Alert(this, "对不起,您选择申请报废设备正在报废审核中或已报废!请重新选择!"); return; } } foreach (var assetId in AssetIds) { var assetScrappedInfo = new Assetscrapped(); assetScrappedInfo.Assetscrappedid = string.Empty; assetScrappedInfo.Assetno = assetId; assetScrappedInfo.Scrappeddate = DateTime.Today; assetScrappedInfo.Scrappeduser = WebContext.Current.CurrentUser.Username; assetScrappedInfo.Createddate = DateTime.Now; assetScrappedInfo.Approvedstate = AssetScrappedState.Submitted; assetScrappedInfo.Creator = WebContext.Current.CurrentUser.Username; AssetscrappedService.CreateAssetscrapped(assetScrappedInfo); } UIHelper.Alert(this, "申请成功!"); LoadData(pcData.CurrentIndex); }
public Assetscrapped UpdateAssetscrappedByAssetscrappedid(Assetscrapped info) { try { Management.BeginTransaction(); Management.UpdateAssetscrappedByAssetscrappedid(info); Management.Commit(); } catch { Management.Rollback(); throw; } return info; }