private void DiseaseHistoryForm_Load(object sender, EventArgs e)
{
this.usersViewTableAdapter.Fill(farmManageDataSet.UsersView);
this.stockTableAdapter.Fill(farmManageDataSet.Stock);
this.diseaseMedicineTableAdapter.Fill(farmManageDataSet.DiseaseMedicine);
this.diseaseHistoryTableAdapter.FillByPK(farmManageDataSet.DiseaseHistory, DiseaseHistoryID);
if (DiseaseHistoryID == 0)
{
this.tcSecond.TabPages.Remove(tabHistory);
this.tbxSymptom.ReadOnly = false;
this.dtpDate.Enabled = true;
this.dtpDate.MaxDate = DateTime.Now;
this.cbxBy.Enabled = true;
this.cbxBy.SelectedValue = MainForm.User.UserID;
this.tcMain.TabPages.Remove(this.tabRecord);
}
else
{
this.tbxSymptom.ReadOnly = true;
this.dtpDate.Enabled = false;
this.cbxBy.Enabled = false;
if (!MainForm.User.SuperUser)
{
this.tcMain.TabPages.Remove(this.tabRecord);
}
else
{
this.userLogUC.FillEvent(TypeUtil.DiseaseHistory, DiseaseHistoryID.ToString());
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!ValidateChildren())
{
return;
}
var Stocks = new Dictionary <Int32, Double>();
foreach (DataGridViewRow row in dgvAdd.Rows)
{
var StockID = Convert.ToInt32(row.Cells["StockID"].Value);
var Unit = Convert.ToDouble(row.Cells["Unit"].Value);
if (Stocks.ContainsKey(StockID))
{
Stocks[StockID] += Unit;
}
else
{
Stocks.Add(StockID, Unit);
}
}
var Msg = new StringBuilder();
foreach (KeyValuePair <Int32, Double> Stock in Stocks)
{
var CurrentUnit = this.stockTableAdapter.QueryCurrentUnit(Stock.Key);
if (CurrentUnit < Stock.Value)
{
Msg.Append(String.Format("{0} จำนวนปัจจุบัน:{1} จำนวนที่ต้องการ:{2}\n", stockTableAdapter.GetDataByPK(Stock.Key)[0].Name, CurrentUnit, Stock.Value));
}
}
if (Msg.Length != 0)
{
MessageBox.Show(String.Format("พัสดุไม่พอ \n{0}\n กรุณาลองใหม่อีกครั้ง", Msg), "ข้อผิดผลาด", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (DiseaseHistoryID == 0)
{
DiseaseHistoryID = (int)this.diseaseHistoryTableAdapter.InsertQuery(
Convert.ToInt32(this.cbxBy.SelectedValue),
CowNO,
this.dtpDate.Value,
this.tbxSymptom.Text,
this.tbxTreatment.Text);
if (DiseaseHistoryID > 0)
{
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.DiseaseHistory, DiseaseHistoryID.ToString(), MainForm.User.UserID, 0, DateTime.Now);
var StockRemoveID = 0;
var stockRemoveResult = 0;
if (dgvAdd.Rows.Count > 0)
{
var stockRemoveTableAdapter = new StockRemoveTableAdapter();
StockRemoveID = (int)stockRemoveTableAdapter.InsertQuery(
Convert.ToInt32(dgvAdd.Rows[0].Cells["ByID"].Value),
(DateTime)dgvAdd.Rows[0].Cells["Date"].Value,
2,
CowNO);
userLogTableAdapter.Insert(TypeUtil.StockRemove, StockRemoveID.ToString(), MainForm.User.UserID, 0, DateTime.Now);
}
var stockRemoveListTableAdapter = new StockRemoveListTableAdapter();
foreach (DataGridViewRow row in dgvAdd.Rows)
{
int DiseaseMedicine = (int)diseaseMedicineTableAdapter.InsertQuery(
Convert.ToInt32(row.Cells["ByID"].Value),
DiseaseHistoryID,
Convert.ToInt32(row.Cells["StockID"].Value),
Convert.ToDouble(row.Cells["Unit"].Value),
(DateTime)row.Cells["Date"].Value);
if (DiseaseMedicine > 0)
{
log.Insert(TypeUtil.DiseaseMedicine, DiseaseMedicine.ToString(), MainForm.User.UserID, 0, DateTime.Now);
this.stockTableAdapter.UpdateRemoveUnit(Convert.ToDouble(row.Cells["Unit"].Value), Convert.ToInt32(row.Cells["StockID"].Value));
if (stockRemoveResult == 1)
{
stockRemoveListTableAdapter.Insert(StockRemoveID, Convert.ToInt32(row.Cells["StockID"].Value), Convert.ToDouble(row.Cells["Unit"].Value), null);
}
}
}
DialogResult = DialogUtil.AddSuccess();
}
else
{
DialogResult = DialogUtil.AddError();
}
}
else
{
var StockRemoveID = 0;
if (dgvAdd.Rows.Count > 0)
{
var stockRemoveTableAdapter = new StockRemoveTableAdapter();
StockRemoveID = (int)stockRemoveTableAdapter.InsertQuery(
Convert.ToInt32(dgvAdd.Rows[0].Cells["ByID"].Value),
(DateTime)dgvAdd.Rows[0].Cells["Date"].Value,
2,
CowNO);
userLogTableAdapter.Insert(TypeUtil.StockRemove, StockRemoveID.ToString(), MainForm.User.UserID, 0, DateTime.Now);
}
var stockRemoveListTableAdapter = new StockRemoveListTableAdapter();
foreach (DataGridViewRow row in dgvAdd.Rows)
{
int DiseaseMedicine = (int)diseaseMedicineTableAdapter.InsertQuery(
Convert.ToInt32(row.Cells["ByID"].Value),
DiseaseHistoryID,
Convert.ToInt32(row.Cells["StockID"].Value),
Convert.ToDouble(row.Cells["Unit"].Value),
(DateTime)row.Cells["Date"].Value);
if (DiseaseMedicine < 0)
{
stockTableAdapter.UpdateRemoveUnit(Convert.ToDouble(row.Cells["Unit"].Value), Convert.ToInt32(row.Cells["StockID"].Value));
if (StockRemoveID > 0)
{
stockRemoveListTableAdapter.Insert(StockRemoveID, Convert.ToInt32(row.Cells["StockID"].Value), Convert.ToDouble(row.Cells["Unit"].Value), null);
}
}
}
var log = new UserLogTableAdapter();
log.Insert(TypeUtil.DiseaseHistory, DiseaseHistoryID.ToString(), MainForm.User.UserID, 1, DateTime.Now);
DialogResult = DialogUtil.SaveSuccess();
}
}
