private void Button_Click(object sender, RoutedEventArgs e)
{
CBFModels model = new CBFModels();
model = (CBFModels)this.DataContext;
MessageBox.Show(model.Family[0].Name.ToString());
}
/// <summary>
/// 新建承包方
/// </summary>
public void CreateCBF(CBFModels model)
{
OracleConnection con = new OracleConnection(connectString);
string sql = string.Format("insert into CBF(CBFBM,CBFLX,CBFMC,CBFZJLX,CBFZJHM,CBFDZ,YZBM,LXDH,CBFCYSL,CBFDCRQ,CBFDCY,CBFDCJS,GSJS,GSJSR,GSSHRQ,GSSHR) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}',to_date('{9}','YYYYMMDD'),'{10}','{11}','{12}','{13}',to_date('{14}','YYYYMMDD'),'{15}')", model.ID, model.Type, model.Name, model.CertificateType, model.CardNumber, model.Address, model.PostCode, model.Tel, model.MemberCount, model.SurveyDate, model.Claimsman, model.SurveyEvent, model.PublicEvent, model.PublicEventPerson, model.PublicDate, model.PublicCheckPerson);
OracleCommand cmd = new OracleCommand(sql, con);
int count = model.Family.Count();
try
{
con.Open();
cmd.ExecuteNonQuery();
for (int i = 0; i < count; i++)
{
string _familysql = string.Format("insert into CBF_JTCY(CBFBM,CYXM,CYXB,CYZJLX,CYZJHM,YHZGX,CYBZ,SFGYR) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", model.Family[i].ID, model.Family[i].Name, model.Family[i].Sex, model.Family[i].CertificateType, model.Family[i].CardNumber, model.Family[i].RelationShip, model.Family[i].Note, model.Family[i].IsShared);
OracleCommand _familycmd = new OracleCommand(_familysql, con);
_familycmd.ExecuteNonQuery();
}
}
catch
{
MessageBox.Show("添加失败");
}
finally
{
con.Close();
}
}
public void OnDeleteCBF(CBFModels model)
{
if (MessageBox.Show("您确定要删除数据？", "删除承包方", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
CBFDatabaseServices db = new CBFDatabaseServices();
db.DeleteCBF(model);
CBFModel.Remove(model);
}
}
/// <summary>
/// 新建承包方编辑窗口
/// </summary>
/// <param name="model"></param>
public void OnCreateEditCBFWindow(CBFModels model)
{
IDocument doc = DocumentManagerService.FindDocument(DocumentManagerService, model);
if (doc == null)
{
doc = DocumentManagerService.CreateDocument("EditCBFView", model);
doc.Id = DocumentManagerService.Documents.Count <IDocument>();
}
doc.Show();
}
private void OnSubmitExcuted()
{
FormatDate fd = new FormatDate();
if (CBFBM != null & CBFLX != null & CBFDB != null & CardType != null & CardID != null & Address != null & PostCode != null & Tel != null & FamilyCount != null & CBFDCRQ != null & CBFDCY != null & CBFDCJS != null & GSJS != null & GSJSR != null & GSSHRQ != null & GSSHR != null)
{
CBFModels _CBF = new CBFModels();
_CBF.ID = CBFBM;
_CBF.Name = CBFDB;
_CBF.CardNumber = CardID;
_CBF.Address = Address;
// _CBF.CertificateType = CBFLX;
_CBF.Claimsman = CBFDCY;
_CBF.MemberCount = FamilyCount;
_CBF.PublicEvent = GSJS;
_CBF.PublicEventPerson = GSJSR;
_CBF.SurveyDate = fd.GetFormatedDate(CBFDCRQ);
_CBF.SurveyEvent = CBFDCJS;
_CBF.PublicCheckPerson = GSSHR;
_CBF.Tel = Tel;
_CBF.PublicDate = fd.GetFormatedDate(GSSHRQ);
_CBF.PostCode = PostCode;
_CBF.Family = FamilyCollection;
CBFDatabaseServices db = new CBFDatabaseServices();
db.CreateCBF(_CBF);
CBFBM = null;
CBFDB = null;
CardID = null;
Address = null;
CBFDCY = null;
FamilyCount = null;
GSJS = null;
GSJSR = null;
CBFDCRQ = null;
CBFDCJS = null;
GSSHR = null;
Tel = null;
GSSHRQ = null;
PostCode = null;
FamilyCollection = null;
}
else
{
MessageBox.Show("表单数据未填写完整或格式不正确，请检查后再试");
}
}
public void DeleteCBF(CBFModels model)
{
OracleConnection con = new OracleConnection(connectString);
string sql = string.Format("delete from CBF where CBFBM='{0}'", model.ID);
string sql2 = string.Format("delete from CBF_JTCY where CBFBM='{0}'", model.ID);
OracleCommand cmd = new OracleCommand(sql, con);
OracleCommand cmd2 = new OracleCommand(sql2, con);
try
{
con.Open();
cmd.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
}
catch
{
MessageBox.Show("删除失败");
}
finally
{
con.Close();
}
}
public ObservableCollection <CBDKXXModels> GetDkByCBF(CBFModels cbf)
{
OracleConnection con = new OracleConnection(connectString);
string sql = string.Format("SELECT * FROM CBDKXX WHERE CBFBM='{0}'", cbf.ID);
OracleCommand cmd = new OracleCommand(sql, con);
try
{
con.Open();
OracleDataReader reader = cmd.ExecuteReader();
ObservableCollection <CBDKXXModels> DK = new ObservableCollection <CBDKXXModels>();
while (reader.Read())
{
CBDKXXModels model = new CBDKXXModels();
model.DKID = reader["DKBM"].ToString();
model.CBFID = reader["CBFBM"].ToString();
model.FBFID = reader["FBFBM"].ToString();
model.GetWay = "其他方式";
model.Area = reader["HTMJ"].ToString();
model.ContrctID = reader["CBHTBM"].ToString();
model.TransContractID = reader["LZHTBM"].ToString();
model.RightID = reader["CBJYQZBM"].ToString();
DK.Add(model);
}
return(DK);
}
catch
{
MessageBox.Show("系统查询出错");
return(null);
}
finally
{
con.Close();
}
}
public ObservableCollection <CBFModels> GetAllCBF()
{
OracleConnection con = new OracleConnection(connectString);
string sql = "SELECT * FROM CBF";
OracleCommand cmd = new OracleCommand(sql, con);
ObservableCollection <CBFModels> CBF = new ObservableCollection <CBFModels>();
try
{
con.Open();
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CBFModels model = new CBFModels();
model.ID = reader["CBFBM"].ToString();
model.Name = reader["CBFMC"].ToString();
#region 设置证件类型枚举值
switch (reader["CBFZJLX"].ToString())
{
case "1":
model.CertificateType = PropertyCodeEnumModels.CertificateType.IDCard;
break;
case "2":
model.CertificateType = PropertyCodeEnumModels.CertificateType.OfficerCard;
break;
case "3":
model.CertificateType = PropertyCodeEnumModels.CertificateType.AdminCode;
break;
case "4":
model.CertificateType = PropertyCodeEnumModels.CertificateType.ResidenceBooklet;
break;
case "5":
model.CertificateType = PropertyCodeEnumModels.CertificateType.Passport;
break;
default:
model.CertificateType = PropertyCodeEnumModels.CertificateType.OtherCard;
break;
}
#endregion
#region 设置承包方类型
switch (reader["CBFLX"].ToString())
{
case "1":
model.Type = PropertyCodeEnumModels.CBFType.PeasantHousehold;
break;
case "2":
model.Type = PropertyCodeEnumModels.CBFType.Personal;
break;
default:
model.Type = PropertyCodeEnumModels.CBFType.WorkUnit;
break;
}
#endregion
model.CardNumber = reader["CBFZJHM"].ToString();
model.Tel = reader["LXDH"].ToString();
model.Address = reader["CBFDZ"].ToString();
model.PostCode = reader["YZBM"].ToString();
model.Claimsman = reader["CBFDCY"].ToString();
model.PublicDate = reader["GSSHRQ"].ToString();
model.SurveyDate = reader["CBFDCRQ"].ToString();
model.SurveyEvent = reader["CBFDCJS"].ToString();
model.PublicCheckPerson = reader["GSSHR"].ToString();
model.PublicEvent = reader["GSJS"].ToString();
model.PublicEventPerson = reader["GSJSR"].ToString();
model.MemberCount = reader["CBFCYSL"].ToString();
CBF.Add(model);
}
return(CBF);
}
catch
{
MessageBox.Show("系统查询出错");
return(null);
}
finally
{
con.Close();
}
}
public ObservableCollection <CBF_JTCYModels> GetAllFamily(CBFModels model)
{
OracleConnection con = new OracleConnection(connectString);
string sql = string.Format("SELECT * FROM CBF_JTCY WHERE CBFBM='{0}'", model.ID);
OracleCommand cmd = new OracleCommand(sql, con);
ObservableCollection <CBF_JTCYModels> CBF = new ObservableCollection <CBF_JTCYModels>();
try
{
con.Open();
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CBF_JTCYModels CBF_JT = new CBF_JTCYModels();
CBF_JT.ID = reader["CBFBM"].ToString();
CBF_JT.Name = reader["CYXM"].ToString();
CBF_JT.Sex = reader["CYXB"].ToString();
#region 设置证件类型枚举值
switch (reader["CYZJLX"].ToString())
{
case "1":
CBF_JT.CertificateType = "身份证";
break;
case "2":
CBF_JT.CertificateType = "军官证";
break;
case "3":
CBF_JT.CertificateType = "行政企事业单位机构代码证或法人代码证";
break;
case "4":
CBF_JT.CertificateType = "户口簿";
break;
case "5":
CBF_JT.CertificateType = "护照";
break;
default:
CBF_JT.CertificateType = "其他";
break;
}
#endregion
CBF_JT.CardNumber = reader["CYZJHM"].ToString();
CBF_JT.RelationShip = reader["YHZGX"].ToString();
CBF_JT.Note = reader["CYBZ"].ToString();
CBF_JT.IsShared = reader["SFGYR"].ToString();
CBF.Add(CBF_JT);
}
return(CBF);
}
catch
{
MessageBox.Show("系统查询出错");
return(null);
}
finally
{
con.Close();
}
}
