private void 退休数据表ToolStripMenuItem_Click(object sender, EventArgs e) { MessageBoxButtons messButton = MessageBoxButtons.OKCancel; DialogResult dr = MessageBox.Show("确定要清除已缴(退休)数据表中的所有数据吗?", "确认提示", messButton); if (dr == DialogResult.OK) { SqlLiteCommon sqliteCommon = new SqlLiteCommon(); bool result = sqliteCommon.Clear("YIJDFTX_2"); if (result) { MessageBox.Show("清理已缴(退休)数据表完成!"); } } }
private void button2_Click(object sender, EventArgs e) { if (textBox1.Text.ToString() != string.Empty) { DataTable dtResult = new DataTable(); dtResult.Columns.Add("姓名"); dtResult.Columns.Add("日期"); dtResult.Columns.Add("应缴党费"); dtResult.Columns.Add("已缴党费"); dtResult.Columns.Add("欠缴党费"); SqlLiteCommon sqliteCommon = new SqlLiteCommon(); dtResult = sqliteCommon.Select("ZZ"); SaveDataTable2Excel(dtResult, textBox1.Text); } }
private void Save2DBYIJDF_ZZ(DataSet dataSet) { SqlLiteCommon sqlLite = new SqlLiteCommon(); foreach (DataTable dt in dataSet.Tables) { #region 注释代码——修改表头为英文 //foreach (DataRow dr in dt.Rows) //{ // if (!dt.Columns.Contains("姓名"))//当表头中不包含姓名时,重新绑定表头并删除第一行数据 // { // for (int i = 0; i < dt.Columns.Count; i++) // { // dt.Columns[i].ColumnName = dr[i].ToString().Replace(" ", "").Replace(Convert.ToChar(10).ToString(), ""); // } // dr.Delete(); // } // else // { // //把对应的中文表头改为英文 // for (int i=0;i< dt.Columns.Count;i++) // { // DataColumn col = dt.Columns[i]; // string colName_CN = col.Caption; // Columns_YIJDF_ZZ_Excel colExcel = new Columns_YIJDF_ZZ_Excel(); // Dictionary<string, string> dict = colExcel.dir; // if(dict.ContainsKey(colName_CN)) // { // string colName_EN = colExcel.dir[colName_CN]; // col.ColumnName = colName_EN; // } // else // { // dt.Columns.Remove(col); // i--; // } // } // break; // } //} #endregion } }
private void Save2DBYINGJDF(DataSet dataSet) { SqlLiteCommon sqlLite = new SqlLiteCommon(); foreach (DataTable dt in dataSet.Tables) { ArrayList objArr = new ArrayList(); foreach (DataRow dr in dt.Rows) { Obj_YINGJDF objYingjdf = new Obj_YINGJDF(); if (dt.Columns.Contains("姓名") && dr["姓名"].ToString().Trim() != string.Empty && dr["日期"].ToString() != string.Empty) { try { objYingjdf.Name = dr["姓名"].ToString().Trim(); objYingjdf.Date = Convert.ToDateTime(dr["日期"].ToString()); objYingjdf.DFJS = Convert.ToDouble(dr["党费基数"].ToString() == string.Empty ? "0" : dr["党费基数"].ToString()); objYingjdf.DFJSQZ = Convert.ToDouble(dr["党费基数(取整)"].ToString() == string.Empty ? "0" : dr["党费基数(取整)"].ToString()); objYingjdf.YINGJDF = Convert.ToDouble(dr["应缴党费"].ToString() == string.Empty ? "0" : dr["应缴党费"].ToString()); objYingjdf.YINGJDFQZ = Convert.ToDouble(dr["应交党费(取整)"].ToString() == string.Empty ? "0" : dr["应交党费(取整)"].ToString()); objArr.Add(objYingjdf); } catch (Exception ex) { MessageBox.Show("文件 " + dataSet.DataSetName + " 的表 " + dt.TableName + "中的记录 '" + objYingjdf.Name + "' 存在问题!\n" + ex.Message); } } } sqlLite.Add(objArr); } }
private void Save2DBYIJDF_ZZ_2(DataSet dataSet) { SqlLiteCommon sqlLite = new SqlLiteCommon(); foreach (DataTable dt in dataSet.Tables) { if (!dt.TableName.Contains("退休") && !dt.TableName.Contains("补缴党费")) { ArrayList objArr = new ArrayList(); foreach (DataRow dr in dt.Rows) { Obj_YIJDF_ZZ_2 obj = new Obj_YIJDF_ZZ_2(); if (!dt.Columns.Contains("姓名"))//当表头中不包含姓名时,重新绑定表头并删除第一行数据 { for (int i = 0; i < dt.Columns.Count; i++) { if (dr[i].ToString() != null && dr[i].ToString() != string.Empty) dt.Columns[i].ColumnName = dr[i].ToString().Replace(" ", "").Replace(Convert.ToChar(10).ToString(), ""); } dr.Delete(); } else { if (dr["姓名"].ToString().Trim() != string.Empty) { try { string dateSpan = dr["缴费起止月份"].ToString(); string[] dateSpanArr = DateTrans(dateSpan); if (dateSpanArr != null) { foreach (string date in dateSpanArr) { obj = new Obj_YIJDF_ZZ_2(); obj.JFQZYF = dateSpan; obj.Name = dr["姓名"].ToString().Trim(); obj.GWGZ = Convert.ToDouble(dr["岗位工资"].ToString() == string.Empty ? "0" : dr["岗位工资"].ToString()); obj.XJGZ = Convert.ToDouble(dr["薪级"].ToString() == string.Empty ? "0" : dr["薪级"].ToString()); obj.ZWBT = Convert.ToDouble(dr["职务补贴"].ToString() == string.Empty ? "0" : dr["职务补贴"].ToString()); obj.JXGZ = Convert.ToDouble(dr["绩效工资"].ToString() == string.Empty ? "0" : dr["绩效工资"].ToString()); obj.TENPERCENT = Convert.ToDouble(dr["0.1"].ToString() == string.Empty ? "0" : dr["0.1"].ToString()); obj.XJ = Convert.ToDouble(dr["小计"].ToString() == string.Empty ? "0" : dr["小计"].ToString()); obj.YKSJ = Convert.ToDouble(dr["应扣税金"].ToString() == string.Empty ? "0" : dr["应扣税金"].ToString()); obj.DFJS = Convert.ToDouble(dr["党费基数"].ToString() == string.Empty ? "0" : dr["党费基数"].ToString()); obj.JSJE = Convert.ToDouble(dr["计税金额"].ToString() == string.Empty ? "0" : dr["计税金额"].ToString()); obj.YJDF = Convert.ToDouble(dr["月缴党费"].ToString() == string.Empty ? "0" : dr["月缴党费"].ToString()); obj.YJDFQZ = Convert.ToDouble(dr["保留整数"].ToString() == string.Empty ? "0" : dr["保留整数"].ToString()); obj.DATE = Convert.ToDateTime(date); objArr.Add(obj); } } else { MessageBox.Show("文件 " + dataSet.DataSetName + " 的表 " + dt.TableName + "中的记录 '" + obj.Name + "' '缴费起止月份' 有误! 未成功录入"); } } catch (Exception ex) { MessageBox.Show("文件 " + dataSet.DataSetName + " 的表 " + dt.TableName + "中的记录 '" + obj.Name + "' 存在问题!\n" + ex.Message); } } } } sqlLite.Add(objArr); } } }