// getById public IList<DocCheckProductDetail> getDocCheckProductDetailByDCodeAndPName(object _dCode,string _pName) { IList<DocCheckProductDetail> docCheckProductDetails = new List<DocCheckProductDetail>(); DocCheckProductDetail docCheckProductDetail = null; try { Conn = OpenConn(); sb = new StringBuilder(); sb.Append(" select d.ID,d.DCode,d.PCode,d.NumProduct,d.CreateDate "); sb.Append(" from DocCheckProductDetails d,Products p"); sb.Append(" where d.PCode = p.BarCode"); sb.Append(" and d.DCode='" + _dCode + "'"); sb.Append(" and p.Name like '%" + _pName + "%'"); 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) { docCheckProductDetail = new DocCheckProductDetail(); docCheckProductDetail.ID = Convert.ToInt32(ds[0].ToString()); DocCheckProduct docCheckProduct = getDocCheckProductByCode(Convert.ToString(ds[1].ToString())); docCheckProductDetail.DocCheckProduct = docCheckProduct; Product product = getByBarCode(Convert.ToString(ds[2].ToString())); docCheckProductDetail.Product = product; docCheckProductDetail.NumProduct = Convert.ToInt32(ds[3].ToString()); docCheckProductDetail.CreateDate = Convert.ToDateTime(ds[4].ToString()); docCheckProductDetails.Add(docCheckProductDetail); } } dr.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); Conn.Close(); } finally { Conn.Close(); } return docCheckProductDetails; }
public bool saveDocCheckProductDetail(DocCheckProductDetail docCheckProductDetail) { bool result = false; try { Conn = OpenConn(); sb = new StringBuilder(); sb.Append("INSERT INTO DocCheckProductDetails(DCode,PCode,PName,PUnit,NumProduct,CreateDate)"); sb.Append(" VALUES (@DCode,@PCode,@PName,@PUnit,@NumProduct,@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 = docCheckProductDetail.DocCheckProduct.Code; com.Parameters.Add("@PCode", SqlDbType.NVarChar).Value = docCheckProductDetail.Product.BarCode; com.Parameters.Add("@PName", SqlDbType.NVarChar).Value = docCheckProductDetail.Product.Name; com.Parameters.Add("@PUnit", SqlDbType.NVarChar).Value = docCheckProductDetail.Product.Unit; com.Parameters.Add("@NumProduct", SqlDbType.NVarChar).Value = docCheckProductDetail.NumProduct; 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; }
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; } }