private void LoadData()
{
List <FineOffice.Modules.CNS_CensusRelation> relationList = relationBll.GetListAll();
foreach (FineOffice.Modules.CNS_CensusRelation relation in relationList)
{
ddlRelation.Items.Add(relation.Relation, relation.Relation);
}
List <FineOffice.Modules.CNS_PoliticalAffiliation> affiliationList = affiliationBll.GetListAll();
foreach (FineOffice.Modules.CNS_PoliticalAffiliation affiliation in affiliationList)
{
ddlPolitical.Items.Add(affiliation.Political, affiliation.ID.ToString());
}
List <FineOffice.Modules.AM_Kind> educationList = kindBll.GetList(d => d.KindID == 1);
foreach (FineOffice.Modules.AM_Kind kind in educationList)
{
ddlEducation.Items.Add(kind.Name, kind.ID.ToString());
}
if (Request["ID"] != null)
{
int id = int.Parse(Request["ID"]);
hiddenID.Text = Request["ID"];
FineOffice.Modules.CNS_CensusMember model = memberBll.GetModel(d => d.ID == id);
txtRegisterNO.Text = model.RegisterNO;
txtAddress.Text = model.Address;
dtpBrithday.Text = string.Format("{0:yyyy-MM-dd}", model.Brithday);
dtpCancelDate.Text = string.Format("{0:yyyy-MM-dd}", model.CancelDate);
txtCancelReason.Text = model.CancelReason;
txtCompany.Text = model.Company;
ddlEducation.SelectedValue = model.EducationID.ToString();
txtHeight.Text = model.Height;
txtIDCard.Text = model.IDCard;
dtpIngoingDate.Text = string.Format("{0:yyyy-MM-dd}", model.IngoingDate);
txtIngoingReason.Text = model.IngoingReason;
chkIsCanceled.Checked = model.IsCanceled.Value;
txtMarriage.Text = model.Marriage;
txtMilitaryService.Text = model.MilitaryService;
dtpMoveOutDate.Text = string.Format("{0:yyyy-MM-dd}", model.MoveOutDate);
txtMoveToAddress.Text = model.MoveToAddress;
txtName.Text = model.Name;
txtNationalilty.Text = model.Nationalilty;
txtOccupation.Text = model.Occupation;
ddlPolitical.SelectedValue = model.PoliticalID.ToString();
txtTypeOfBlood.Text = model.TypeOfBlood;
txtTel.Text = model.Tel;
ddlSex.SelectedValue = model.Sex.ToString();
txtReligion.Text = model.Religion;
txtOtherName.Text = model.OtherName;
ddlRelation.SelectedValue = model.Relation;
txtPreviousAddress.Text = model.PreviousAddress;
txtPlaceOfAncestral.Text = model.PlaceOfAncestral;
txtPlaceOfBirth.Text = model.PlaceOfBirth;
}
}
/// <summary>
/// 保存导入数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
FineOffice.Common.Excel.ExcelHelper toExcel = new FineOffice.Common.Excel.ExcelHelper();
FineOffice.Web.WebExcelHelper excelHelper = new FineOffice.Web.WebExcelHelper();
string serverPath = Server.MapPath("~/Config/Template/CNS_CensusMember.xml");
List <ExcelHeader> headerList = toExcel.GetHeaderList(serverPath);
try
{
foreach (GridRow row in gridMember.Rows)
{
gridMember.SelectedRowIndex = row.RowIndex;
Dictionary <string, object> valueMap = new Dictionary <string, object>();
foreach (GridColumn column in gridMember.Columns)
{
FineUI.BoundField field = column as FineUI.BoundField;
string value = row.Values[column.ColumnIndex].ToString();
if (field != null)
{
valueMap.Add(field.DataField, value);
}
}
FineOffice.Modules.CNS_CensusMember model = toExcel.Create <FineOffice.Modules.CNS_CensusMember>(headerList, valueMap);
FineOffice.Modules.CNS_CensusRegister register = registerBll.GetModel(m => m.RegisterNO == model.RegisterNO);
if (register == null)
{
register = new FineOffice.Modules.CNS_CensusRegister();
register.RegisterNO = model.RegisterNO;
register.HouseHolder = model.HouseHolder;
FineOffice.Modules.CNS_CensusType type = typeBll.GetModel(t => t.CensusTypeName == model.CensusTypeName);
if (type == null)
{
type = new FineOffice.Modules.CNS_CensusType();
type.CensusTypeName = model.CensusTypeName;
type = typeBll.Add(type);
}
register.CensusTypeID = type.ID;
registerBll.Add(register);
}
if (model.Gender == "男")
{
model.Sex = 1;
}
else
{
model.Sex = 0;
}
FineOffice.Modules.CNS_PoliticalAffiliation political = politicalBll.GetModel(m => m.Political == model.Political);
if (political == null)
{
political = new FineOffice.Modules.CNS_PoliticalAffiliation();
political.Political = model.Political;
political = politicalBll.Add(political);
}
model.PoliticalID = political.ID;
FineOffice.Modules.AM_Kind kind = kindBll.GetModel(m => m.Name == model.Education);
if (kind != null)
{
model.EducationID = kind.ID;
}
memberBll.Add(model);
}
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference("member_close"));
}
catch (Exception ex)
{
FineUI.Alert.ShowInParent(ex.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string registerNO = txtRegisterNO.Text.Trim();
if (registerBll.GetModel(r => r.RegisterNO == registerNO) == null)
{
FineUI.Alert.ShowInParent("该户号不存在！");
return;
}
DateTime?brithday = null;
if (dtpBrithday.Text.Length > 0)
{
brithday = DateTime.Parse(dtpBrithday.Text);
}
DateTime?cancelDate = null;
if (dtpCancelDate.Text.Length > 0)
{
cancelDate = DateTime.Parse(dtpCancelDate.Text);
}
DateTime?ingoingDate = null;
if (dtpIngoingDate.Text.Length > 0)
{
ingoingDate = DateTime.Parse(dtpIngoingDate.Text);
}
DateTime?moveOutDate = null;
if (dtpMoveOutDate.Text.Length > 0)
{
moveOutDate = DateTime.Parse(dtpMoveOutDate.Text);
}
int id = int.Parse(hiddenID.Text);
FineOffice.Modules.CNS_CensusMember model = memberBll.GetModel(d => d.ID == id);
model.Address = txtAddress.Text.Trim();
model.Brithday = brithday;
model.CancelDate = cancelDate;
model.CancelReason = txtCancelReason.Text.Trim();
model.Company = txtCompany.Text.Trim();
model.EducationID = int.Parse(ddlEducation.SelectedValue);
model.Height = txtHeight.Text.Trim();
model.IDCard = txtIDCard.Text.Trim();
model.IngoingDate = ingoingDate;
model.IngoingReason = txtIngoingReason.Text.Trim();
model.IsCanceled = chkIsCanceled.Checked;
model.Marriage = txtMarriage.Text.Trim();
model.MilitaryService = txtMilitaryService.Text.Trim();
model.MoveOutDate = moveOutDate;
model.MoveToAddress = txtMoveToAddress.Text.Trim();
model.Name = txtName.Text.Trim();
model.Nationalilty = txtNationalilty.Text.Trim();
model.Occupation = txtOccupation.Text.Trim();
model.PoliticalID = int.Parse(ddlPolitical.SelectedValue);
model.TypeOfBlood = txtTypeOfBlood.Text.Trim();
model.Tel = txtTel.Text.Trim();
model.Sex = short.Parse(ddlSex.SelectedValue);
model.Religion = txtReligion.Text.Trim();
model.OtherName = txtOtherName.Text.Trim();
model.Relation = ddlRelation.SelectedText;
model.PreviousAddress = txtPreviousAddress.Text.Trim();
model.PlaceOfAncestral = txtPlaceOfAncestral.Text.Trim();
model.PlaceOfBirth = txtPlaceOfBirth.Text.Trim();
model.RegisterNO = txtRegisterNO.Text.Trim();
memberBll.Update(model);
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference("member_close"));
}