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