public bool UpdateData(string userID, ControlStockData data)
{
bool ret = true;
ProductMinMaxDAL oDAL = new ProductMinMaxDAL();
oDAL.GetDataByLOID(data.LOID, null);
oDAL.STANDARD = Convert.ToDouble(data.STANDARD);
oDAL.MINIMUM = Convert.ToDouble(data.MINIMUM);
oDAL.MAXIMUM = Convert.ToDouble(data.MAXIMUM);
ret = oDAL.UpdateCurrentData(userID, null);
if (!ret)
{
_error = oDAL.ErrorMessage;
}
return ret;
}
public bool InsertData(string userID, ControlStockData data)
{
Boolean ret = true;
ProductMinMaxDAL oDAL = new ProductMinMaxDAL();
oDAL.PRODUCT = Convert.ToInt32(data.PRODUCT);
oDAL.WAREHOUSE = Convert.ToInt32(data.WAREHOUSE);
oDAL.STANDARD = Convert.ToDouble(data.STANDARD);
oDAL.MINIMUM = Convert.ToDouble(data.MINIMUM);
oDAL.MAXIMUM = Convert.ToDouble(data.MAXIMUM);
oDAL.ACTIVE = Convert.ToInt32(data.ACTIVE);
ret = oDAL.InsertCurrentData(userID, null);
if (ret == false)
_error = oDAL.ErrorMessage;
else
_LOID = oDAL.LOID;
return ret;
}
private void btnSave_Click(object sender, EventArgs e)
{
bool ret = true;
//Insert ������
//Check �����Թ���
if (txtCode.Text == "")
{
Appz.OpenWarningDialog("��سҡ�͡�����Թ���");
}
//Check �����Թ���
if (txtProductDetail.Text == "")
{
Appz.OpenWarningDialog("��سҡ�͡�����Թ���");
}
//Check ����ҳ�����
if (txtStandard.Text == "")
{
Appz.OpenWarningDialog("��سҡ�͡����ҳ�����");
return;
}
//Check ����ҳ����ش
if (txtMinimum.Text == "")
{
Appz.OpenWarningDialog("��سҡ�͡����ҳ����ش");
return;
}
//Check ����ҳ�٧�ش
if (txtMaximum.Text == "")
{
Appz.OpenWarningDialog("��سҡ�͡����ҳ�٧�ش");
return;
}
// Check ����ҳ����ش < ����ҳ����� < ����ҳ�٧�ش
if ((Convert.ToDouble(txtMinimum.Text) > Convert.ToDouble(txtStandard.Text)) || (Convert.ToDouble(txtMinimum.Text) > Convert.ToDouble(txtMaximum.Text)) || (Convert.ToDouble(txtStandard.Text) > Convert.ToDouble(txtMaximum.Text)))
{
Appz.OpenWarningDialog("�������ö����¡���� ��س��к� ����ҳ����ش < ����ҳ����� < ����ҳ�٧�ش");
return;
}
//Check �ӹǹ����͡㹪�ͧ����ҳ�٧�ش��ͧ���¡��� 100,000,000.00
if (Convert.ToDouble(txtMaximum.Text) > 10000000.00)
{
Appz.OpenWarningDialog("��س��кبӹǹ����� 0.00 � 9,999,999,999.99 ");
return;
}
//Check �ӹǹ����͡㹪�ͧ����ҳ����ش��ͧ���¡��� 100,000,000.00
if (Convert.ToDouble(txtMinimum.Text) > 10000000.00)
{
Appz.OpenWarningDialog("��س��кبӹǹ����� 0.00 � 9,999,999,999.99 ");
return;
}
//Check �ӹǹ����͡㹪�ͧ����ҳ������ͧ���¡��� 100,000,000.00
if (Convert.ToDouble(txtStandard.Text) > 10000000.00)
{
Appz.OpenWarningDialog("��س��кبӹǹ����� 0.00 � 9,999,999,999.99 ");
return;
}
btnSearchProduct.Enabled = false;
//update ������
if (!this.txtCode.Enabled)
{
ControlStockData CsData = new ControlStockData();
ControlStockFlow csFlow = new ControlStockFlow();
CsData.LOID = Convert.ToDouble(txtPMLoid.Text.Trim());
CsData.STANDARD = txtStandard.Text;
CsData.MINIMUM = txtMinimum.Text;
CsData.MAXIMUM = txtMaximum.Text;
CsData.WAREHOUSE = Convert.ToDouble(this.txtWHLoid.Text);
ret = csFlow.UpdateData(txtPMLoid.Text.Trim(), CsData);
if (!ret)
Appz.OpenErrorDialog(csFlow.ErrorMessage);
else
{
Appz.OpenInformationDialog("�ѹ�֡���������º����");
LoadData();
}
}
else
{
ControlStockData CsData = new ControlStockData();
ControlStockFlow csFlow = new ControlStockFlow();
CsData.PRODUCT = Convert.ToDouble(txtPLoid.Text);
CsData.WAREHOUSE = Convert.ToDouble(txtWHLoid.Text);
CsData.STANDARD = txtStandard.Text;
CsData.MINIMUM = txtMinimum.Text;
CsData.MAXIMUM = txtMaximum.Text;
ret = csFlow.InsertData(Appz.CurrentUserData.UserID.ToString(), CsData);
if (!ret)
Appz.OpenErrorDialog(csFlow.ErrorMessage);
else
{
txtPMLoid.Text = csFlow.GetLoid.ToString();
txtCode.Enabled = false;
Appz.OpenInformationDialog("�ѹ�֡���������º����");
LoadData();
}
}
}
public bool DeleteData(string userID, ControlStockData data)
{
bool ret = true;
ProductMinMaxDAL oDAL = new ProductMinMaxDAL();
oDAL.LOID = Convert.ToDouble(data.LOID);
ret = oDAL.DeleteCurrentData(null);
if (ret == false)
_error = oDAL.ErrorMessage;
return ret;
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (Appz.OpenQuestionDialog("��ͧ���ź�������������?") == DialogResult.OK)
{
bool ret = true;
ControlStockData CsData = new ControlStockData();
ControlStockFlow csFlow = new ControlStockFlow();
CsData.LOID = Convert.ToDouble(txtPMLoid.Text);
ret = csFlow.DeleteData("test", CsData);
if (!ret)
MessageBox.Show(csFlow.ErrorMessage);
else
LoadData();
}
btnSearchProduct.Enabled = false;
}