public InsuranceFund GetInsuranceFundByID(int InsuranceFundID)
{
using (var connection = new OleDbConnection(ConfigManagement.AccessConStr)) {
string sqlText = string.Format(@"select
InsuranceFundID,
PeopleID,
InsuranceFundType,
Number,
PaymentAddress,
PaymentStartDate,
PaymentEndDate,
BasicNum
from {0} where InsuranceFundID=@InsuranceFundID", _InsuranceFundTableName);
var paras = new OleDbParameter[1];
paras[0] = new OleDbParameter("InsuranceFundID", InsuranceFundID);
var reader = new OLESqlHelper().GetReader(sqlText, connection, paras);
if (reader.Read()) {
int i = 0;
var InsuranceFund = new InsuranceFund();
InsuranceFund.InsuranceFundID = reader.GetInt32(i++);
InsuranceFund.PeopleID = reader.GetInt32(i++);
InsuranceFund.InsuranceFundType = (int)reader.GetInt32(i++);
InsuranceFund.Number = reader.GetString(i++);
InsuranceFund.PaymentAddress = reader.GetString(i++);
InsuranceFund.PaymentStartDate = reader.IsDBNull(i) ? new Nullable<DateTime>() : reader.GetDateTime(i++);
InsuranceFund.PaymentEndDate = reader.IsDBNull(i) ? new Nullable<DateTime>() : reader.GetDateTime(i++);
InsuranceFund.BasicNum = reader.GetFloat(i++);
return InsuranceFund;
} else {
return null;
}
}
}
public CResult<bool> UpdateInsuranceFund(InsuranceFund InsuranceFund)
{
if (InsuranceFund.InsuranceFundID <= 0) {
return new CResult<bool>(false, ErrorCode.ParameterError);
}
var result = new InsuranceFundDAL().UpdateInsuranceFund(InsuranceFund);
if (result) {
return new CResult<bool>(true);
} else {
return new CResult<bool>(false, ErrorCode.SaveDataFailed);
}
}
public CResult<bool> InsertInsuranceFund(InsuranceFund InsuranceFund)
{
if (InsuranceFund.PeopleID <= 0) {
return new CResult<bool>(false, ErrorCode.ParameterError);
}
var result = new InsuranceFundDAL().InsertInsuranceFund(InsuranceFund);
if (result) {
return new CResult<bool>(true);
} else {
return new CResult<bool>(false, ErrorCode.DataNotExist);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
var bll = new InsuranceFundBLL();
var fund = new InsuranceFund();
fund.InsuranceFundType = (int)InsuranceFundType.住房公积金;
fund.Number = this.txtHouseNumber.Text;
fund.PaymentAddress = this.txtHousePaymentAddress.Text;
fund.PaymentStartDate = this.dtphousePaymentStartDate.Value;
if (this.dtpHousePaymentEndDate.Checked) {
fund.PaymentEndDate = this.dtpHousePaymentEndDate.Value;
}
if (!string.IsNullOrWhiteSpace(this.txtHouseBasicNum.Text)) {
fund.BasicNum = float.Parse(this.txtHouseBasicNum.Text);
}
var insurance = new InsuranceFund();
insurance.InsuranceFundType = (int)InsuranceFundType.社保;
insurance.Number = this.txtSocialNumber.Text;
insurance.PaymentAddress = this.txtSocialPaymentAddress.Text;
insurance.PaymentStartDate = this.dtpSocialPaymentStartDate.Value;
if (this.dtpSocialPaymentEndDate.Checked) {
insurance.PaymentEndDate = this.dtpSocialPaymentEndDate.Value;
}
if (!string.IsNullOrWhiteSpace(this.txtSocialBasicNum.Text)) {
insurance.BasicNum = float.Parse(this.txtSocialBasicNum.Text);
}
var result = true;
if (isEdit) {
fund.InsuranceFundID = this._fundID.Value;
result = result && bll.UpdateInsuranceFund(fund).Data;
insurance.InsuranceFundID = this._insuranceID.Value;
result = result && bll.UpdateInsuranceFund(insurance).Data;
} else {
fund.PeopleID = this._currentPeopleID;
result = result && bll.InsertInsuranceFund(fund).Data;
insurance.PeopleID = this._currentPeopleID;
result = result && bll.InsertInsuranceFund(insurance).Data;
}
if (result) {
MessageBox.Show("操作成功!");
} else {
MessageBox.Show("操作失败!");
}
}
public List<InsuranceFund> GetInsuranceFundList(int peopleID)
{
string sqlText = string.Format(@"select
InsuranceFundID,
InsuranceFundType,
Number,
PaymentAddress,
PaymentStartDate,
PaymentEndDate,
BasicNum
from {0}
where PeopleID=@PeopleID"
, _InsuranceFundTableName);
var paras = new OleDbParameter[1];
paras[0] = new OleDbParameter("PeopleID", peopleID);
var table = new OLESqlHelper().GetTable(sqlText, paras);
var InsuranceFundList = new List<InsuranceFund>();
foreach (DataRow row in table.Rows) {
var peopleFamily = new InsuranceFund() {
InsuranceFundID = (int)row["InsuranceFundID"],
InsuranceFundType = (int)row["InsuranceFundType"],
Number = row["Number"].ToString(),
PaymentAddress = row["PaymentAddress"].ToString(),
PaymentStartDate = (DateTime?)row["PaymentStartDate"],
PaymentEndDate = row.IsNull("PaymentEndDate") ? null : (DateTime?)row["PaymentEndDate"],
BasicNum = (float)row["BasicNum"]
};
InsuranceFundList.Add(peopleFamily);
}
return InsuranceFundList;
}
public bool UpdateInsuranceFund(InsuranceFund InsuranceFund)
{
string sqlText = string.Format(@"update {0} set
InsuranceFundType=@InsuranceFundType,
[Number]=@Number,
PaymentAddress=@PaymentAddress,
PaymentStartDate=@PaymentStartDate,
PaymentEndDate=@PaymentEndDate,
BasicNum=@BasicNum
where InsuranceFundID=@InsuranceFundID", _InsuranceFundTableName);
var paras = new OleDbParameter[7];
paras[0] = new OleDbParameter("InsuranceFundType", InsuranceFund.InsuranceFundType);
paras[1] = new OleDbParameter("Number", InsuranceFund.Number);
paras[2] = new OleDbParameter("PaymentAddress", InsuranceFund.PaymentAddress);
paras[3] = new OleDbParameter("PaymentStartDate", InsuranceFund.PaymentStartDate);
paras[4] = new OleDbParameter("PaymentEndDate", InsuranceFund.PaymentEndDate);
paras[5] = new OleDbParameter("BasicNum", InsuranceFund.BasicNum);
paras[6] = new OleDbParameter("InsuranceFundID", InsuranceFund.InsuranceFundID);
var result = new OLESqlHelper().ExecuteNoneQuery(sqlText, paras);
return result;
}
public bool InsertInsuranceFund(InsuranceFund InsuranceFund)
{
string sqlText = string.Format(@"insert into {0}(
PeopleID,
InsuranceFundType,
[Number],
PaymentAddress,
PaymentStartDate,
PaymentEndDate,
BasicNum
)
values(
@PeopleID,
@InsuranceFundType,
@Number,
@PaymentAddress,
@PaymentStartDate,
@PaymentEndDate,
@BasicNum)", _InsuranceFundTableName);
var paras = new OleDbParameter[7];
paras[0] = new OleDbParameter("PeopleID", InsuranceFund.PeopleID);
paras[1] = new OleDbParameter("InsuranceFundType", InsuranceFund.InsuranceFundType);
paras[2] = new OleDbParameter("Number", InsuranceFund.Number);
paras[3] = new OleDbParameter("PaymentAddress", InsuranceFund.PaymentAddress);
paras[4] = new OleDbParameter("PaymentStartDate", InsuranceFund.PaymentStartDate);
paras[4].OleDbType = OleDbType.DBDate;
paras[5] = new OleDbParameter("PaymentEndDate", InsuranceFund.PaymentEndDate);
paras[5].OleDbType = OleDbType.DBDate;
paras[6] = new OleDbParameter("BasicNum", InsuranceFund.BasicNum);
var result = new OLESqlHelper().ExecuteNoneQuery(sqlText, paras);
return result;
}