/// <summary> /// 新增零售信息 /// </summary> /// <param name="obj"></param> public void AddResale(Resale obj) { string sql = "insert into zc_resale values (@id, @createTime, @updateTime, @number, @nums , @money, @branchId, @memberId)"; MySqlConnection conn = null; MySqlTransaction tran = null; MySqlCommand cmd = new MySqlCommand(); try { conn = GetConnection(); tran = conn.BeginTransaction(); cmd.Connection = conn; cmd.CommandText = sql; cmd.Parameters.AddWithValue("@id", obj.Id); cmd.Parameters.AddWithValue("@createTime", obj.CreateTime); cmd.Parameters.AddWithValue("@updateTime", obj.UpdateTime); cmd.Parameters.AddWithValue("@number", obj.WaterNumber); cmd.Parameters.AddWithValue("@nums", obj.Nums); cmd.Parameters.AddWithValue("@money", obj.Money); cmd.Parameters.AddWithValue("@branchId", obj.BranchId); cmd.Parameters.AddWithValue("@memberId", obj.memberId); cmd.ExecuteNonQuery(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); log.Error("保存零售信息到本地数据库失败", ex); } finally { CloseConnection(conn); } }
/// <summary> /// 上传零售信息 /// </summary> /// <param name="obj"></param> public void AddResale(Resale obj) { string sql = "insert into zc_resale (id, createTime, updateTime, waterNumber, nums, money, branch_id, member_id) " + " values (:id, :createTime, :updateTime, :number, :nums, :money, :branchId, :memberId)"; OracleConnection conn = null; OracleTransaction tran = null; OracleCommand cmd = new OracleCommand(); try { conn = OracleUtil.OpenConn(); tran = conn.BeginTransaction(); cmd.Connection = conn; cmd.CommandText = sql; cmd.Parameters.Add(":id", obj.Id); cmd.Parameters.Add(":createTime", obj.CreateTime); cmd.Parameters.Add(":updateTime", obj.UpdateTime); cmd.Parameters.Add(":number", obj.WaterNumber); cmd.Parameters.Add(":nums", obj.Nums); cmd.Parameters.Add(":money", obj.Money); cmd.Parameters.Add(":branchId", obj.BranchId); cmd.Parameters.Add(":memberId", obj.memberId); cmd.ExecuteNonQuery(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); UploadInfo uploadInfo = new UploadInfo(); uploadInfo.Id = obj.Id; uploadInfo.CreateTime = DateTime.Now; uploadInfo.UpdateTime = DateTime.Now; uploadInfo.Type = Constant.ZC_RESALE; UploadDao uploadDao = new UploadDao(); uploadDao.AddUploadInfo(uploadInfo); log.Error("上传零售信息发生异常", ex); } finally { OracleUtil.CloseConn(conn); } }
public void AddResale(Resale obj) { ResaleDao dao = new ResaleDao(); dao.AddResale(obj); }
public void AddResale(Resale obj) { BranchResaleDao dao = new BranchResaleDao(); dao.AddResale(obj); }