public static INProduct ConvertToInfo(DataRow dr)
{
INProduct _inproduct = new INProduct();
_inproduct.ProductID = dr["ProductID"].ToString();
_inproduct.Descr = dr["Descr"].ToString();
_inproduct.ClassID1 = dr["ClassID1"].ToString();
_inproduct.ClassID2 = dr["ClassID2"].ToString();
_inproduct.VendID = dr["VendID"].ToString();
_inproduct.Status = dr["Status"].ToString();
_inproduct.FromUnit = dr["FromUnit"].ToString();
_inproduct.ToUnit = dr["ToUnit"].ToString();
_inproduct.Cnvfact = float.Parse(dr["Cnvfact"].ToString());
_inproduct.POFromUnitPrice = float.Parse(dr["POFromUnitPrice"].ToString());
_inproduct.POToUnitPrice = float.Parse(dr["POToUnitPrice"].ToString());
if (dr["POPriEffDate"].ToString()!= "")
_inproduct.POPriEffDate = DateTime.Parse(dr["POPriEffDate"].ToString());
_inproduct.SOFromUnitPrice = float.Parse(dr["SOFromUnitPrice"].ToString());
_inproduct.SOToUnitPrice = float.Parse(dr["SOToUnitPrice"].ToString());
_inproduct.POUnit = dr["POUnit"].ToString();
_inproduct.SOUnit = dr["SOUnit"].ToString();
_inproduct.INUnit = dr["INUnit"].ToString();
_inproduct.Color = dr["Color"].ToString();
_inproduct.DfltWhID = dr["DfltWhID"].ToString();
_inproduct.Picture = dr["Picture"].ToString();
_inproduct.Size = dr["Size"].ToString();
_inproduct.Volume = float.Parse(dr["Volume"].ToString());
_inproduct.Weight = float.Parse(dr["Weight"].ToString());
_inproduct.Style = dr["Style"].ToString();
_inproduct.TaxID = dr["TaxID"].ToString();
_inproduct.Crtd_DateTime = DateTime.Parse(dr["Crtd_DateTime"].ToString());
_inproduct.Crtd_Prog = dr["Crtd_Prog"].ToString();
_inproduct.Crtd_User = dr["Crtd_User"].ToString();
return _inproduct;
}
private INProduct _GetProduct(string _productID)
{
INProduct _info = new INProduct();
DataRow[] _dr = null;
_dr = _dtINProduct.Select(string.Format("ProductID = '{0}'", _productID));
if (_dr.Length > 0)
_info = IN106Ctrl.ConvertToInfo(_dr[0]);
else
_info = null;
return _info;
}
private INProduct _GetProduct(int _row)
{
INProduct _info = new INProduct();
_info.ProductID = dgv.Rows[_row].Cells["ProductID"].Value.ToString().Trim();
_info.Descr = dgv.Rows[_row].Cells["Descr"].Value.ToString();
_info.ClassID1 = dgv.Rows[_row].Cells["ClassID1"].Value.ToString();
_info.ClassID2 = dgv.Rows[_row].Cells["ClassID2"].Value.ToString();
_info.VendID = dgv.Rows[_row].Cells["VendID"].Value.ToString();
_info.Status = dgv.Rows[_row].Cells["Status"].Value.ToString();
_info.FromUnit = dgv.Rows[_row].Cells["FromUnit"].Value.ToString();
_info.ToUnit = dgv.Rows[_row].Cells["ToUnit"].Value.ToString();
_info.Cnvfact = double.Parse(dgv.Rows[_row].Cells["Cnvfact"].Value.ToString());
_info.POFromUnitPrice = double.Parse(dgv.Rows[_row].Cells["POFromUnitPrice"].Value.ToString());
_info.POToUnitPrice = double.Parse(dgv.Rows[_row].Cells["POToUnitPrice"].Value.ToString());
if (dgv.Rows[_row].Cells["POPriEffDate"].Value.ToString() != "")
_info.POPriEffDate = DateTime.Parse(dgv.Rows[_row].Cells["POPriEffDate"].Value.ToString());
if (dgv.Rows[_row].Cells["SOPriEffDate"].Value.ToString() != "")
_info.SOPriEffDate = DateTime.Parse(dgv.Rows[_row].Cells["SOPriEffDate"].Value.ToString());
_info.SOFromUnitPrice = double.Parse(dgv.Rows[_row].Cells["SOFromUnitPrice"].Value.ToString());
_info.SOToUnitPrice = double.Parse(dgv.Rows[_row].Cells["SOToUnitPrice"].Value.ToString());
_info.POUnit = dgv.Rows[_row].Cells["POUnit"].Value.ToString();
_info.SOUnit = dgv.Rows[_row].Cells["SOUnit"].Value.ToString();
_info.INUnit = dgv.Rows[_row].Cells["INUnit"].Value.ToString();
_info.Color = dgv.Rows[_row].Cells["Color"].Value.ToString();
_info.DfltWhID = dgv.Rows[_row].Cells["DfltWhID"].Value.ToString();
_info.Picture = dgv.Rows[_row].Cells["Picture"].Value.ToString();
_info.Size = dgv.Rows[_row].Cells["Size"].Value.ToString();
_info.Volume = double.Parse(dgv.Rows[_row].Cells["Volume"].Value.ToString());
_info.Weight = double.Parse(dgv.Rows[_row].Cells["Weight"].Value.ToString());
_info.Style = dgv.Rows[_row].Cells["Style"].Value.ToString();
_info.TaxID = dgv.Rows[_row].Cells["TaxID"].Value.ToString();
_info.Crtd_DateTime = DateTime.Parse(dgv.Rows[_row].Cells["Crtd_DateTime"].Value.ToString());
_info.Crtd_Prog = dgv.Rows[_row].Cells["Crtd_Prog"].Value.ToString(); ;
_info.Crtd_User = dgv.Rows[_row].Cells["Crtd_User"].Value.ToString(); ;
_info.LUpd_DateTime = DateTime.Parse(dgv.Rows[_row].Cells["LUpd_DateTime"].Value.ToString());
_info.LUpd_Prog = dgv.Rows[_row].Cells["LUpd_Prog"].Value.ToString(); ;
_info.LUpd_User = dgv.Rows[_row].Cells["LUpd_User"].Value.ToString(); ;
return _info;
}
private INProduct _GetPanel()
{
INProduct info = new INProduct();
info.ProductID = txtProductID.Text.Trim();
info.Descr = txtDesc.Text.Trim();
info.ClassID1 = txtClassID1.Text.Trim();
info.ClassID2 = txtClassID2.Text.Trim();
info.VendID = txtVendID.Text.Trim();
if (chkStatus.Checked == true)
info.Status = "1";
else
info.Status = "0";
if (txtFromUnit.SelectedValue == null)
info.FromUnit = "";
else
info.FromUnit = txtFromUnit.SelectedValue.ToString();
if (txtToUnit.SelectedValue == null)
info.ToUnit = "";
else
info.ToUnit = txtToUnit.SelectedValue.ToString();
if (txtCnvfact.Text.Trim() != "")
info.Cnvfact = double.Parse(txtCnvfact.Text.Trim());
if (txtPOFromUnitPrice.Text.Trim() != "")
info.POFromUnitPrice = double.Parse(txtPOFromUnitPrice.Text.Trim());
if (txtPOToUnitPrice.Text.Trim() != "")
info.POToUnitPrice = double.Parse(txtPOToUnitPrice.Text.Trim());
if (txtSOFromUnitPrice.Text.Trim() != "")
info.SOFromUnitPrice = double.Parse(txtSOFromUnitPrice.Text.Trim());
if (txtSOToUnitPrice.Text.Trim() != "")
info.SOToUnitPrice = double.Parse(txtSOToUnitPrice.Text.Trim());
info.POPriEffDate = dtiPOPriEffDate.Value;
info.SOPriEffDate = dtiSOPriEffDate.Value;
if (txtPOUnit.SelectedValue == null)
info.POUnit = "";
else
info.POUnit = txtPOUnit.SelectedValue.ToString();
if (txtSOUnit.SelectedValue == null)
info.SOUnit = "";
else
info.SOUnit = txtSOUnit.SelectedValue.ToString();
if (txtINUnit.SelectedValue == null)
info.INUnit = "";
else
info.INUnit = txtINUnit.SelectedValue.ToString();
if (txtDfltWhID.SelectedValue == null)
info.DfltWhID = "";
else
info.DfltWhID = txtDfltWhID.SelectedValue.ToString();
info.Color = txtColor.Text.Trim();
info.Picture = txtPicture.Text.Trim();
info.Size = txtSize.Text.Trim();
if (txtVolume.Text.Trim() != "")
info.Volume = double.Parse(txtVolume.Text.Trim());
if (txtWeight.Text.Trim() != "")
info.Weight = double.Parse(txtWeight.Text.Trim());
info.Style = txtStyle.Text.Trim();
info.TaxID = txtTaxID.SelectedValue.ToString();
info.Crtd_DateTime = dtiCrtd_DateTime.Value;
info.Crtd_Prog = txtCrtd_Prog.Text.Trim();
info.Crtd_User = txtCrtd_User.Text.Trim();
info.LUpd_DateTime = DateTime.Now;
info.LUpd_Prog = _strPro;
info.LUpd_User = Globals.PTUserName;
return info;
}
private void btnCopy_Click(object sender, EventArgs e)
{
string copy = txtCopy.Text.Trim();
string proid = txtProductID.Text.Trim();
if (copy == "")
{
Utility.MessageShow("001", Globals.PTLanguage, "ProductID");
txtCopy.Focus();
return;
}
if (_dtINProduct.Rows.Count > 0)
{
DataRow[] dr = _dtINProduct.Select(string.Format("ProductID = '{0}'", copy));
if (dr.Count() <= 0)
{
MessageBox.Show("ProductID khong ton tai", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCopy.Focus();
txtCopy.SelectionStart = 0;
txtCopy.SelectionLength = copy.Length;
return;
}
else
{
INProduct p = new INProduct();
p = _GetProduct(copy);
_AddToPanel(p);
_BindDataToPanel();
dgv.Visible = false;
pnl.Visible = true;
txtProductID.Enabled = true;
txtProductID.Text = copy + "-1";
txtProductID.Focus();
txtProductID.SelectionStart = 0;
txtProductID.SelectionLength = txtProductID.Text.Length; ;
}
}
}
private void _AddToPanel(INProduct _info)
{
if (_info != null)
{
txtProductID.Text = _info.ProductID.ToString();
txtDesc.Text = _info.Descr.ToString();
txtClassID1.Text = _info.ClassID1.ToString();
txtClassID2.Text = _info.ClassID2.ToString();
txtVendID.SelectedValue = _info.VendID.ToString();
if (_info.Status == "True")
chkStatus.Checked = true;
else
chkStatus.Checked = false;
//cbxStatus.Text = _info.Status.ToString();
txtFromUnit.SelectedValue = _info.FromUnit.ToString();
txtToUnit.SelectedValue = _info.ToUnit.ToString();
_BindUnit();
txtCnvfact.Text = _info.Cnvfact.ToString();
txtPOFromUnitPrice.Text = _info.POFromUnitPrice.ToString();
txtPOToUnitPrice.Text = _info.POToUnitPrice.ToString();
if (_info.POPriEffDate.ToString() != "")
dtiPOPriEffDate.Value = _info.POPriEffDate;
txtSOFromUnitPrice.Text = _info.SOFromUnitPrice.ToString();
txtSOToUnitPrice.Text = _info.SOToUnitPrice.ToString();
if (_info.SOPriEffDate.ToString() != "")
dtiSOPriEffDate.Value = _info.SOPriEffDate;
txtPOUnit.SelectedValue = _info.POUnit.ToString();
txtSOUnit.SelectedValue = _info.SOUnit.ToString();
txtINUnit.SelectedValue = _info.INUnit.ToString();
txtColor.Text = _info.Color.ToString();
txtDfltWhID.SelectedValue = _info.DfltWhID.ToString();
txtPicture.Text = _info.Picture.ToString();
txtSize.Text = _info.Size.ToString();
txtVolume.Text = _info.Volume.ToString();
txtWeight.Text = _info.Weight.ToString();
txtStyle.Text = _info.Style.ToString();
txtTaxID.SelectedValue = _info.TaxID.ToString();
txtProductID.Text = _info.ProductID;
txtProductID.Enabled = false;
if (_info.Crtd_DateTime.ToString() == "")
dtiCrtd_DateTime.Value = DateTime.Now;
else
dtiCrtd_DateTime.Value = _info.Crtd_DateTime;
txtCrtd_Prog.Text = _info.Crtd_Prog.ToString();
txtCrtd_User.Text = _info.Crtd_User.ToString();
}
}
private void dgv_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
pnldgv.Visible = false;
pnl.Visible = false;
pnl.Dock = DockStyle.Fill;
pnldgv.Dock = DockStyle.Fill;
INProduct _info = new INProduct();
_info = _GetProduct(e.RowIndex);
_BindDataToPanel();
_AddToPanel(_info);
_strStage = 1;
txtCopy.Enabled = false;
btnCopy.Enabled = false;
btnSave.Enabled = true;
btnDelete.Enabled = true;
btnBack.Enabled = true;
pnl.Visible = true;
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgv.Visible == true)
{
Int32 _intTotalRow = dgv.Rows.GetRowCount(DataGridViewElementStates.Selected);
if (_intTotalRow > 0)
{
if (MessageBox.Show("Bạn có muốn xóa '" + _intTotalRow +
"' dòng được chọn không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
for (int i = 0; i < _intTotalRow; i++)
{
int _row = Int16.Parse(dgv.SelectedRows[i].Index.ToString());
_DeleteRow(_row);
}
_BindGrid();
}
}
}
else if (pnl.Visible == true)
{
string _strProductID = txtProductID.Text.Trim();
if (IN106Ctrl.CheckProductUsed(_strProductID) == false)
{
int _row1 = _GetProductRow(_strProductID);
if (_row1 == -1)
return;
if (MessageBox.Show("Mã sản phẩm: '" + _strProductID +
"' không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
int _row = _GetProductRow(_strProductID);
INProduct _INProduct = new INProduct();
_INProduct = _GetProduct(_row + 1);
_DeleteRow(_strProductID);
_BindGrid();
_RefreshPanel();
_AddToPanel(_INProduct);
}
}
else
MessageBox.Show("Mã sản phẩm: " + _strProductID +
" đang được dùng, bạn không thể xóa được.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static int SaveProduct( INProduct info)
{
SqlDateTime strPOPriEffDate;
if (info.POPriEffDate.ToString() == "1/1/0001 12:00:00 AM")
strPOPriEffDate = SqlDateTime.Null;
else
strPOPriEffDate = info.POPriEffDate;
SqlDateTime strSOPriEffDate;
if (info.SOPriEffDate.ToString() == "1/1/0001 12:00:00 AM")
strSOPriEffDate = SqlDateTime.Null;
else
strSOPriEffDate = info.SOPriEffDate;
return ConnectDB.ExecuteScalar("sp_ProductSave",
new String[] { "ProductID" ,"Descr","ClassID2" ,"ClassID1" ,"VendID" ,"Status" ,
"FromUnit" ,"ToUnit" ,"Cnvfact" ,"POFromUnitPrice" ,"POToUnitPrice" ,"POPriEffDate" ,
"SOFromUnitPrice" ,"SOToUnitPrice" ,"SOPriEffDate" ,"POUnit" ,"SOUnit" ,"INUnit" ,
"Color" ,"DfltWhID" ,"Picture" ,"Size" ,"Volume" ,"Weight" ,
"Style" ,"TaxID" ,"Crtd_DateTime" ,"Crtd_Prog" ,"Crtd_User" ,
"LUpd_DateTime" ,"LUpd_Prog" ,"LUpd_User"},
new Object[] { info.ProductID, info.Descr, info.ClassID2, info.ClassID1, info.VendID, info.Status,
info.FromUnit, info.ToUnit, info.Cnvfact, info.POFromUnitPrice, info.POToUnitPrice,strPOPriEffDate,
info.SOFromUnitPrice,info.SOToUnitPrice,strSOPriEffDate,info.POUnit,info.SOUnit,info.INUnit,
info.Color,info.DfltWhID,info.Picture,info.Size,info.Volume,info.Weight,
info.Style,info.TaxID,info.Crtd_DateTime,info.Crtd_Prog,info.Crtd_User,
info.LUpd_DateTime,info.LUpd_Prog,info.LUpd_User});
}