public List<SaleDeliveryEntity> SearchSaleDeliveryListByOrderID(string strSaleOrderID) { List<SaleDeliveryEntity> saleDeliveryEntityList = new List<SaleDeliveryEntity>(); string sqlStr = dbUtil.getSqlStatement("SQL_Comd_SaleDeliveryList_SearchByOrderID"); SqlParameter[] sqlParms = { new SqlParameter("@SaleOrderID",SqlDbType.VarChar,20) }; sqlParms[0].Value = strSaleOrderID; DataSet searchResult = null; try { searchResult = DAO.DBAccess.ExecuteAdapter(DAO.DBAccess.SQLConnectionString, CommandType.Text, sqlStr, sqlParms); foreach (DataTable dt in searchResult.Tables) { foreach (DataRow dr in dt.Rows) { SaleDeliveryEntity saleDeliveryEntity = new SaleDeliveryEntity(); saleDeliveryEntity.OrderId = dr["SaleOrderID"].ToString(); saleDeliveryEntity.DetailId = Convert.ToInt32(dr["SaleOrderDetailID"]); saleDeliveryEntity.CommId = dr["ComdID"].ToString(); saleDeliveryEntity.CommName = dr["ComdName"].ToString(); saleDeliveryEntity.Standard = dr["ComdStandard"].ToString(); saleDeliveryEntity.Unit = dr["Unit"].ToString(); saleDeliveryEntity.AmountTotal = Convert.ToInt32(dr["amountTotal"]); saleDeliveryEntity.AmountDelivered = Convert.ToInt32(dr["amountDelivered"]); saleDeliveryEntity.AmountDelivering = 0; saleDeliveryEntity.Remark = dr["Remark"].ToString(); saleDeliveryEntity.DeliveringEmp = dr["DeliveryEmp"].ToString(); saleDeliveryEntity.DeliveringDate = dr["DeliveryDate"].ToString(); saleDeliveryEntityList.Add(saleDeliveryEntity); } } } catch (Exception ex) { throw new DAOException("E0001"); } return saleDeliveryEntityList; }
public int AddSaleDelivery(SaleDeliveryEntity saleDeliveryEntity, string currentUser) { string sqlStr = dbUtil.getSqlStatement("SQL_Comd_SaleDelivery_Insert"); SqlParameter[] sqlParms = { new SqlParameter("@SaleOrderID",SqlDbType.VarChar,20), new SqlParameter("@SaleOrderDetailID",SqlDbType.VarChar,20), new SqlParameter("@ComdID",SqlDbType.VarChar,20), new SqlParameter("@amount",SqlDbType.Int), new SqlParameter("@DeliveryEmp",SqlDbType.VarChar,20), new SqlParameter("@DeliveryDate",SqlDbType.VarChar,10), new SqlParameter("@Remark",SqlDbType.NVarChar,800), new SqlParameter("@CreateUser",SqlDbType.VarChar,20), new SqlParameter("@UpdateUser",SqlDbType.VarChar,20) }; sqlParms[0].Value = saleDeliveryEntity.OrderId; sqlParms[1].Value = saleDeliveryEntity.DetailId; sqlParms[2].Value = saleDeliveryEntity.CommId; sqlParms[3].Value = saleDeliveryEntity.AmountDelivering; sqlParms[4].Value = saleDeliveryEntity.DeliveringEmp; sqlParms[5].Value = saleDeliveryEntity.DeliveringDate; sqlParms[6].Value = saleDeliveryEntity.Remark; sqlParms[7].Value = currentUser; sqlParms[8].Value = currentUser; int resultCount = 0; try { resultCount = (int)DAO.DBAccess.ExecuteNonQuery(DAO.DBAccess.SQLConnectionString, CommandType.Text, sqlStr, sqlParms); } catch (Exception ex) { throw new DAOException("E0001"); } return resultCount; }
private void addSaleDeliveryItem(SaleDeliveryEntity saleDeliveryEntity) { try { int resultCount = 0; resultCount = comdDAO.AddSaleDelivery(saleDeliveryEntity, this.currentUser); if (resultCount == 0) { throw new DAOException("E0001"); } } catch (Exception ex) { throw; } }