/// <summary> /// 插入 /// </summary> /// <param name="pware"></param> /// <param name="SQLCommand"></param> /// <returns></returns> public bool insertPWarehouseTable_DetailedBll(PWarehouseTable_Detailed pware, string SQLCommand) { if (pwarDal.insertPWarehouseTable_DetailedDal(pware, SQLCommand) > 0) { return(true); } else { return(false); } }
/// <summary> /// 插入 /// </summary> /// <param name="pware"></param> /// <param name="SQLCommand"></param> /// <returns></returns> public int insertPWarehouseTable_DetailedDal(PWarehouseTable_Detailed pware, string SQLCommand) { string sql = SQLhelp.GetSQLCommand(SQLCommand); SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@PurchaseReceiptID", SqlDbType.VarChar, 100) { Value = pware.PurchaseReceiptID }, new SqlParameter("@PurchaseNo", SqlDbType.VarChar, 80) { Value = pware.PurchaseNo }, new SqlParameter("@SupplierName", SqlDbType.VarChar, 80) { Value = pware.SupplierName }, new SqlParameter("@BatchNo", SqlDbType.VarChar, 80) { Value = pware.BatchNo }, new SqlParameter("@MaterialCode", SqlDbType.VarChar, 80) { Value = pware.MaterialCode }, new SqlParameter("@MaterialName", SqlDbType.VarChar, 80) { Value = pware.MaterialName }, new SqlParameter("@MaterialSpecifications", SqlDbType.VarChar, 80) { Value = pware.MaterialSpecifications }, new SqlParameter("@ProductQuantity", SqlDbType.Int) { Value = pware.ProductQuantity }, new SqlParameter("@note", SqlDbType.VarChar, 200) { Value = pware.note }, new SqlParameter("@StorageAddress", SqlDbType.VarChar, 255) { Value = pware.StorageAddress }, new SqlParameter("@UserName", SqlDbType.VarChar, 50) { Value = pware.UserName } }; return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms)); }
PWarehouseTable_Detailed GetPWarehouseTable_Detailed() { PWarehouseTable_Detailed pwar = new PWarehouseTable_Detailed() { PurchaseReceiptID = TxtBox_PurchaseReceiptID.Text.Trim(), PurchaseNo = TxtBox_PurchaseNo.Text.Trim(), SupplierName = TxtBox_SupplierName.Text.Trim(), BatchNo = TxtBox_BatchNo.Text.Trim(), MaterialCode = TxtBox_MaterialCode.Text.Trim(), MaterialName = TxtBox_MaterialName.Text.Trim(), MaterialSpecifications = TxtBox_MaterialSpecifications.Text.Trim(), ProductQuantity = state == "特采"?ip_ChooseNumber.Value:ip_ProductQuantity.Value, note = NOTE, StorageAddress = txt_StorageAddress.Text.Trim(), UserName = UsersHelp.Userslist[0].UserName }; return(pwar); }