/// <summary>
/// 添加
/// </summary>
/// <param name="pDataObject"></param>
/// <param name="sqLiteTransaction"></param>
public void Add(Obj_YINGJDF pDataObject, SQLiteTransaction sqLiteTransaction)
{
const string mySqlString =
"insert into YINGJDF (DATE,NAME,DFJS,DFJSQZ,YINGJDF,YINGJDFQZ) values ($DATE,$NAME,$DFJS,$DFJSQZ,$YINGJDF,$YINGJDFQZ)";
using (SQLiteCommand myCommand = sqLiteTransaction.Connection.CreateCommand())
{
myCommand.CommandText = mySqlString;
myCommand.Parameters.Add(new SQLiteParameter("DATE", pDataObject.Date));
myCommand.Parameters.Add(new SQLiteParameter("NAME", pDataObject.Name));
myCommand.Parameters.Add(new SQLiteParameter("DFJS", pDataObject.DFJS));
myCommand.Parameters.Add(new SQLiteParameter("DFJSQZ", pDataObject.DFJSQZ));
myCommand.Parameters.Add(new SQLiteParameter("YINGJDF", pDataObject.YINGJDF));
myCommand.Parameters.Add(new SQLiteParameter("YINGJDFQZ", pDataObject.YINGJDFQZ));
myCommand.ExecuteNonQuery();
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pDataObject"></param>
/// <param name="sqLiteTransaction"></param>
public void Update(Obj_YINGJDF pDataObject, SQLiteTransaction sqLiteTransaction)
{
const string mySqlString =
"update YINGJDF set DFJS=$DFJS,DFJSQZ=$DFJSQZ,YINGJDF=$YINGJDF,YINGJDFQZ=$YINGJDFQZ where NAME=$NAME and DATE=$DATE";
using (SQLiteCommand myCommand = sqLiteTransaction.Connection.CreateCommand())
{
myCommand.CommandText = mySqlString;
myCommand.Parameters.Add(new SQLiteParameter("DATE", pDataObject.Date));
myCommand.Parameters.Add(new SQLiteParameter("NAME", pDataObject.Name));
myCommand.Parameters.Add(new SQLiteParameter("DFJS", pDataObject.DFJS));
myCommand.Parameters.Add(new SQLiteParameter("DFJSQZ", pDataObject.DFJSQZ));
myCommand.Parameters.Add(new SQLiteParameter("YINGJDF", pDataObject.YINGJDF));
myCommand.Parameters.Add(new SQLiteParameter("YINGJDFQZ", pDataObject.YINGJDFQZ));
myCommand.ExecuteNonQuery();
}
}
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);
}
}
