/// <summary>
/// 交班
/// </summary>
private void exchangeWork()
{
BranchPayInfoService payService = new BranchPayInfoService();
DateTime first = DateTime.Today;
DateTime last = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 23:59:59"));
string sum = payService.FindAmountCashier(first, last, LoginUserInfo.id);
DeliverAmountInfo obj = new DeliverAmountInfo();
obj.Id = Guid.NewGuid().ToString().Replace("-", "");
obj.CreateTime = DateTime.Now;
obj.UpdateTime = DateTime.Now;
obj.AmountCashier = sum;
obj.BranchId = LoginUserInfo.branchId;
obj.Date = DateTime.Now;
obj.Salesman = LoginUserInfo.id;
///保存交班信息到本地数据库
BranchDeliverAmountInfoService branchService = new BranchDeliverAmountInfoService();
branchService.AddDeliverAmountInfo(obj);
///上传交班信息到远处服务器
DeliverAmountInfoService service = new DeliverAmountInfoService();
service.AddDeliverAmountInfo(obj);
}
/// <summary>
/// 上传交班信息
/// </summary>
/// <param name="obj"></param>
public void AddDeliverAmountInfo(DeliverAmountInfo obj)
{
string sql = "insert into zc_deliver_amountinfo (id, createTime, updateTime, amountcashier, branch_id, exchangedate, salesman) values (:id, :createTime, :updateTime, :amount, :branchId, :exdate, :salesman)";
OracleConnection conn = null;
OracleTransaction tran = null;
OracleCommand cmd = new OracleCommand();
try
{
conn = OracleUtil.OpenConn();
tran = conn.BeginTransaction();
cmd.CommandText = sql;
cmd.Connection = conn;
cmd.Parameters.Add(":id", obj.Id);
cmd.Parameters.Add(":createTime", obj.CreateTime);
cmd.Parameters.Add(":updateTime", obj.UpdateTime);
cmd.Parameters.Add(":amount", obj.AmountCashier);
cmd.Parameters.Add(":branchId", obj.BranchId);
cmd.Parameters.Add(":exdate", obj.Date);
cmd.Parameters.Add(":salesman", obj.Salesman);
cmd.ExecuteNonQuery();
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
log.Error("上传交班信息到服务器失败", ex);
}
finally
{
tran.Dispose();
cmd.Dispose();
OracleUtil.CloseConn(conn);
}
}
public void AddDeliverAmountInfoDao(DeliverAmountInfo obj)
{
string sql = "insert into deliver_amount_info values (@id,@createTime, @updateTime, @salesman, @amount, @date,@branchId)";
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("@salesman", obj.Salesman);
cmd.Parameters.AddWithValue("@amount", obj.AmountCashier);
cmd.Parameters.AddWithValue("@date", obj.Date);
cmd.Parameters.AddWithValue("@branchId", obj.BranchId);
cmd.ExecuteNonQuery();
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
log.Error("添加交班信息失败", ex);
}
finally
{
cmd.Dispose();
tran.Dispose();
CloseConnection(conn);
}
}
public void AddDeliverAmountInfo(DeliverAmountInfo obj)
{
DeliverAmountInfoDao dao = new DeliverAmountInfoDao();
dao.AddDeliverAmountInfo(obj);
}
