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();
}
