/// <summary>
///插入pos_rounds表
/// </summary>
/// <param name="pos_rounds">Pos_rounds的映射表的类的对象，用于调用其字段赋值</param>
/// <returns>正确插入返回true 否则 false</returns>
public bool Insert(Pos_rounds pos_rounds)
{
//本地插入交班信息
bool b = false;
SqlParameter[] para = new SqlParameter[8];
para[0] = new SqlParameter("@shop_id", SqlDbType.NVarChar);
para[1] = new SqlParameter("@pos_id", SqlDbType.NVarChar);
para[2] = new SqlParameter("@login_date", SqlDbType.DateTime);
para[3] = new SqlParameter("@cashier_sum", SqlDbType.Decimal);
para[4] = new SqlParameter("@user_id", SqlDbType.NVarChar);
para[5] = new SqlParameter("@transfer_status", SqlDbType.NChar);
para[6] = new SqlParameter("@shift_num", SqlDbType.NVarChar);
para[7] = new SqlParameter("@last_update", SqlDbType.DateTime);
para[0].Value = pos_rounds.Shop_id;
para[1].Value = pos_rounds.Pos_id;
para[2].Value = pos_rounds.Login_date;
para[3].Value = pos_rounds.Cashier_sum;
para[4].Value = pos_rounds.User_id;
para[5].Value = pos_rounds.Transfer_status;
para[6].Value = pos_rounds.Shift_num;
para[7].Value = pos_rounds.Last_update;
b = base.RunSQL("Insert into pos_rounds(shop_id,pos_id,login_date,cashier_sum,user_id,transfer_status,shift_num,last_update) values(@shop_id,@pos_id,@login_date,@cashier_sum,@user_id,@transfer_status,@shift_num,@last_update)", para);
return(b);
}
/// <summary>
/// 更新Pos_rounds表中的退出时间和抽大钞信息
/// </summary>
/// <param name="exit_date">退出时间</param>
/// <returns>调用 DataInsertPos_rounds中InitDataOperation()获得一个对象并调用update方法</returns>
public bool Update_Posrounds(DateTime exit_date)
{
Pos_rounds pos_rounds = new Pos_rounds();
pos_rounds.Exit_date = exit_date;
//pos_rounds.Money_out_id = largeBillsNum;
return(DataInsertPos_rounds.InitDataOperation().update(pos_rounds));
}
/// <summary>
/// 更新pos_rounds表
/// </summary>
/// <param name="pos_rounds">Pos_rounds的对象pos_rounds</param>
/// <returns>正确更新返回true 否则 false</returns>
public bool update(Pos_rounds pos_rounds)
{
bool b = false;
SqlParameter[] para = new SqlParameter[3];
para[0] = new SqlParameter("@exit_date", SqlDbType.DateTime);
para[1] = new SqlParameter("@pos_id", SqlDbType.NVarChar);
para[2] = new SqlParameter("@SHIFT_NUM", SqlDbType.NVarChar);
para[0].Value = pos_rounds.Exit_date;
para[1].Value = Info.pos_id;
para[2].Value = Info.shift_num;
b = base.RunSQL("update pos_rounds set exit_date=@exit_date where exit_date is null and pos_id=@pos_id and SHIFT_NUM=@SHIFT_NUM", para);
return(b);
}
/// <summary>
/// 将信息插入Pos_rounds表中
/// </summary>
/// <param name="shop_id">1.分店编号</param>
/// <param name="pos_id">2.POS机编号</param>
/// <param name="login_date">3.上线时间</param>
/// <param name="cashier_sum">4. 零用金</param>
/// <param name="user_id">5.操作员编号</param>
/// <param name="transfer_status">6.传输状态</param>
/// <param name="shift_num">7.班次</param>
/// <param name="last_update">8.最后更新</param>
/// <returns>调用 DataInsertPos_rounds中InitDataOperation()获得一个对象并调用Insert方法</returns>
public bool InsertPosrounds(string shop_id, string pos_id, DateTime login_date, decimal cashier_sum, string user_id, string transfer_status, String shift_num, DateTime last_update)
{
Pos_rounds pos_rounds = new Pos_rounds();
pos_rounds.Shop_id = shop_id;
pos_rounds.Pos_id = pos_id;
pos_rounds.Login_date = login_date;
pos_rounds.Cashier_sum = cashier_sum;
pos_rounds.User_id = user_id;
pos_rounds.Transfer_status = transfer_status;
pos_rounds.Shift_num = shift_num;
pos_rounds.Last_update = last_update;
return(DataInsertPos_rounds.InitDataOperation().Insert(pos_rounds));
}