public void SaveTest() { CommodityImpl target = new CommodityImpl(); // TODO: Initialize to an appropriate value string recEmpId = "lk"; // TODO: Initialize to an appropriate value DateTime recDate = DateTime.Parse("2010-12-2"); // TODO: Initialize to an appropriate value List<PurRecEntity> recs = new List<PurRecEntity>(); // TODO: Initialize to an appropriate value PurRecEntity purRecEntity = new PurRecEntity(); // TODO: Initialize to an appropriate value purRecEntity.OrderId = "1"; purRecEntity.DetailId = 11; purRecEntity.CommId = "111"; purRecEntity.AmountReceiving = 2; purRecEntity.Remark = "remarkkkkk"; recs.Add(purRecEntity); purRecEntity = new PurRecEntity(); purRecEntity.OrderId = "1"; purRecEntity.DetailId = 12; purRecEntity.CommId = "112"; purRecEntity.AmountReceiving = 2; recs.Add(purRecEntity); target.POSaveRecv(recEmpId, recDate, recs); Assert.Inconclusive("A method that does not return a value cannot be verified."); }
public void addPurRecvItemTest() { CommodityImpl_Accessor target = new CommodityImpl_Accessor(); // TODO: Initialize to an appropriate value PurRecEntity purRecEntity = new PurRecEntity(); // TODO: Initialize to an appropriate value purRecEntity.OrderId = "1"; purRecEntity.DetailId = 11; purRecEntity.CommId = "111"; purRecEntity.AmountReceiving = 2; purRecEntity.ReceivingEmp = "lk"; purRecEntity.ReveivingDate = "2010-12-10"; purRecEntity.Remark = "remarkkkkk"; target.addPurRecvItem(purRecEntity); }
public List<PurRecEntity> SearchPurRecvListByOrderID(string strPurchaseOrderID) { List<PurRecEntity> purRecEntityList = new List<PurRecEntity>(); string sqlStr = dbUtil.getSqlStatement("SQL_Comd_PurchaseReceiveList_SearchByOrderID"); SqlParameter[] sqlParms = { new SqlParameter("@PurchaseOrderID",SqlDbType.VarChar,20) }; sqlParms[0].Value = strPurchaseOrderID; 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) { PurRecEntity purRecEntity = new PurRecEntity(); purRecEntity.OrderId = dr["PurchaseOrderID"].ToString(); purRecEntity.DetailId = Convert.ToInt32(dr["PurchaseOrderDetailID"]); purRecEntity.CommId = dr["ComdID"].ToString(); purRecEntity.CommName = dr["ComdName"].ToString(); purRecEntity.Standard = dr["ComdStandard"].ToString(); purRecEntity.Unit = dr["Unit"].ToString(); purRecEntity.AmountTotal = Convert.ToInt32(dr["amountTotal"]); purRecEntity.AmountReceived = Convert.ToInt32(dr["amountReceived"]); purRecEntity.AmountReceiving = 0; purRecEntity.Remark = dr["Remark"].ToString(); purRecEntity.ReceivingEmp = dr["ReceivingEmp"].ToString(); purRecEntity.ReveivingDate = dr["ReveivingDate"].ToString(); purRecEntityList.Add(purRecEntity); } } } catch (Exception ex) { throw new DAOException("E0001"); } return purRecEntityList; }
public int AddPurchaseReceiving(PurRecEntity purRecEntity, string currentUser) { string sqlStr = dbUtil.getSqlStatement("SQL_Comd_PurchaseReceiving_Insert"); SqlParameter[] sqlParms = { new SqlParameter("@PurchaseOrderID",SqlDbType.VarChar,20), new SqlParameter("@PurchaseOrderDetailID",SqlDbType.VarChar,20), new SqlParameter("@ComdID",SqlDbType.VarChar,20), new SqlParameter("@amount",SqlDbType.Int), new SqlParameter("@ReceivingEmp",SqlDbType.VarChar,20), new SqlParameter("@ReveivingDate",SqlDbType.VarChar,10), new SqlParameter("@Remark",SqlDbType.NVarChar,800), new SqlParameter("@CreateUser",SqlDbType.VarChar,20), new SqlParameter("@UpdateUser",SqlDbType.VarChar,20) }; sqlParms[0].Value = purRecEntity.OrderId; sqlParms[1].Value = purRecEntity.DetailId; sqlParms[2].Value = purRecEntity.CommId; sqlParms[3].Value = purRecEntity.AmountReceiving; sqlParms[4].Value = purRecEntity.ReceivingEmp; sqlParms[5].Value = purRecEntity.ReveivingDate; sqlParms[6].Value = purRecEntity.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 addPurRecvItem(PurRecEntity purRecEntity) { try { int resultCount = 0; resultCount = comdDAO.AddPurchaseReceiving(purRecEntity, this.currentUser); if (resultCount == 0) { throw new DAOException("E0001"); } } catch (Exception ex) { throw; } }