public void btnSave_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(this.txtName.Text) && !string.IsNullOrEmpty(this.txtCode.Text)) { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { BusinessUnitInfo bui = new BusinessUnitInfo(); bui.BusinessUnitName = this.txtName.Text.Trim(); BusinessUnitInfo code = db.BusinessUnitInfo.SingleOrDefault(u => u.BusinessUnitCode == this.txtCode.Text.Trim()); if (code != null) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('往来单位代码重复!')</script>"); return; } bui.BusinessUnitCode = this.txtCode.Text.Trim(); if (this.DdlType.SelectedIndex == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择往来单位类别!')</script>"); return; } bui.BusinessUnitTypeID = Convert.ToInt32(this.DdlType.SelectedValue); bui.BusinessUnitAddress1 = this.txtAdree.Text.Trim(); bui.BusinessUnitPhone = this.txtTel.Text.Trim(); bui.InCharger = this.txtCharge.Text.Trim(); bui.Remark = this.txtRemark.Text.Trim(); db.BusinessUnitInfo.InsertOnSubmit(bui); db.SubmitChanges(); Response.Redirect("BusinessManage.aspx", false); } } }
public void InitTest() { // Arrange. var role = new RoleInfo(1, "Role 1"); var businessUnit = new BusinessUnitInfo(2, "BU 2"); var config1 = new ProcessReportSecurityConfigurationEdit { RoleId = 1, BusinessUnitId = 2 }; var config2 = new ProcessReportSecurityConfigurationEdit { RoleId = Constants.AllRolesId, BusinessUnitId = Constants.AllBusinessUnitsId }; var config3 = new ProcessReportSecurityConfigurationEdit { RoleId = 10, BusinessUnitId = 10 }; var organizationInfo = Mock.Create<IOrganizationInfo>(); Mock.Arrange(() => organizationInfo.BusinessUnits).Returns(new List<IBusinessUnitInfo> {businessUnit}); Mock.Arrange(() => organizationInfo.Roles).Returns(new List<IRoleInfo> {role}); var vm1 = new ReportSecurityConfigurationViewModel { OrganizationInfo = organizationInfo }; var vm2 = new ReportSecurityConfigurationViewModel { OrganizationInfo = organizationInfo }; var vm3 = new ReportSecurityConfigurationViewModel { OrganizationInfo = organizationInfo }; // Act. vm1.Init(config1); vm2.Init(config2); vm3.Init(config3); // Assert. Assert.AreSame(config1, vm1.Model); Assert.AreEqual("Role 1", vm1.RoleName); Assert.AreEqual("BU 2", vm1.BusinessUnitName); Assert.AreSame(config2, vm2.Model); Assert.AreEqual(Constants.AllRolesName, vm2.RoleName); Assert.AreEqual(Constants.AllBusinessUnitsName, vm2.BusinessUnitName); Assert.AreSame(config3, vm3.Model); Assert.AreEqual(Constants.Unknown, vm3.RoleName); Assert.AreEqual(Constants.Unknown, vm3.BusinessUnitName); }
private void LoadData() { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { int id = Convert.ToInt32(Request.QueryString["BusinessUnitID"]); BusinessUnitInfo bui = db.BusinessUnitInfo.SingleOrDefault(a => a.BusinessUnitID == id); if (bui != null) { this.txtName.Text = bui.BusinessUnitName.ToString(); this.txtCode.Text = bui.BusinessUnitCode.ToString(); this.DdlType.SelectedValue = bui.BusinessUnitTypeID.ToString(); this.txtAdree.Text = bui.BusinessUnitAddress1.ToString(); this.txtTel.Text = bui.BusinessUnitPhone.ToString(); this.txtCharge.Text = bui.InCharger.ToString(); this.txtRemark.Text = bui.Remark.ToString(); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('记录不存在! ');</script>"); Response.Redirect("BusinessManage.aspx", false); } } }
private string InsertData(Net.SourceForge.Koogra.Excel.Row row) { string strResult = ""; using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //检查往来单位类别 if (row.Cells[0] == null || row.Cells[1] == null) { return("往来单位类别信息不完整"); } //写入往来单位类别信息 BusinessUnitType but; //检查往来单位类别是否存在 if (!db.BusinessUnitType.Any(a => a.BusinessUnitTypeName == row.Cells[1].Value.ToString())) { but = new BusinessUnitType(); //MT.MaterialMainTypeCode = but.BusinessUnitTypeCode = row.Cells[0].Value.ToString(); but.BusinessUnitTypeName = row.Cells[1].Value.ToString(); but.Remark = row.Cells[2] == null ? "" : row.Cells[2].Value.ToString(); db.BusinessUnitType.InsertOnSubmit(but); db.SubmitChanges(); } else { but = db.BusinessUnitType.SingleOrDefault(a => a.BusinessUnitTypeName == row.Cells[1].Value.ToString()); but.BusinessUnitTypeCode = row.Cells[0].Value.ToString(); but.BusinessUnitTypeName = row.Cells[1].Value.ToString(); but.Remark = row.Cells[2] == null ? "" : row.Cells[2].Value.ToString(); db.SubmitChanges(); } //*************************************************************************** //写入单位信息 if (row.Cells[3] == null || row.Cells[4] == null) { return("单位信息不完整"); } //写入单位信息 BusinessUnitInfo bui; //检查单位是否存在 if (!db.BusinessUnitInfo.Any(a => a.BusinessUnitCode == row.Cells[3].Value.ToString())) { bui = new BusinessUnitInfo(); //MT.MaterialMainTypeCode = bui.BusinessUnitCode = row.Cells[3].Value.ToString(); bui.BusinessUnitName = row.Cells[4].Value.ToString(); bui.Remark = row.Cells[5] == null ? "" : row.Cells[5].Value.ToString(); bui.BusinessUnitTypeID = but.BusinessUnitTypeID; db.BusinessUnitInfo.InsertOnSubmit(bui); db.SubmitChanges(); } else { bui = db.BusinessUnitInfo.SingleOrDefault(a => a.BusinessUnitCode == row.Cells[3].Value.ToString()); bui.BusinessUnitCode = row.Cells[3].Value.ToString(); bui.BusinessUnitName = row.Cells[4].Value.ToString(); bui.BusinessUnitTypeID = but.BusinessUnitTypeID; bui.Remark = row.Cells[5] == null ? "" : row.Cells[5].Value.ToString(); db.SubmitChanges(); } //*************************************************************************** //写项目信息 if (row.Cells[6] == null || row.Cells[7] == null) { return("项目信息不完整"); } ProjectInfo pi; //检查生产厂商类别是否存在 if (!db.ProjectInfo.Any(a => a.ProjectCode == row.Cells[6].Value.ToString())) { pi = new ProjectInfo(); //MT.MaterialMainTypeCode = pi.ProjectCode = row.Cells[6].Value.ToString(); pi.ProjectName = row.Cells[7].Value.ToString(); pi.Remark = row.Cells[8] == null ? "" : row.Cells[8].Value.ToString(); pi.Owner = bui.BusinessUnitID; db.ProjectInfo.InsertOnSubmit(pi); db.SubmitChanges(); } else { pi = db.ProjectInfo.SingleOrDefault(a => a.ProjectCode == row.Cells[6].Value.ToString()); pi.ProjectCode = row.Cells[6].Value.ToString(); pi.ProjectName = row.Cells[7].Value.ToString(); pi.Remark = row.Cells[8] == null ? "" : row.Cells[8].Value.ToString(); pi.Owner = bui.BusinessUnitID; db.SubmitChanges(); } } return(strResult); }
public RuntimeProperties(ServiceConfigParameters ConfigParameters) { _ServiceConfigParameters = ConfigParameters; //personal _Staff_ID = new StaffID(); _Full_Name = new FullName(); _Country = new Country(); _ContractType = new ContractType(); _ContractTypeForReports = new ContractTypeForReports(); _Position = new Position(); _DateOfTREnd = new DateOfTREnd(); _DateOfTRStart = new DateOfTRStart(); _DateOfEntrance = new DateOfEntrance(); _CalendarName = new CalendarName(); _TemplateFilter = new TemplateFilter(); _ArePropReadyPersonal = new ArePropReady(); _BusinessUnitInfo = new BusinessUnitInfo(); _PMSA = new PMSA(); _PMSAItem = new PMSAItem(); _Gender = new Gender(); _ActivityCodeInfo = new ActivityCodeInfo(); _OfficialLS = new OfficialLS(); _PhoneDirOnly = new PhoneDirOnly(); //update _SelectedDate = new SelectedDate(); _SelectedDateStatus = new SelectedDateStatus(); _SelectedDateTransactionStatus = new SelectedDateTransactionStatus(); _SelectedDateType = new SelectedDateType(); _SelectedDateisOptional = new SelectedDateisOptional(); _PercentPerDay = new PercentPerDay(); _SelectedJob = new SelectedJob(); _MaxHoursDaily = new MaxHoursDaily(); _ArePropReadyTRUpdate = new ArePropReady(); _TRInputListClient = new TRInputListClient(); _LastOpenDay = new LastOpenDay(); //submit _SumOfHours = new SumOfHours(); _TRInputList = new TRInputList(); _WorkingHoursWeekly = new WorkingHoursWeekly(); _MinHoursDaily = new MinHoursDaily(); _FirstSubmitableDay = new FirstSubmitableDay(); _SelectedActivityCode = new SelectedActivityCode(); _Description = new Description(); _Location = new Location(); _BusinessUnit = new BusinessUnit(); _ReasonCode = new ReasonCode(); _ArePropReadyTRSubmit = new ArePropReady(); _PeriodEnd = new PeriodEnd(); //reports _PeriodStarting = new PeriodStarting(); _ArePropReadyReports = new ArePropReady(); _ReportIntervalFrom = new ReportIntervalFrom(); _ReportIntervalTo = new ReportIntervalTo(); _UserIDList = new UserIDList(); _SelectedReportTemplate = new SelectedReportTemplate(); _SelectedReportType = new SelectedReportType(); //külön queryk-ben/Getparameters-ben kap értéket _LastSubmittedDay = new LastSubmittedDay(); _JobCh = new JobCH(); _InsertedHour = new InstertedHour(); _ValidationConstraint = new ValidationConstraint(); _JobFilter = new JobFilter(); _ActivityCodeFilter = new ActivityCodeFilter(); _UserGroup = new UserGroup(); _ReasonCodeFilter = new ReasonCodeFilter(); }