public int AddServer(RecordsFamilyInfoModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into ARCHIVE_FAMILY_INFO(");
builder.Append("FamilyRecordID,IDCardNo,RecordID,HomeAddr,HomeAddrInfo,ToiletType,HouseType,IsPoorfy,LiveStatus,IncomeAvg,CreateUnit,HouseArea,Monthoil,MonthSalt,CreatedBy,CreatedDate,LastUpDateBy,LastUpdateDate)");
builder.Append(" values (");
builder.Append("@FamilyRecordID,@IDCardNo,@RecordID,@HomeAddr,@HomeAddrInfo,@ToiletType,@HouseType,@IsPoorfy,@LiveStatus,@IncomeAvg,@CreateUnit,@HouseArea,@Monthoil,@MonthSalt,@CreatedBy,@CreatedDate,@LastUpDateBy,@LastUpdateDate)");
builder.Append(";select @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@FamilyRecordID", MySqlDbType.String, 21),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@RecordID", MySqlDbType.String, 17),
new MySqlParameter("@HomeAddr", MySqlDbType.String, 200),
new MySqlParameter("@HomeAddrInfo", MySqlDbType.String, 200),
new MySqlParameter("@ToiletType", MySqlDbType.String, 1),
new MySqlParameter("@HouseType", MySqlDbType.String, 1),
new MySqlParameter("@IsPoorfy", MySqlDbType.String, 1),
new MySqlParameter("@LiveStatus", MySqlDbType.String, 1),
new MySqlParameter("@IncomeAvg", MySqlDbType.Decimal),
new MySqlParameter("@CreateUnit", MySqlDbType.String, 100),
new MySqlParameter("@HouseArea", MySqlDbType.Decimal),
new MySqlParameter("@Monthoil", MySqlDbType.Decimal),
new MySqlParameter("@MonthSalt", MySqlDbType.Decimal),
new MySqlParameter("@CreatedBy", MySqlDbType.String),
new MySqlParameter("@CreatedDate", MySqlDbType.Date),
new MySqlParameter("@LastUpDateBy", MySqlDbType.String),
new MySqlParameter("@LastUpdateDate", MySqlDbType.Date)
};
cmdParms[0].Value = model.FamilyRecordID;
cmdParms[1].Value = model.IDCardNo;
cmdParms[2].Value = model.RecordID;
cmdParms[3].Value = model.HomeAddr;
cmdParms[4].Value = model.HomeAddrInfo;
cmdParms[5].Value = model.ToiletType;
cmdParms[6].Value = model.HouseType;
cmdParms[7].Value = model.IsPoorfy;
cmdParms[8].Value = model.LiveStatus;
cmdParms[9].Value = model.IncomeAvg;
cmdParms[10].Value = model.CreateUnit;
cmdParms[11].Value = model.HouseArea;
cmdParms[12].Value = model.Monthoil;
cmdParms[13].Value = model.MonthSalt;
cmdParms[14].Value = model.CreateBy;
cmdParms[15].Value = model.CreatedDate;
cmdParms[16].Value = model.LastUpDateBy;
cmdParms[17].Value = model.LastUpdateDate;
object single = MySQLHelper.GetSingleServer(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
private void dgvData_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if ((this.bds.Position >= 0) && (e.RowIndex >= 0))
{
DataRowView view = (DataRowView)this.bds.List[this.bds.Position];
if (((this.dgvData.Columns[e.ColumnIndex].HeaderText == "修改") && (this.bds.Position >= 0)) && (e.RowIndex >= 0))
{
using (PBControler controler = new PBControler(new PersonForm(view.Row["IDCardNo"].ToString()), new PersonInfoFactory()))
{
controler.IParentFrm.IShowDialog();
ChackDate();
}
GC.Collect();
}
else if (((this.dgvData.Columns[e.ColumnIndex].HeaderText == "删除") && (this.bds.Position >= 0)) && (e.RowIndex >= 0))
{
if (view != null)
{
DataRow row = view.Row;
if (row["HouseRelation"].ToString() == "1")
{
string str = "？当前人员为户主且有相应的家庭档案信息，是否删除现家庭档案和所有家庭成员的关联关系？";
if (MessageBox.Show("确定删除:" + row["CustomerName"].ToString() + str + "删除之后的信息将无法恢复!", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
RecordsBaseInfoBLL archive_baseinfo = new RecordsBaseInfoBLL();
foreach (RecordsBaseInfoModel archive_baseinfo2 in archive_baseinfo.GetModelList(string.Format(" and FamilyIDCardNo = '{0}' ", this.Model.RecordID)))
{
archive_baseinfo2.RecordID = null;
archive_baseinfo2.HouseRelation = null;
archive_baseinfo2.HouseRealOther = null;
archive_baseinfo.Update(archive_baseinfo2);
}
RecordsFamilyInfoBLL archive_family_info = new RecordsFamilyInfoBLL();
RecordsFamilyInfoModel model = archive_family_info.GetModel(this.Model.IDCardNo);
if (model != null)
{
archive_family_info.Delete(model.ID);
}
new RecordsBaseInfoBLL().DelTheMan(row["IDCardNo"].ToString());
// row.Delete();
// row.Table.AcceptChanges();
ChackDate();
}
}
else if (MessageBox.Show("确定删除:" + row["CustomerName"].ToString() + "？删除之后的信息将无法恢复!", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
new RecordsBaseInfoBLL().DelTheMan(row["IDCardNo"].ToString());
row.Delete();
row.Table.AcceptChanges();
ChackDate();
}
}
}
}
}
private void listView1_ItemActivate(object sender, EventArgs e)
{
Predicate <RecordsFamilyInfoModel> match = null;
this.FamilyArcID = this.listView1.FocusedItem.SubItems[0].Text;
if (this.FamilyArcID != "无")
{
if (match == null)
{
match = c => c.RecordID.ToString() == this.FamilyArcID;
}
RecordsFamilyInfoModel recordsFamilyInfoModel = this.familys.Find(match);
if (recordsFamilyInfoModel != null)
{
this.Model.FamilyIDCardNo = recordsFamilyInfoModel.IDCardNo;
this.Model.HouseID = recordsFamilyInfoModel.IDCardNo;
this.Model.HouseName = recordsFamilyInfoModel.CustomerName;
}
base.DialogResult = DialogResult.OK;
}
else if (this.Model.HouseRelation == "1")
{
if (MessageBox.Show("当前人员为户主且有相应的家庭档案信息，此操作将会将人员的家庭关系删除，是否继续？\r\n（注意：这样将会删除现家庭档案的所有信息和家庭中所有对应的人员关系!）", "家庭档案", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.OK)
{
RecordsBaseInfoBLL recordsBaseInfoBLL = new RecordsBaseInfoBLL();
foreach (RecordsBaseInfoModel recordsBaseInfoModel in recordsBaseInfoBLL.GetModelList(string.Format(" and FY_ARCHIVEID = '{0}' ", this.Model.FamilyIDCardNo)))
{
recordsBaseInfoModel.FamilyIDCardNo = null;
recordsBaseInfoModel.HouseRelation = null;
recordsBaseInfoModel.HouseRealOther = null;
recordsBaseInfoBLL.Update(recordsBaseInfoModel);
}
new RecordsFamilyInfoBLL();
this.Model.FamilyIDCardNo = null;
this.Model.HouseID = null;
this.Model.HouseName = null;
this.Model.HouseRelation = null;
this.Model.HouseRealOther = null;
base.DialogResult = DialogResult.OK;
}
}
else if (MessageBox.Show("此操作将会将人员的家庭关系删除，是否继续?", "家庭档案", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.OK)
{
this.Model.FamilyIDCardNo = null;
this.Model.HouseID = null;
this.Model.HouseName = null;
this.Model.HouseRelation = null;
this.Model.HouseRealOther = null;
base.DialogResult = DialogResult.OK;
}
}
private void btnDel_Click(object sender, EventArgs e)
{
if (this.bds.Position >= 0)
{
DataRowView view = this.bds.List[this.bds.Position] as DataRowView;
if (view != null)
{
DataRow row = view.Row;
if (row["HouseRelation"].ToString() == "1")
{
string str = "？当前人员为户主且有相应的家庭档案信息，是否删除现家庭档案和所有家庭成员的关联关系？";
if (MessageBox.Show("确定删除:" + row["CustomerName"].ToString() + str + "删除之后的信息将无法恢复!", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
RecordsBaseInfoBLL archive_baseinfo = new RecordsBaseInfoBLL();
foreach (RecordsBaseInfoModel archive_baseinfo2 in archive_baseinfo.GetModelList(string.Format(" and FamilyIDCardNo = '{0}' ", row["IDCardNo"].ToString())))
{
archive_baseinfo2.RecordID = null;
archive_baseinfo2.HouseRelation = null;
archive_baseinfo2.HouseRealOther = null;
archive_baseinfo.Update(archive_baseinfo2);
}
RecordsFamilyInfoBLL archive_family_info = new RecordsFamilyInfoBLL();
RecordsFamilyInfoModel model = archive_family_info.GetModel(row["IDCardNo"].ToString());
if (model != null)
{
archive_family_info.Delete(model.ID);
}
//删除签名
DeteSign(SignPath, row["IDCardNo"].ToString());
new RecordsBaseInfoBLL().DelTheMan(row["IDCardNo"].ToString());
row.Delete();
row.Table.AcceptChanges();
}
}
else if (MessageBox.Show("确定删除:" + row["CustomerName"].ToString() + "？删除之后的信息将无法恢复!", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
//删除签名
DeteSign(SignPath, row["IDCardNo"].ToString());
new RecordsBaseInfoBLL().DelTheMan(row["IDCardNo"].ToString());
row.Delete();
row.Table.AcceptChanges();
}
}
}
}
private void listView1_ItemActivate(object sender, EventArgs e)
{
Predicate <RecordsBaseInfoModel> match = null;
this.FamilyArcID = this.listView1.FocusedItem.SubItems[2].Text;
if (this.FamilyArcID != "")
{
if (match == null)
{
match = c => c.IDCardNo.ToString() == this.FamilyArcID;
}
RecordsBaseInfoModel HouseModel = new RecordsBaseInfoModel();
HouseModel = this.ModelList.Find(match);
RecordsFamilyInfoModel FamilyModel = new RecordsFamilyInfoBLL().GetModel(HouseModel.IDCardNo);
if (FamilyModel == null)
{
RecordsFamilyInfoModel archive_family_info = new RecordsFamilyInfoModel
{
RecordID = HouseModel.RecordID,
IDCardNo = HouseModel.IDCardNo,
ToiletType = "1",
HouseType = "1",
LiveStatus = "1",
CreatedDate = new DateTime?(DateTime.Today)
};
FamilyModel = archive_family_info;
FamilyModel.FamilyRecordID = HouseModel.IDCardNo;
FamilyModel.CreatedDate = new DateTime?(DateTime.Today);
FamilyModel.CreateBy = ConfigHelper.GetNode("doctor");
FamilyModel.CreateUnit = ConfigHelper.GetNode("orgCode");
FamilyModel.CustomerName = HouseModel.CustomerName;
//增加户主信息
new RecordsFamilyInfoBLL().Add(archive_family_info);
RecordsBaseInfoBLL recordsBaseInfoBLL = new RecordsBaseInfoBLL();
HouseModel.FamilyIDCardNo = FamilyModel.IDCardNo;
HouseModel.HouseID = FamilyModel.IDCardNo;
HouseModel.HouseName = FamilyModel.CustomerName;
HouseModel.HouseRelation = "1";
HouseModel.HouseRealOther = "本人";
recordsBaseInfoBLL.Update(HouseModel);
}
this.Model.FamilyIDCardNo = FamilyModel.IDCardNo;
this.Model.HouseID = FamilyModel.IDCardNo;
this.Model.HouseName = FamilyModel.CustomerName;
base.DialogResult = DialogResult.OK;
}
}
public List <RecordsFamilyInfoModel> DataTableToList(DataTable dt)
{
List <RecordsFamilyInfoModel> list = new List <RecordsFamilyInfoModel>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
RecordsFamilyInfoModel item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public int AddServer(RecordsFamilyInfoModel model)
{
return(this.dal.AddServer(model));
}
public bool UpdateServer(RecordsFamilyInfoModel model)
{
return(this.dal.UpdateServer(model));
}
public bool UpdateServer(RecordsFamilyInfoModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update ARCHIVE_FAMILY_INFO set ");
builder.Append("FamilyRecordID=@FamilyRecordID,");
builder.Append("IDCardNo=@IDCardNo,");
builder.Append("RecordID=@RecordID,");
builder.Append("HomeAddr=@HomeAddr,");
builder.Append("HomeAddrInfo=@HomeAddrInfo,");
builder.Append("ToiletType=@ToiletType,");
builder.Append("HouseType=@HouseType,");
builder.Append("IsPoorfy=@IsPoorfy,");
builder.Append("LiveStatus=@LiveStatus,");
builder.Append("IncomeAvg=@IncomeAvg,");
builder.Append("CreateUnit=@CreateUnit,");
builder.Append("HouseArea=@HouseArea,");
builder.Append("Monthoil=@Monthoil,");
builder.Append("MonthSalt=@MonthSalt,");
builder.Append("CreatedBy=@CreateBy,");
builder.Append("CreatedDate=@CreatedDate,");
builder.Append("LastUpDateBy=@LastUpDateBy,");
builder.Append("LastUpdateDate=@LastUpdateDate");
builder.Append(" where IDCardNo=@IDCardNo");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@FamilyRecordID", MySqlDbType.String, 21),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@RecordID", MySqlDbType.String, 17),
new MySqlParameter("@HomeAddr", MySqlDbType.String, 200),
new MySqlParameter("@HomeAddrInfo", MySqlDbType.String, 200),
new MySqlParameter("@ToiletType", MySqlDbType.String, 1),
new MySqlParameter("@HouseType", MySqlDbType.String, 1),
new MySqlParameter("@IsPoorfy", MySqlDbType.String, 1),
new MySqlParameter("@LiveStatus", MySqlDbType.String, 1),
new MySqlParameter("@IncomeAvg", MySqlDbType.Decimal),
new MySqlParameter("@CreateUnit", MySqlDbType.String, 100),
new MySqlParameter("@HouseArea", MySqlDbType.Decimal),
new MySqlParameter("@Monthoil", MySqlDbType.Decimal),
new MySqlParameter("@MonthSalt", MySqlDbType.Decimal),
new MySqlParameter("@CreateBy", MySqlDbType.String),
new MySqlParameter("@CreatedDate", MySqlDbType.Date),
new MySqlParameter("@LastUpDateBy", MySqlDbType.String),
new MySqlParameter("@LastUpdateDate", MySqlDbType.Date),
//new MySqlParameter("@ID", MySqlDbType.Int32, 8)
};
cmdParms[0].Value = model.FamilyRecordID;
cmdParms[1].Value = model.IDCardNo;
cmdParms[2].Value = model.RecordID;
cmdParms[3].Value = model.HomeAddr;
cmdParms[4].Value = model.HomeAddrInfo;
cmdParms[5].Value = model.ToiletType;
cmdParms[6].Value = model.HouseType;
cmdParms[7].Value = model.IsPoorfy;
cmdParms[8].Value = model.LiveStatus;
cmdParms[9].Value = model.IncomeAvg;
cmdParms[10].Value = model.CreateUnit;
cmdParms[11].Value = model.HouseArea;
cmdParms[12].Value = model.Monthoil;
cmdParms[13].Value = model.MonthSalt;
cmdParms[14].Value = model.CreateBy;
cmdParms[15].Value = model.CreatedDate;
cmdParms[16].Value = model.LastUpDateBy;
cmdParms[17].Value = model.LastUpdateDate;
//cmdParms[18].Value = model.ID;
return(MySQLHelper.ExecuteSqlServer(builder.ToString(), cmdParms) > 0);
}
public RecordsFamilyInfoModel DataRowToModel(DataRow row)
{
RecordsFamilyInfoModel recordsFamilyInfoModel = new RecordsFamilyInfoModel();
if (row != null)
{
if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != ""))
{
recordsFamilyInfoModel.ID = int.Parse(row["ID"].ToString());
}
if ((row["FamilyRecordID"] != null) && (row["FamilyRecordID"] != DBNull.Value))
{
recordsFamilyInfoModel.FamilyRecordID = row["FamilyRecordID"].ToString();
}
if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value))
{
recordsFamilyInfoModel.IDCardNo = row["IDCardNo"].ToString();
}
if ((row["RecordID"] != null) && (row["RecordID"] != DBNull.Value))
{
recordsFamilyInfoModel.RecordID = row["RecordID"].ToString();
}
if ((row["HomeAddr"] != null) && (row["HomeAddr"] != DBNull.Value))
{
recordsFamilyInfoModel.HomeAddr = row["HomeAddr"].ToString();
}
if ((row["HomeAddrInfo"] != null) && (row["HomeAddrInfo"] != DBNull.Value))
{
recordsFamilyInfoModel.HomeAddrInfo = row["HomeAddrInfo"].ToString();
}
if ((row["ToiletType"] != null) && (row["ToiletType"] != DBNull.Value))
{
recordsFamilyInfoModel.ToiletType = row["ToiletType"].ToString();
}
if ((row["HouseType"] != null) && (row["HouseType"] != DBNull.Value))
{
recordsFamilyInfoModel.HouseType = row["HouseType"].ToString();
}
if ((row["IsPoorfy"] != null) && (row["IsPoorfy"] != DBNull.Value))
{
recordsFamilyInfoModel.IsPoorfy = row["IsPoorfy"].ToString();
}
if ((row["LiveStatus"] != null) && (row["LiveStatus"] != DBNull.Value))
{
recordsFamilyInfoModel.LiveStatus = row["LiveStatus"].ToString();
}
if (((row["IncomeAvg"] != null) && (row["IncomeAvg"] != DBNull.Value)) && (row["IncomeAvg"].ToString() != ""))
{
recordsFamilyInfoModel.IncomeAvg = new decimal?(decimal.Parse(row["IncomeAvg"].ToString()));
}
if ((row["CreateUnit"] != null) && (row["CreateUnit"] != DBNull.Value))
{
recordsFamilyInfoModel.CreateUnit = row["CreateUnit"].ToString();
}
if (((row["HouseArea"] != null) && (row["HouseArea"] != DBNull.Value)) && (row["HouseArea"].ToString() != ""))
{
recordsFamilyInfoModel.HouseArea = new decimal?(decimal.Parse(row["HouseArea"].ToString()));
}
if (((row["Monthoil"] != null) && (row["Monthoil"] != DBNull.Value)) && (row["Monthoil"].ToString() != ""))
{
recordsFamilyInfoModel.Monthoil = new decimal?(decimal.Parse(row["Monthoil"].ToString()));
}
if (((row["MonthSalt"] != null) && (row["MonthSalt"] != DBNull.Value)) && (row["MonthSalt"].ToString() != ""))
{
recordsFamilyInfoModel.MonthSalt = new decimal?(decimal.Parse(row["MonthSalt"].ToString()));
}
if (((row["CreatedBy"] != null) && (row["CreatedBy"] != DBNull.Value)) && (row["CreatedBy"].ToString() != ""))
{
recordsFamilyInfoModel.CreateBy = row["CreatedBy"].ToString();
}
if (((row["CreatedDate"] != null) && (row["CreatedDate"] != DBNull.Value)) && (row["CreatedDate"].ToString() != ""))
{
recordsFamilyInfoModel.CreatedDate = new DateTime?(DateTime.Parse(row["CreatedDate"].ToString()));
}
if (((row["LastUpDateBy"] != null) && (row["LastUpDateBy"] != DBNull.Value)) && (row["LastUpDateBy"].ToString() != ""))
{
recordsFamilyInfoModel.LastUpDateBy = row["LastUpDateBy"].ToString();
}
if (((row["LastUpdateDate"] != null) && (row["LastUpdateDate"] != DBNull.Value)) && (row["LastUpdateDate"].ToString() != ""))
{
recordsFamilyInfoModel.LastUpdateDate = new DateTime?(DateTime.Parse(row["LastUpdateDate"].ToString()));
}
if ((row["CustomerName"] != null) && (row["CustomerName"] != DBNull.Value))
{
recordsFamilyInfoModel.CustomerName = row["CustomerName"].ToString();
}
}
return(recordsFamilyInfoModel);
}
