public frmViewDocCheckP23(ref DocCheckProduct _doCheckProduct, ref Form _frmDocCheckP21,ref TextBox _txtBarCode,ref Label _lblmsg)
{
InitializeComponent();
idocCheckProduct = _doCheckProduct;
ifrmDocCheckP21 = _frmDocCheckP21;
itxtBarCode = _txtBarCode;
ilblmsg = _lblmsg;
}
private void cmdbeginCheck_Click(object sender, EventArgs e)
{
DocCheckProduct docCheckProduct = null;
if (ibarcode.Equals("")) {
docCheckProduct = new DocCheckProduct();
}else {
ProductService service = new ProductService();
docCheckProduct =service.getDocCheckProductByCode(ibarcode);
txtPCode.Text = docCheckProduct.Code;
txtWarehouse.Text = docCheckProduct.Warehouse;
txtLocation.Text = docCheckProduct.Location;
}
if (!txtPCode.Text.Trim().Equals(""))
{
docCheckProduct.Code = txtPCode.Text.Trim();
}
else {
MessageBox.Show("��س����͡��͡�Ţ����͡��� !!! ", "����");
txtPCode.Focus();
return;
}
if (!txtWarehouse.Text.Trim().Equals(""))
{
docCheckProduct.Warehouse = txtWarehouse.Text.Trim();
}
else
{
MessageBox.Show("��س����͡��͡��ѧ�Թ��� !!! ", "����");
txtWarehouse.Focus();
return;
}
if (!txtLocation.Text.Trim().Equals(""))
{
docCheckProduct.Location = txtLocation.Text.Trim();
}
else
{
MessageBox.Show("��س����͡��͡ʶҹ��� !!! ", "����");
txtLocation.Focus();
return;
}
frmDocCheckP21 _frmDocCheckP21 = new frmDocCheckP21(docCheckProduct);
_frmDocCheckP21.Show();
this.Hide();
}
public bool saveDocCheckProduct(DocCheckProduct docCheckProduct)
{
bool result = false;
try
{
Conn = OpenConn();
sb = new StringBuilder();
sb.Append("INSERT INTO DocCheckProducts(DCode,Warehouse,Location,CreateDate)");
sb.Append(" VALUES (@DCode,@Warehouse,@Location,@CreateDate)");
string sqlAdd;
sqlAdd = sb.ToString();
tr = Conn.BeginTransaction();
com = new SqlCeCommand();
com.CommandText = sqlAdd;
com.CommandType = CommandType.Text;
com.Connection = Conn;
com.Transaction = tr;
com.Parameters.Clear();
com.Parameters.Add("@DCode", SqlDbType.NVarChar).Value = docCheckProduct.Code;
com.Parameters.Add("@Warehouse", SqlDbType.NVarChar).Value = docCheckProduct.Warehouse;
com.Parameters.Add("@Location", SqlDbType.NVarChar).Value = docCheckProduct.Location;
com.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = DateTime.Now;
com.ExecuteNonQuery();
tr.Commit();
result = true;
}
catch (Exception ex)
{
tr.Rollback();
Conn.Close();
result = false;
Console.WriteLine(ex.Message);
}
finally
{
Conn.Close();
}
return result;
}
public IList<DocCheckProduct> getDocCheckProductByDCode(string _dCode)
{
IList<DocCheckProduct> docCheckProducts = new List<DocCheckProduct>();
DocCheckProduct docCheckProduct = null;
try
{
Conn = OpenConn();
sb = new StringBuilder();
if (_dCode.Equals(""))
{
sb.Append("select ID,DCode,Warehouse,Location,CreateDate from DocCheckProducts ");
}
else
{
sb.Append("select ID,DCode,Warehouse,Location,CreateDate from DocCheckProducts where DCode ='" + _dCode + "'");
}
string sql = "";
sql = sb.ToString();
com = new SqlCeCommand();
com.Connection = Conn;
com.CommandText = sql;
dr = com.ExecuteReader();
{
DataTable dt = new DataTable();
dt.Load(dr);
foreach (DataRow ds in dt.Rows)
{
docCheckProduct = new DocCheckProduct();
docCheckProduct.ID = Convert.ToInt32(ds[0].ToString());
docCheckProduct.Code = Convert.ToString(ds[1].ToString());
docCheckProduct.Warehouse = Convert.ToString(ds[2].ToString());
docCheckProduct.Location = Convert.ToString(ds[3].ToString());
docCheckProduct.CreateDate = Convert.ToDateTime(ds[4].ToString());
docCheckProducts.Add(docCheckProduct);
}
}
dr.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Conn.Close();
}
finally
{
Conn.Close();
}
return docCheckProducts;
}
// getById
public DocCheckProduct getDocCheckProductByCode(object _code)
{
DocCheckProduct docCheckProduct = null;
try
{
Conn = OpenConn();
sb = new StringBuilder();
sb.Append("select ID,DCode,Warehouse,Location,CreateDate from DocCheckProducts d where d.DCode ='" + Convert.ToString(_code) + "'");
string sql = "";
sql = sb.ToString();
com = new SqlCeCommand();
com.Connection = Conn;
com.CommandText = sql;
dr = com.ExecuteReader();
{
DataTable dt = new DataTable();
dt.Load(dr);
foreach (DataRow ds in dt.Rows)
{
docCheckProduct = new DocCheckProduct();
docCheckProduct.ID = Convert.ToInt32(ds[0].ToString());
docCheckProduct.Code = Convert.ToString(ds[1].ToString());
docCheckProduct.Warehouse = Convert.ToString(ds[2].ToString());
docCheckProduct.Location = Convert.ToString(ds[3].ToString());
docCheckProduct.CreateDate = Convert.ToDateTime(ds[4].ToString());
}
}
dr.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Conn.Close();
}
finally
{
Conn.Close();
}
return docCheckProduct;
}
private void cmdSave_Click(object sender, EventArgs e)
{
ProductService service = new ProductService();
Product product = null;
DocCheckProductDetail docCheckProductDetail = new DocCheckProductDetail();
if (this.docCheckProduct != null)
{
docCheckProductDetail.DocCheckProduct = this.docCheckProduct;
mc4.DocCheckProduct _docCheckProduct = new mc4.DocCheckProduct();
_docCheckProduct = new DocCheckProduct();
_docCheckProduct = service.getDocCheckProductByCode(this.docCheckProduct.Code);
if (_docCheckProduct == null)
{
bool saveDocCheck = service.saveDocCheckProduct(this.docCheckProduct);
if (saveDocCheck)
{
Console.WriteLine("Save Compate :");
}
}
}
else {
MessageBox.Show("��س����͡�Ţ����͡��� !!! ", "����");
return;
}
if (!(this.txtBarCode.Text.Trim().Equals("")))
{
product = service.getByBarCode(this.txtBarCode.Text.Trim());
if (product != null)
{
docCheckProductDetail.Product = product;
}
}
else
{
MessageBox.Show("��س����͡������ !!! ", "����");
txtBarCode.Focus();
return;
}
if (!(this.txtNumber.Text.Trim().Equals("")))
{
docCheckProductDetail.DocCheckProduct = this.docCheckProduct;
docCheckProductDetail.Product = product;
docCheckProductDetail.NumProduct = Convert.ToInt32(this.txtNumber.Text.Trim());
bool save = service.saveDocCheckProductDetail(docCheckProductDetail);
if (save)
{
//MessageBox.Show("�ѹ�֡���º���� !!! ", "����");
lblmsg.Visible = true;
lblmsg.Text = "�ѹ�֡���º��������";
clearData();
Console.WriteLine("Save Compate :");
}
}
else
{
MessageBox.Show("��س����͡��͡�ӹǹ�Ѻ !!! ", "����");
txtNumber.Focus();
return;
}
}
public frmDocCheckP21(DocCheckProduct _docCheckProduct)
{
InitializeComponent();
this.DocCheckProduct = _docCheckProduct;
}
