/// <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);
}
