/// <summary> /// 根据主键查询 /// </summary> /// <param name="primaryKey"></param> /// <returns></returns> public ImportLog Get(ImportLog entity) { string sql = "SELECT type,import_month FROM import_log where import_month=@import_month and type=@type"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); command.Parameters.AddWithValue("@type", entity.type); command.Parameters.AddWithValue("@import_month", entity.import_month); MySqlDataReader reader = command.ExecuteReader(); ImportLog importLog = null; if (reader.Read()) { importLog = new ImportLog(); importLog.type = reader["type"] == DBNull.Value ? null : reader["type"].ToString(); importLog.import_month = reader["import_month"] == DBNull.Value ? null : reader["import_month"].ToString(); } mycn.Close(); return importLog; } }
/// <summary> /// 删除数据 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Delete(ImportLog entity) { string sql = "DELETE FROM import_log WHERE import_month=@import_month and type=@type"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); command.Parameters.AddWithValue("@type", entity.type); command.Parameters.AddWithValue("@import_month", entity.import_month); int i = command.ExecuteNonQuery(); mycn.Close(); mycn.Dispose(); return i; } }
public const string mysqlConnection = DBConstant.mysqlConnection;//"User Id=root;Host=115.29.229.134;Database=chinaunion;password=c513324665;charset=utf8"; /// <summary> /// 添加数据 /// </summary> /// <returns></returns> public int Add(ImportLog entity) { string sql = "INSERT INTO import_log (type,import_month) VALUE (@type,@import_month)"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); command.Parameters.AddWithValue("@type", entity.type); command.Parameters.AddWithValue("@import_month", entity.import_month); int i = command.ExecuteNonQuery(); mycn.Close(); mycn.Dispose(); return i; } }
private void btnImport_Click(object sender, EventArgs e) { ImportLog importLog = new ChinaUnion_BO.ImportLog(); importLog.type = "Agent"; importLog.import_month = this.dtFeeMonth.Value.ToString("yyyy-MM"); ImportLogDao importLogDao = new ChinaUnion_DataAccess.ImportLogDao(); if (importLogDao.Get(importLog) != null) { if (MessageBox.Show("本月佣金已经导入,是否需要再次导入?", "数据导入", MessageBoxButtons.OKCancel) == DialogResult.Cancel) { return; } } //异步执行开始 worker.RunWorkerAsync(); frmProgress frm = new frmProgress(this.worker); frm.StartPosition = FormStartPosition.CenterScreen; frm.ShowDialog(this); frm.Close(); this.btnImport.Enabled = false; }
/// <summary> /// 异步 开始事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void worker_DoWork(object sender, DoWorkEventArgs e) { //需要执行的代码 worker.ReportProgress(5, "开始导入代理商类型...\r\n"); //导入代理商类型 AgentTypeDao agentTypeDao = new AgentTypeDao(); for (int i = 0; i < dgAgentType.RowCount; i++) { AgentType agentType = new AgentType(); agentType.agentNo = dgAgentType[0, i].Value.ToString(); agentType.agentType = dgAgentType[1, i].Value.ToString(); agentType.agentFeeMonth = this.dtFeeMonth.Value.ToString("yyyy-MM"); agentTypeDao.Delete(agentType); agentTypeDao.Add(agentType); } worker.ReportProgress(6, "导入代理商类型完成...\r\n"); worker.ReportProgress(7, "开始导入代理商类型说明...\r\n"); //导入代理商类型说明 AgentTypeCommentDao agentTypeCommentDao = new AgentTypeCommentDao(); for (int i = 0; i < dgAgentTypeComment.RowCount; i++) { AgentTypeComment agentTypeComment = new AgentTypeComment(); agentTypeComment.agentType = dgAgentTypeComment[0, i].Value.ToString(); agentTypeComment.agentTypeComment = dgAgentTypeComment[1, i].Value.ToString(); agentTypeComment.agentFeeMonth = this.dtFeeMonth.Value.ToString("yyyy-MM"); agentTypeCommentDao.Delete(agentTypeComment); agentTypeCommentDao.Add(agentTypeComment); } ImportLog importLog = new ChinaUnion_BO.ImportLog(); importLog.type="Agent"; importLog.import_month = this.dtFeeMonth.Value.ToString("yyyy-MM"); ImportLogDao importLogDao = new ChinaUnion_DataAccess.ImportLogDao(); importLogDao.Delete(importLog); importLogDao.Add(importLog); worker.ReportProgress(8, "导入代理商类型完成...\r\n"); //MessageBox.Show("数据上传完毕"); }
/// <summary> /// 查询集合 /// </summary> /// <returns></returns> public IList<ImportLog> GetList(ImportLog entity) { string sql = "SELECT type,import_month FROM import_log where import_month=@import_month and type=@type"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); MySqlDataReader reader = command.ExecuteReader(); IList<ImportLog> list = new List<ImportLog>(); ImportLog importLog = null; while (reader.Read()) { importLog = new ImportLog(); importLog.type = reader["type"] == DBNull.Value ? null : reader["type"].ToString(); importLog.import_month = reader["import_month"] == DBNull.Value ? null : reader["import_month"].ToString(); list.Add(importLog); } mycn.Close(); return list; } }