public void AddShiftInfo(ShiftInfo shiftInfo)
{
string sql = "INSERT INTO `shiftInfo`(`userName`,`shiftTime`,`turnoverMoney`,`cashMoney`,`vesaMoney`,`preMoney`,`disMoney`,`runMoney`,`billCount`,`isDay`)VALUES (@userName,@shiftTime,@turnoverMoney,@cashMoney,@vesaMoney,@preMoney,@disMoney,@runMoney,@billCount,@isDay)";
DbUtil.ExecuteNonQuery(sql,
new MySqlParameter("@userName",shiftInfo.userName),
new MySqlParameter("@shiftTime",shiftInfo.shiftTime),
new MySqlParameter("@turnoverMoney", shiftInfo.turnoverMoney),
new MySqlParameter("@cashMoney", shiftInfo.cashMoney),
new MySqlParameter("@vesaMoney", shiftInfo.vesaMoney),
new MySqlParameter("@preMoney", shiftInfo.preMoney),
new MySqlParameter("@disMoney", shiftInfo.disMoney),
new MySqlParameter("@runMoney", shiftInfo.runMoney),
new MySqlParameter("@billCount", shiftInfo.billCount),
new MySqlParameter("@isDay",shiftInfo.isDay));
}
public ShiftInfo ToShiftInfo(DataRow row)
{
ShiftInfo shiftInfo = new ShiftInfo();
shiftInfo.billCount = (int)row["billCount"];
shiftInfo.cashMoney = (float)row["cashMoney"];
shiftInfo.disMoney = (float)row["disMoney"];
shiftInfo.id = (int)row["id"];
shiftInfo.preMoney = (float)row["preMoney"];
shiftInfo.runMoney = (float)row["runMoney"];
shiftInfo.shiftTime = (string)row["shiftTime"];
shiftInfo.turnoverMoney = (float)row["turnoverMoney"];
shiftInfo.userName = (string)row["userName"];
shiftInfo.vesaMoney = (float)row["vesaMoney"];
shiftInfo.isDay = (int)row["isDay"];
return shiftInfo;
}
private void lbShift_Click(object sender, EventArgs e)
{
ShiftInfo shift = new ShiftInfo();
shift.billCount = Convert.ToInt32(tbBillCount.Text);
shift.cashMoney = float.Parse(tbCashSum.Text);
shift.disMoney = float.Parse(tbDisSum.Text);
shift.preMoney = float.Parse(tbPreSum.Text);
shift.runMoney = float.Parse(tbRunSum.Text);
shift.shiftTime = tbTime.Text;
shift.turnoverMoney = float.Parse(tbTurnover.Text);
shift.userName = App.userName;
shift.vesaMoney = float.Parse(tbVesaSum.Text);
shift.isDay = 0;
ShiftInfoService service = new ShiftInfoService();
service.AddShiftInfo(shift);
MessageBox.Show("交班成功");
}