void resetState(DataSet1.RENTDataTable table)
{
string ongoingState;
string overdueState;
int ongoing = 0;
int overdue = 0;
int total = 0;
ongoingState = "0";
overdueState = "3";
foreach (DataSet1.RENTRow data in table.Rows)
{
if (data.RNTSTATE_NO == ongoingState)
{
ongoing++;
}
else if (data.RNTSTATE_NO == overdueState)
{
overdue++;
}
}
total = table.Rows.Count;
lb_ongoing.Text = ongoing.ToString();
lb_overdue.Text = overdue.ToString();
lb_total.Text = total.ToString();
}
private void ActionRent(object sender, EventArgs e)
{
if (tb_required.TextLength < 1)
{
return;
}
try
{
int gds_id = Convert.ToInt16(goodsRow.GDS_ID);
int c_id = Convert.ToInt16(customersRow.C_ID);
DateTime rnt_date = getDateServerTime();
DateTime rnt_returndate = dt_end.Value;
int rnt_qty = int.Parse(tb_required.Text);
string stf_id = Form1.account; string rntstate_no = "0";
rentTableAdapter1.Fill(dataSet11.RENT);
DataSet1.RENTDataTable rntTable = rentTableAdapter1.GetData();
DataSet1.RENTRow newRow = rntTable.NewRENTRow();
newRow.GDS_ID = gds_id;
newRow.C_ID = c_id;
newRow.RNT_DATE = rnt_date;
newRow.RNT_QTY = rnt_qty;
newRow.STF_ID = stf_id;
newRow.RNTSTATE_NO = rntstate_no;
newRow.RNT_RETURNDATE = rnt_returndate;
rntTable.Rows.Add(newRow);
int ret = rentTableAdapter1.Update(rntTable);
if (ret < 1)
{
MessageBox.Show("실패");
throw new Exception();
}
goodsRow.GDS_QTY = goodsRow.GDS_QTY - rnt_qty;
ret = goodsTableAdapter1.Update(goodsRow);
if (ret > 0)
{
MessageBox.Show("성공");
this.Close();
}
else
{
throw new Exception();
}
}
catch (Exception exc) {
MessageBox.Show(exc.Message, "실패");
}
}
private void ActionCustomerSelect(object sender, DataGridViewCellMouseEventArgs e)
{
DataRowView view = cUSTOMERSBindingSource.Current as DataRowView;
DataSet1.CUSTOMERSRow row = view.Row as DataSet1.CUSTOMERSRow;
tb_tel.Text = row.C_TEL;
tb_email.Text = row.C_EMAIL;
tb_addr.Text = row.C_ADDR;
tb_birth.Text = row.C_BIRTH; tb_name.Text = row.C_NAME;
lb_code.Text = row.C_ID.ToString();
rENTTableAdapter.Fill(dataSet1.RENT);
DataSet1.RENTDataTable table = rENTTableAdapter.GetDataByCid(row.C_ID);
rENTBindingSource.DataSource = table;
resetState(table);
tb_item.Enabled = tb_model.Enabled = btn_search.Enabled = drbtn_slvs.Enabled = drbtn_vendor.Enabled = true;
}
