/// <summary> /// 获取所有保险记录列表 /// </summary> /// <returns>保险记录集合</returns> public IList<Insure> GetAllInsure() { IList<Insure> list = new List<Insure>(); string sql = "select * from TB_Insure order by Date desc"; DataSet ds = AccessHelper.ExecuteDataSet(_connectionString, sql); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { Insure insure = new Insure(); insure.Id = (int)row["ID"]; insure.EId = (int)row["EId"]; insure.Date = (DateTime)row["Date"]; insure.Type = (string)row["Type"]; insure.BaseNumber = (double)row["BaseNumber"]; insure.Company = (double)row["Company"]; insure.Person = (double)row["Person"]; list.Add(insure); } } return list; }
/// <summary> /// 绑定社保记录信息 /// </summary> private void BindInsureInfo() { record = iBll.GetInsure(_id); lblEmployeeName.Text = eBll.GetEmployee(record.EId).EName; dtpDate.Text = record.Date.ToString("yyyy年MM月dd日"); for (int i = 0; i < cbType.Items.Count; i++) { if (cbType.Items[i].ToString() == record.Type) { cbType.SelectedIndex = i; break; } } numBaseNumber.Value = (decimal)record.BaseNumber; numCompany.Value = (decimal)record.BaseNumber; numCompany.Value = (decimal)record.BaseNumber; }
private void btnOk_Click(object sender, EventArgs e) { string baseNumber = numBaseNumber.Text.Trim(); string company = numCompany.Text.Trim(); string person = numPerson.Text.Trim(); if (baseNumber.Length == 0) { MessageBox.Show("缴纳基数不能为空"); return; } if (company.Length == 0) { MessageBox.Show("个人缴纳不能为空"); return; } if (person.Length == 0) { MessageBox.Show("单位缴纳不能为空"); return; } Insure record = new Insure(); record.EId = _eId; record.Date = Convert.ToDateTime(dtpDate.Text); record.Type = cbType.SelectedItem.ToString(); record.BaseNumber = Convert.ToDouble(baseNumber); record.Company = Convert.ToDouble(company); record.Person = Convert.ToDouble(person); iBll.Insert(record); MessageBox.Show("添加成功!"); this.DialogResult = DialogResult.OK; this.Close(); }
/// <summary> /// 修改保险记录 /// </summary> /// <param name="insure">保险记录对象</param> /// <returns>影响行数</returns> public int Update(Insure insure) { return _dal.Update(insure); }
/// <summary> /// 添加保险记录 /// </summary> /// <param name="insure">保险记录对象</param> /// <returns>ID</returns> public int Insert(Insure insure) { return _dal.Insert(insure); }
/// <summary> /// 获取保险记录对象 /// </summary> /// <param name="eId">Id</param> /// <returns>保险记录对象</returns> public Insure GetInsure(int id) { Insure insure = null; string sql = "select * from TB_Insure where ID=" + id; DataSet ds = AccessHelper.ExecuteDataSet(_connectionString, sql); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; insure = new Insure(); insure.Id = (int)row["ID"]; insure.EId = (int)row["EId"]; insure.Date = (DateTime)row["Date"]; insure.Type = (string)row["Type"]; insure.BaseNumber = (double)row["BaseNumber"]; insure.Company = (double)row["Company"]; insure.Person = (double)row["Person"]; } return insure; }
/// <summary> /// 修改保险记录 /// </summary> /// <param name="insure">保险记录对象</param> /// <returns>影响行数</returns> public int Update(Insure insure) { string sql = "update TB_Insure set EId=@EId,[Date]=@Date,Type=@Type,BaseNumber=@BaseNumber,Company=@Company,Person=@Person where ID=@ID"; OleDbParameter[] param = new OleDbParameter[] { new OleDbParameter("@EId",insure.EId), new OleDbParameter("@Date",insure.Date), new OleDbParameter("@Type",insure.Type), new OleDbParameter("@BaseNumber",insure.BaseNumber), new OleDbParameter("@Company",insure.Company), new OleDbParameter("@Person",insure.Person), new OleDbParameter("@ID",insure.Id) }; int count = AccessHelper.ExecuteNonQuery(_connectionString, sql, param); return count; }
/// <summary> /// 添加保险记录 /// </summary> /// <param name="insure">保险记录对象</param> /// <returns>ID</returns> public int Insert(Insure insure) { string sql = "insert into TB_Insure(EId,[Date],Type,BaseNumber,Company,Person) "; sql += "values(@EId,@Date,@Type,@BaseNumber,@Company,@Person)"; OleDbParameter[] param = new OleDbParameter[] { new OleDbParameter("@EId",insure.EId), new OleDbParameter("@Date",insure.Date), new OleDbParameter("@Type",insure.Type), new OleDbParameter("@BaseNumber",insure.BaseNumber), new OleDbParameter("@Company",insure.Company), new OleDbParameter("@Person",insure.Person) }; AccessHelper.ExecuteNonQuery(_connectionString, sql, param); object id = AccessHelper.ExecuteScalar(_connectionString, "select @@identity"); return Convert.ToInt32(id); }